| From: | Carsten Klein <c(dot)klein(at)datagis(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Connect to specific cluster on command line |
| Date: | 2022-05-25 14:30:06 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi there,
how can I connect to a specific cluster on the command line, e. g. with
psql, pg_dump or pg_dumpall?
pg_lsclusters returns a list of all clusters available:
Ver Cluster Port [...]
14 main 5432 ...
14 test 5433 ...
I want to connect to or dump database xyz in the test cluster. Is it
sufficient to specify the cluster's port only?
Perl script pg_backupcluster calls psql and pg_dump with a --cluster option:
pg_dump --cluster 14/test ...
However, this option is not documented (at least I didn't find anything)
and also I didn't find anything in the sources on GitHub.
Actually, I only have the 14/main instance and cannot really test
accessing the `test` cluster. However, psql and pg_dump actually work
with --cluster 14/main and report an error when I specify 14/test so,
the option --cluster seems to work. Is it intentionally not documented?
So, whats the recommended way to connect to a specific cluster? Is it
just the port?
Regards, Carsten
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Krishna | 2022-05-25 14:30:16 | Re: existing row not found by SELECT ... WHERE CTID = ? |
| Previous Message | Rob Sargent | 2022-05-25 14:27:35 | Re: connect permission based on database name |