Dear Members,
I am trying to take backup of postgreSQL Community and restore to EDB Advanced Server.
Now I will get this error on EDB Advanced Server.
Please rectify the issue.
Regards,
Malli.
On Thu, Sep 5, 2019 at 5:10 PM Luca Ferrari <fluca1978@xxxxxxxxx> wrote:
On Thu, Sep 5, 2019 at 12:59 PM mallikarjun t <mallit333@xxxxxxxxx> 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>
