Steve Wampler <swampler@xxxxxxxx> writes:
> In fact, now that I look more at the dump file, it's kinda interesting.
> Near the top are the lines:
> \connect "atst.logdb" atst
> SET client_encoding = 'SQL_ASCII';
> SET check_function_bodies = false;
> SET SESSION AUTHORIZATION 'sbw';
> ('sbw' is a superuser, 'atst' was not. The restore was run by
> [Linux] user 'sbw'.)
Yeah, this is a bug in pg_dump --- it's failing to consider that doing
the \connect that way might lose superuser privileges. More recent
versions of pg_dump avoid that problem, but as long as you're on 7.4
the best advice may be to not rely on the -C switch.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
