Re: Old problem needs solution

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)
>