perfSONAR User Q&A and Other Discussion

["Pennington, Mike" <>]

Now it’s complaining about pg_dump:

 

/usr/lib/perfsonar/scripts/ps-migrate-backup.sh ~/ps-backup.tgz

Backing-up users...[SUCCESS]

Backing-up groups...[SUCCESS]

Backing-up passwords...[SUCCESS]

Backing-up perfsonar configuration...[SUCCESS]

Backing-up bwctl-server configuration...[SUCCESS]

Backing-up owamp-server configuration...[SUCCESS]

Backing-up NTP configuration...[SUCCESS]

Creating pScheduler backup:

    Version Information... Done.

    System Configuration... Done.

    Database.../usr/libexec/pscheduler/commands/backup: line 72: pg_dump: command not found

Unable to create pScheduler backup

 

Should I do a yum install of pg_dump?  I verified that postgresql is gone and postgresql95 is still installed.

 

Thanks

 

Mike Pennington CEN | Network Engineer Hartford CT | 06105-3702 p 860 622 4566 Member Conference - May 10th 2019 – Save The Date!

 

 

From: Mark Feit [mailto:]
Sent: Wednesday, August 15, 2018 11:41 AM
To: Pennington, Mike <>;
Subject: Re: [perfsonar-user] perfSONAR 4.1 will be available August 15th

 

Pennington, Mike writes:

 

But when I try to run the backup script, the file is not created and I get the following:

 

/usr/lib/perfsonar/scripts/ps-migrate-backup.sh ~/ps-backup.tgz

…

Creating pScheduler backup:

    Version Information... Done.

    System Configuration... Done.

   Database...pg_dump: unrecognized option '--serializable-deferrable'

Try "pg_dump --help" for more information.

Unable to create pScheduler backup

 

Some CentOS 6 systems, depending on when they were first installed, ended up with two versions of the PostgreSQL command-line utilities installed, 8.4 and 9.5.  This had to do with a difference is source and naming between what was shipped with CentOS and what we get from PGDG, which is later than CentOS could provide.  We depend on a feature in 9.5’s pg_dump, but 8.4’s ends up earlier in the path and gets run instead.

 

You should be able to remove the “postgresql” package safely without breaking any other dependencies, and you’ll still have the postgresql95 version.  That will get the backup process working.

 

--Mark