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.rp <https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm> m 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: ======== postg...@sydcosausd001.enterprisenet.org:/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: ======= postg...@sydcosafpp001.enterprisenet.org:/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 postg...@sydcosafpp001.enterprisenet.org:/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 postg...@sydcosausd001.enterprisenet.org:/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.kla...@aklaver.com> 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.kla...@aklaver.com > -- Thanks, Prakash.R PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
