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: | fb28c2b8-445c-0d9b-e12a-0fc827f6c1f8@datagis.com |
Views: | Raw Message | Whole Thread | 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 |