Skip site navigation (1) Skip section navigation (2)

Re: copy a database

From: David Suela Fernández <dsuela(at)xsto(dot)info>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Christopher Browne <cbbrowne(at)acm(dot)org>,pgsql-general(at)postgresql(dot)org
Subject: Re: copy a database
Date: 2004-08-26 08:19:45
Message-ID: 1093508385.22524.7.camel@yen-lo-wang (view raw or flat)
Thread:
Lists: pgsql-general
El mié, 25-08-2004 a las 20:54, Tom Lane escribió:
> David Suela =?ISO-8859-1?Q?Fern=E1ndez?= <dsuela(at)xsto(dot)info> writes:
> > 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
> 
> Have you tried re-creating that view?
> 
> CREATE VIEW pg_catalog.pg_user AS 
>     SELECT 
>         usename, 
>         usesysid, 
>         usecreatedb, 
>         usesuper, 
>         usecatupd, 
>         '********'::text as passwd, 
>         valuntil, 
>         useconfig 
>     FROM pg_shadow;
> 
> 			regards, tom lane

It return:
ERROR:  permission denied to create "pg_catalog.pg_user"
DETAIL:  System catalog modifications are currently disallowed.

How can i change this permissions?

-- 
David Suela Fernández <dsuela(at)xsto(dot)info>
xsto.info <el acceso a la información>


In response to

Responses

pgsql-general by date

Next:From: gnariDate: 2004-08-26 08:27:59
Subject: Re: Possible to insert quoted null value into integer field?
Previous:From: Janning VygenDate: 2004-08-26 08:15:15
Subject: Re: Constraints to Guarantee unique across tables with foreign key?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group