From: | KK CHN <kkchn(dot)in(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | pgBackRest on old installation |
Date: | 2023-11-20 10:31:27 |
Message-ID: | CAKgGyB_cZeZRPogfZkjz5eWYhkO_bCi8uw4YqyHuLwGwL_csPg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
list,
I am trying pgBackRest on an RHEL 7.6 and old EDB 10 database cluster( a
legacy application.)
I have installed pgbackrest through package install on RHEL7.6
But unable to get the basic stanza-creation working It throws an error.
* /etc/pgbackrest.conf as follows..*
################################################
[demo]
pg1-path=/app/edb/as10/data
pg1-port = 5444
pg1-socket-path=/tmp
[global]
repo1-cipher-pass=sUAeceWoDffSz9Q/d8sWREHe+wte3uOO9lggn5/5mTkQEempvBxQk5UbxsrDzHbw
repo1-cipher-type=aes-256-cbc
repo1-path=/var/lib/pgbackrest
repo1-retention-full=2
backup-user=postgres
[global:archive-push]
compress-level=3
#####################################################
[root(at)dbs ~]# pgbackrest version
pgBackRest 2.48
[root(at)dbs ~]#
#####################################################
*Postgres conf as follows... *
listen_addresses = '*'
port = 5444
unix_socket_directories = '/tmp'
archive_command = 'pgbackrest --stanza=demo archive-push %p'
archive_mode = on
log_filename = 'postgresql.log'
max_wal_senders = 3
wal_level = replica
#############################################
*ERROR Getting as follows .. What went wrong here ??*
[root(at)dbs ~]# sudo -u postgres pgbackrest --stanza=demo
--log-level-console=info stanza-create
2023-11-20 21:04:05.223 P00 INFO: stanza-create command begin 2.48:
--exec-id=29527-bf5e2f80 --log-level-console=info
--pg1-path=/app/edb/as10/data --pg1-port=5444 --pg1-socket-path=/tmp
--repo1-cipher-pass=<redacted> --repo1-cipher-type=aes-256-cbc
--repo1-path=/var/lib/pgbackrest --stanza=demo
WARN: unable to check pg1: [DbConnectError] unable to connect to
'dbname='postgres' port=5444 host='/tmp'': connection to server on socket
"/tmp/.s.PGSQL.5444" failed: fe_sendauth: no password supplied
ERROR: [056]: unable to find primary cluster - cannot proceed
HINT: are all available clusters in recovery?
2023-11-20 21:04:05.224 P00 INFO: stanza-create command end: aborted with
exception [056]
[root(at)dbs ~]#
It complains about the password. I followed the below tutorial link, but
no mention of password (Where to supply password, what parameter where ?)
setting here ==> https://pgbackrest.org/user-guide-rhel.html
Any hints welcome.. What am I missing here ??
Best,
Krishane
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios - cloud | 2023-11-20 10:46:34 | Re: pgBackRest on old installation |
Previous Message | Laurenz Albe | 2023-11-20 10:07:23 | Re: Prepared statements versus stored procedures |