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