Re: pgBackRest on old installation - Mailing list pgsql-general

From KK CHN
Subject Re: pgBackRest on old installation
Date
Msg-id CAKgGyB9z_yDWnXG7Hc8wyicLOTnAGe=tyKCX7KcbhQBh4eS-eQ@mail.gmail.com
Whole thread Raw
In response to Re: pgBackRest on old installation  (Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>)
Responses Re: pgBackRest on old installation
List pgsql-general
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@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







pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Can user specification of a column value be required when querying a view ?
Next
From: Dick Visser
Date:
Subject: client/server versions