data # pg_dump -Fc -f blah.txt -tforums_auth forums22 -u
User name: postgres
Password:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: did not find '}' at end of
input node
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 = 'forums22'
That help? As far as when, pretty much anytime I do anything. My guess
is messed up metadata.
G
Richard Huxton wrote:
Gerald D. Anderson wrote:
Greetings!
At some point, I'm not even sure when, I apparently had a bad upgrade
on one of my production databases. I'm in a situation now where I've
got my back up against a wall and not sure what to do. The problem
is, I'm receiving this message frequently:
did not find '}' at end of input node
When?
I am currently running version 7.4.7 and am trying to migrate on up
to 8. The data is completely available to the application (large
forums database is primary concern), but I can't back it up or do
anything with it aside from let it dig itself deeper.
Can you pg_dump individual tables (with -t my_table_name)
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
