pg_dump fails

From: Lorenzo Thurman <lorenzo(at)thethurmans(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump fails
Date: 2005-04-18 21:09:22
Message-ID: ff616a0d7fbcae0e69775d8652132a3e@thethurmans.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)northwestern(dot)edu
voice: 847-467-6565
pager: 847-536-0094

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-04-18 21:11:37 Re: increasingly slow insert/copy performance
Previous Message Relyea, Mike 2005-04-18 21:02:31 Re: Plpgsql function with unknown number of args