Skip to content

pg_dump: [archiver (db)] query failed: ERROR: schema “sys” does not exist

As I could not find any information about this error when I faced it this is just a short hint: If you try to use pg_dump or pg_dumpall out of a PPAS installation to dump or dumpall a community version of PostgreSQL you probably get this:

pg_dump: [archiver (db)] query failed: ERROR: schema "sys" does not exist
pg_dump: [archiver (db)] query was: SET search_path = pg_catalog, sys, dbo

The solution is quite easy but you have to be aware of: The pg_dump and pg_dumpall utilities shipped with PPAS are not compatible with community PostgreSQL and therefore you’ll have to install the PostgreSQL community binaries and use the utilities from there to succeed (even if PPAS is installed in PostgreSQL mode).

Let’s work together

Ready to operate at
the next level?

Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.

Talk to an Expert
Open source Team

Open source Team

Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.View Author posts

721 posts since September 2011

Tags:

Leave a Comment

Your email address will not be published. Required fields are marked *