Pgbackrest version 2.28 Bug/Issue
Hi ,
We are getting the below issue while executing the backup through
pgbackrest.
2021-03-02 02:10:01.620 P00 INFO: backup command begin 2.28:
--archive-check --archive-copy --compress --db-timeout=7200
--log-level-console=detail --log-level-file=detail
--log-level-stderr=detail --log-path=/apayrman/pgbackrest/backup/log
--pg1-path=/apayothr/pgsql/12.3/data --process-max=12
--protocol-timeout=9000 --repo1-path=/apayrman/pgbackrest
--repo1-retention-archive=8 --repo1-retention-full=2 --stanza=uatpgdbserver
--start-fast --stop-auto
2021-03-02 02:10:01.622 P00 WARN: unable to check pg-1: [DbConnectError]
unable to connect to 'dbname='postgres' port=5432': could not connect to
server: No such file or directory
Is the server running locally and
accepting
connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?
2021-03-02 02:10:01.622 P00 ERROR: [056]: unable to find primary cluster -
cannot proceed
2021-03-02 02:10:01.622 P00 INFO: backup command end: aborted with
exception [056]
DB version :- postgresql 12.3(open source)
OS :- Centos8
Pgbackrest version :- 2.28
Pgbackrest.conf parameters :-
[uatpgdbserver]
pg1-path=/apayothr/pgsql/12.3/data
db-timeout=7200
db1-user=postgres
[global]
repo1-path=/apayrman/pgbackrest
compress=y
retention-archive=8
retention-full=2
process-max=12
log-path=/apayrman/pgbackrest/backup/log
start-fast=y
stop-auto=y
protocol-timeout=9000
archive-check=y
archive-copy=y
Please suggest the solution for above issue.
Thanks,
Singh
On Tue, 2 Mar 2021 at 21:53, Brajendra Pratap Singh
<singh.bpratap766@gmail.com> wrote:
We are getting the below issue while executing the backup through pgbackrest.
2021-03-02 02:10:01.622 P00 ERROR: [056]: unable to find primary cluster - cannot proceed
That's not an error that's coming from PostgreSQL.
You might have better luck asking the authors of pgbackrest. Check
their website for details on how they want issues reported.
David
On Tue, 2021-03-02 at 14:16 +0530, Brajendra Pratap Singh wrote:
unable to connect to 'dbname='postgres' port=5432': could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
it's telling you right here why it failed; and what to check for.
you've configured pgbackrest to connect to the local postgres db using
the unix domain socket. That socket was not present when you attempted
to run pgbackrest.