Thank you. Its worked out well. But a basic doubt ? is storing the DB superuser password in .pgpass is advisable ? What other options do we have ? #su postgres bash-4.2$ cd
bash-4.2$ cat .pgpass *:*:*:postgres:your_password bash-4.2$ On Mon, Nov 20, 2023 at 4:16 PM Achilleas Mantzios - cloud < a.mantz...@cloud.gatewaynet.com> wrote: > > On 11/20/23 12:31, KK CHN wrote: > > 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@dbs ~]# pgbackrest version > pgBackRest 2.48 > [root@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@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@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 > > This is about the user connecting to the db, in general, pgbackrest has to > connect like any other app/user. So, change your .pgpass to contain smth > like the below on the top of the file : > > /tmp:5444:*:postgres:your_whatever_pgsql_password > > and retry > > > > Any hints welcome.. What am I missing here ?? > > Best, > Krishane > > > > > > > >
