pgBackRest on old installation
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
Any hints welcome.. What am I missing here ??
Best,
Krishane
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/5mTkQEempvBxQk5UbxsrDzHbwrepo1-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
Show quoted text
Any hints welcome.. What am I missing here ??
Best,
Krishane
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:
Show quoted text
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.htmlThis 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
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$ cdbash-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.
Show quoted text
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/5mTkQEempvBxQk5UbxsrDzHbwrepo1-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.htmlThis 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
On 21/11/2023 11:59, Achilleas Mantzios - cloud wrote:
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 ?
The .pgpass file is stored in the user's home directory, and from memory
I think it won't get used at all if the permissions allow anyone other
than the user to read it, so it's safer than it sounds!
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie