Re: Backup issue

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 <[email protected]> wrote:

> 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
> >
>