From: | "Gerald D(dot) Anderson" <gander(at)vte(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Old problem needs solution |
Date: | 2005-06-01 15:51:32 |
Message-ID: | 429DD984.5030808@vte.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-06-01 15:52:19 | Re: Autonomous Transactions |
Previous Message | FC | 2005-06-01 15:49:25 | Re: SQL question. |