Postgres Pro
Downloads
Home   >   mailing lists

Re: copy a database - Mailing list pgsql-general

From Tom Lane
Subject Re: copy a database
Date
Msg-id 17380.1093530487@sss.pgh.pa.us
Whole thread Raw
In response to Re: copy a database  (David Suela Fernández <dsuela@xsto.info>)
List pgsql-general
Tree view 
David Suela =?ISO-8859-1?Q?Fern=E1ndez?= <dsuela@xsto.info> writes:
> It return:
> ERROR:  permission denied to create "pg_catalog.pg_user"
> DETAIL:  System catalog modifications are currently disallowed.
> How can i change this permissions?

IIRC, you need to run a standalone backend, with either the -O or -P
switch (I forget which).  The REINDEX man page has some tips about this.

            regards, tom lane

pgsql-general by date:

Previous
From: "Anony Mous"
Date:
Subject: Re: Problem to connect to the Windows Port
Next
From: Tom Lane
Date:
Subject: Re: stone-age maintenance procedures ;-)