[postgis-users] postgis_restore and user privileges

[Stefano Bonnin]

>A last tip: are you superuser when restoring ?

Yes, I am
----- Original Message ----- 
From: <strk at refractions.net>
To: <postgis-users at postgis.refractions.net>
Sent: Thursday, September 16, 2004 10:19 AM
Subject: Re: [postgis-users] postgis_restore and user privileges


> As you noted for pg_restore it seems that -x prevents
> that (ACL) in pg_dump too.
> You should ask on the pgsql-users mailing list.
> Also check -O  (prevent owner set) for both apps.
> A last tip: are you superuser when restoring ?
> 
> --strk;
> 
> On Thu, Sep 16, 2004 at 10:06:05AM +0200, Stefano Bonnin wrote:
> > I have a doubt:
> > 
> > is sure that "pg_dump -Fc" dumps the user privileges?
> > 
> > if I try 
> > 
> > ./pg_restore -l mydump.sql
> > 
> > I don't see anythink about privileges
> 
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>