Re: copy a database

On Wed, Aug 25, 2004 at 04:25:02PM +0100, Oliver Elphick wrote:
> On Wed, 2004-08-25 at 15:08, David Suela Fernández wrote:
>
> > The problem is that pg_dump always give me the next error:
> >
> > pg_dump: SQL command failed
> > pg_dump: Error message from server: ERROR:  relation "pg_user" does not exist
> > 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 = 'ez3'
>
> Maybe recreating pg_user in the database will help.  It is a global
> table, so if you have other databases where pg_user exists, copy the row
> from pg_class in that database to pg_class in the corrupted database.

No, pg_user is a view on pg_shadow ...

SELECT pg_shadow.usename, pg_shadow.usesysid, pg_shadow.usecreatedb,
pg_shadow.usesuper, pg_shadow.usecatupd, '********'::text AS passwd,
pg_shadow.valuntil, pg_shadow.useconfig FROM pg_shadow;

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Y una voz del caos me habló y me dijo
"Sonríe y sé feliz, podría ser peor".
Y sonreí. Y fui feliz.
Y fue peor.