pg_dump fails - Mailing list pgsql-general

From Lorenzo Thurman
Subject pg_dump fails
Date
Msg-id ff616a0d7fbcae0e69775d8652132a3e@thethurmans.com
Whole thread Raw
Responses Re: pg_dump fails
List pgsql-general
I'm running  postgresql 7.4.7 on x86 and have run into a problem trying
to export my database. When I use pg_dump --file=stats.out --format=t
printstats, (and I may have the syntax wrong), I get this error:
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 = 'printstats'

I tried googling for an answer, and found a couple of references to
this error, but nothing that could help me. Can anyone help me out
here?
Thanks


Tech/Library Combo Lab Manager
Northwestern University
Office Tech MG49
mailto:lthurman@northwestern.edu
voice: 847-467-6565
pager: 847-536-0094


pgsql-general by date:

Previous
From: "Relyea, Mike"
Date:
Subject: Re: Plpgsql function with unknown number of args
Next
From: Scott Marlowe
Date:
Subject: Re: increasingly slow insert/copy performance