Re: pgBackRest on old installation

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(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

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
>
>
>
>
>
>
>