Re: Rights in 7.4 - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Rights in 7.4
Date
Msg-id 20040114143350.K11120@zoraida.natserv.net
Whole thread Raw
In response to Re: Rights in 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Rights in 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, 14 Jan 2004, Tom Lane wrote:

> > The line from the sql file that is failing, a dump, is
> > SELECT pg_catalog.setval('invoicesdetails_invoicesdetailsid_seq', 18,
> > true);
>
> You have not given us any context to interpret this report in, but
> I do not think it has anything to do with the ownership of the public
> schema.


I need to dump/restore frequently from one database/machine to other
database/machines.

I did the dump as a regular user and was trying to do the restore as the
same user, but to another DB. Both DBs are owned by the user I did the
dump with.

Should restores be always done by the super user?

pgsql-general by date:

Previous
From: Matt Davies
Date:
Subject: Re: Postgress and MYSQL
Next
From: "Chris Ochs"
Date:
Subject: Re: Postgress and MYSQL