Error using pg_dump
I was able to use pg_dump just last week to dump my database. Today when I tried, I get this error:
pg_dump: error: query failed: couldn't get first string argument
pg_dump: detail: Query was: SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind'
3 Replies
If I run that exact SELECT query, I get back:
invalid SQL: unsupported statement, available: [SELECT, INSERT, DELETE, UPDATE, ALTER TABLE, CREATE TABLE, CREATE TABLE, DROP TABLE, TRUNCATE, REFRESH MATERIALIZED VIEW, DROP MATERIALIZED VIEW, ALTER INDEX, CREATE INDEX, DROP INDEX, ALTER TYPE, CREATE TYPE, DROP TYPE, ALTER SEQUENCE, CREATE SEQUENCE, DROP SEQUENCE, ALTER VIEW, CREATE VIEW, DROP VIEW, CREATE SCHEMA, DROP SCHEMA, ALTER SCHEMA, BEGIN, COMMIT, ROLLBACK, COMPOSITE TYPE, SHOW]
hi, when I run it, I get the same error as from pg_dump:
but I wonder what is
name there, normally it should be the name of a setting, as quoted string. How did you create the pg_dump exactly?
we figured it out and it's an issue on our side which we're in the process of fixing. I'll let you know when it's done
the fix should be in prod, could you try the pg_dump again?Confirmed fixed for me. Thank you!