Displaying 2 results from an estimated 2 matches for "datpath".
Did you mean:
datapath
2005 Apr 28
1
relation "pg_user" does not exist error when running pg_dump
...g_dump -U postgres database > database.out
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: relation "pg_user" does not exist
pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE
usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding,
datpath FROM pg_database WHERE datname = 'database'
Thank you for your help!
Andy
2005 Apr 28
0
relation "pg_user" does not exist error when runningpg_dump
...t; database.out
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: relation "pg_user" does
not
> exist
> pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE
> usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding,
> datpath FROM pg_database WHERE datname = 'database'
Googling for the error message (*hint hint*) indicates this is most
often caused by a version mismatch between your pg_dump, psql, etc, and
the actual postgres database you are connecting to. Is that the case?
--
Marc