2022-07-31 18:08:48 +09:30
|
|
|
# multipg2csv
|
|
|
|
|
|
|
|
|
|
multipg2csv allows you to run a single query against multiple postgresql instances
|
|
|
|
|
simultaneously, collecting the results into a collection of csv files packaged
|
|
|
|
|
in a zip archive.
|
|
|
|
|
|
|
|
|
|
## Installation
|
|
|
|
|
|
|
|
|
|
From source:
|
|
|
|
|
|
|
|
|
|
go install github.com/tardisx/multipg2csv@latest
|
|
|
|
|
|
|
|
|
|
Binaries:
|
|
|
|
|
|
|
|
|
|
... coming soon
|
|
|
|
|
|
|
|
|
|
## Usage
|
|
|
|
|
|
|
|
|
|
multipg2csv -query 'SELECT * FROM pg_stats_all_indexes;' -output index_stats.zip postgresql://server1/db1 postgresql://server2/db2
|
|
|
|
|
|
|
|
|
|
Or maybe leverage your shell:
|
|
|
|
|
|
|
|
|
|
multipg2csv -query 'SELECT * FROM pg_stats_all_indexes;' -output index_stats.zip postgresql://db{1..20}/somedb
|
|
|
|
|
|
|
|
|
|
PostgreSQL connection URL's are described here: https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING
|
|
|
|
|
|
2022-07-31 18:10:55 +09:30
|
|
|
Note that `multipg2csv` will use your `.pgpass` file if available, and you should definitely use it,
|
2022-07-31 18:08:48 +09:30
|
|
|
instead of supplying passwords on the command line.
|
2022-07-31 18:10:11 +09:30
|
|
|
|
|
|
|
|
# Known bugs
|
|
|
|
|
|
|
|
|
|
* Quitting while transfers are still in progress does not work correctly.
|
