Hi Adrian,
I did in pgbackrest installation below commands in prod server.
yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm
yum install pgbackrest
and prod server backup working fine .
prod and dev file system mount points is different naming conversation.
so we have taken the restore directly using to prod .
dev:
========
postgres@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:/home/postgres
==> df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/sysvg-root.vol 20G 11G 8.9G 54% /
devtmpfs 63G 0 63G 0% /dev
tmpfs 63G 20K 63G 1% /dev/shm
tmpfs 63G 154M 63G 1% /run
tmpfs 63G 0 63G 0% /sys/fs/cgroup
/dev/mapper/datavg-db.vol 6.0T 4.7T 1.3T 79% /Postgres
/dev/mapper/sysvg-tmp.vol 2.0G 95M 1.9G 5% /tmp
/dev/sda1 973M 220M 753M 23% /boot
/dev/mapper/sysvg-home.vol 2.0G 594M 1.4G 31% /home
//sydwinappt001/A4_Import/ 1000G 395G 606G 40% /mnt/sydwinappt001_A4_Import
ausydisi01.enterprisenet.org:/ifs/auwatch/prd/auwatch/Adex/DataDump/A4 4.8T 3.8T 965G 81% /mnt/I_DataDump
tmpfs 13G 0 13G 0% /run/user/26
tmpfs 13G 0 13G 0% /run/user/0
tmpfs 13G 0 13G 0% /run/user/290789
prod:
=======
postgres@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:/home/postgres
==> df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/rhel-root.vol 20G 9.6G 9.5G 51% /
devtmpfs 32G 0 32G 0% /dev
tmpfs 32G 20K 32G 1% /dev/shm
tmpfs 32G 850M 31G 3% /run
tmpfs 32G 0 32G 0% /sys/fs/cgroup
/dev/sda1 973M 187M 786M 20% /boot
/dev/mapper/rhel-tmp.vol 3.9G 34M 3.8G 1% /tmp
/dev/mapper/rhel-home.vol 3.9G 115M 3.7G 3% /home
/dev/mapper/rhel-optapp.vol 8.0G 537M 7.5G 7% /opt/app
/dev/mapper/datavg-postgres.vol 5.0T 1.9T 3.2T 38% /Postgres
//sydwinappt001/A4_Import/ 1000G 395G 606G 40% /mnt/sydwinappt001_A4_Import
ausydisi01.enterprisenet.org:/ifs/auwatch/prd/auwatch/Adex/DataDump/A4 4.8T 3.8T 965G 81% /mnt/I_DataDump
ausydisi01.enterprisenet.org:/ifs/PostgresBackup 3.0T 723G 2.3T 24% /pgBACKUP
tmpfs 6.3G 0 6.3G 0% /run/user/26
tmpfs 6.3G 0 6.3G 0% /run/user/0
tmpfs 6.3G 0 6.3G 0% /run/user/290789
postgres@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:/home/postgres
dev pgbackrest.conf file:
===================
==> cat /etc/pgbackrest.conf
#[global]
#repo1-path=/Postgres/pgBACKUP/A4_sydcosausd001
#retention-diff=4
#retention-full=4
#retention-archive=2
#start-fast=y
#process-max=4
#archive-async=y
#[global:archive-push]
#process-max=4
#[A4_sydcosausd001]
#db-path=/Postgres/pgDATA/data
[global]
repo1-host=sydcosafpp001.enterprisenet.org
repo1-host-user=postgres
repo1-host-config=/etc/pgbackrest.conf
repo1-path=/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001
[A4_sydcosafpp001]
pg1-path=/Postgres/prakash_pgbackrest
postgres@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:/home/postgres
restore command - pgbackrest --stanza=A4_sydcosafpp001 --log-level-console=info --db-path=/Postgres/prakash_pgbackrest --delta --process-max=2 --db-include=A4_Copy restore --repo1-path=/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001
On Mon, May 13, 2019 at 7:26 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 5/13/19 2:20 AM, Prakash Ramakrishnan wrote:
> Hi Adrian,
>
> Yes am using edb standard edition and installed pgbackrest in prod and dev.
To be clear your have on the prod server:
1) Postgres installed via EDB installer.
2) You have pgBackRest.
3) You can take a backup using pgBackRest from the Postgres server.
If that is the case how did you install pgBackRest on the prod server?
In other words what is different between the prod and dev setups of
Postgres and pgBackRest?
>
> nothing different am trying to restore the backup prod to dev cluster .
>
> * Can't load '/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so' for module
> DBD::Pg: libpq.so.5: cannot open shared object file: No such file or
> directory at /usr/lib64/perl5/DynaLoader.pm line 190.*
> at /loader/0x1ec1528/pgBackRest/Db.pm line 10.
> at /loader/0x1ec1528/pgBackRest/Main.pm line 12.
> pgBackRest::Main::__ANON__('Can\'t load
> \'/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so\...') called at
> /usr/share/perl5/vendor_perl/Carp.pm line 100
>
> May be above path is corrupt or something issue not able to load the path.
>
> Regards,
> Prakash.R
>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
