Re: perl path issue

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:
========
postgres(at)sydcosausd001(dot)enterprisenet(dot)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:
=======
postgres(at)sydcosafpp001(dot)enterprisenet(dot)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
postgres(at)sydcosafpp001(dot)enterprisenet(dot)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
postgres(at)sydcosausd001(dot)enterprisenet(dot)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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>

--

Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426