Re: Backup issue
Luca Ferrari <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <CAKoxK+6EZHk9d=mKrvd1hdEgMc0Awd52ELuuWfZ7LmASF4Y0FQ@mail.gmail.com> |
On Thu, Sep 5, 2019 at 12:59 PM mallikarjun t <[email protected]> wrote: > > Dear All, > > I try to take remote backup and restore to local EDB Advanced Server this error is coming, If any one knows this issue please clarify me? > > Please look into the error message: > > [postgres@localhost bin]$ pg_dump -h 192.168.211.148 -p 5432 -Fc -n myschema -f /tmp/schema_my.custom > Password: > pg_dump: [archiver (db)] query failed: ERROR: unrecognized configuration parameter "qreplace_function" > pg_dump: [archiver (db)] query was: SHOW qreplace_function That's an EDB internal configuration parameter, could it be you don't have permissions or you are using community-edition pg_dump against EDB? <https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/user-guide/11/EDB_Postgres_Advanced_Server_Guide.1.022.html>