Re: copy a database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dsuela(at)xsto(dot)info
Cc: Christopher Browne <cbbrowne(at)acm(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: copy a database
Date: 2004-08-26 14:28:07
Message-ID: 17380.1093530487@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Suela =?ISO-8859-1?Q?Fern=E1ndez?= <dsuela(at)xsto(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-26 14:42:23 Re: stone-age maintenance procedures ;-)
Previous Message Leonardo Francalanci 2004-08-26 13:51:04 space taken by a row & compressed data