Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I am new to PostgreSQL and I am trying to backup a database with the pg_dump utility.
I am using this command:
/opt/PostgresPlus/9.4AS/bin/pg_dump -U (username) -f /opt/PostgresPlus/9.4AS//pgbackup/db_name.sql dbname -p 5432
and I am encountering this error:
pg_dump: [archiver (db)] query failed: ERROR: unrecognized configuration parameter "qreplace_function"
Can anyone please help me understand what I am doing wrong?
You have not used PostgreSQL. You are using PostgresPlus created by EnterpriseDB.
The parameter qreplace_funtion is mentioned in EnterpriseDB's document (page 21). I guess this is a typical privilege problem.
OR, if you use PostgreSQL but run PostgrePlus's pg_dump, try original PostgreSQL's pg_dump.
