Re: pgBackRest on old installation

KK CHN <kkchn.in@xxxxxxxxx> · Tue, 21 Nov 2023 12:06:55 +0530

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.mantzios@xxxxxxxxxxxxxxxxxxxx> 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