Re: pgBackRest on old installation

On 11/21/23 08:36, KK CHN wrote:

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

root has access to any file, but if you give password on the command
line or env variable then you give this info to all users in the system.

>
>
> On Mon, Nov 20, 2023 at 4:16 PM Achilleas Mantzios - cloud
> <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)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(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
>>
>>
>>
>>
>>
>>
>>