Обсуждение: Backup issue

Поиск
Список
Период
Сортировка

Backup issue

От
mallikarjun t
Дата:
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


Regards,
Malli.

Re: Backup issue

От
Luca Ferrari
Дата:
On Thu, Sep 5, 2019 at 12:59 PM mallikarjun t <mallit333@gmail.com> 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
issueplease 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>

Re: Backup issue

От
mallikarjun t
Дата:
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@gmail.com> wrote:
On Thu, Sep 5, 2019 at 12:59 PM mallikarjun t <mallit333@gmail.com> 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>