[postgis-users] postgis_restore and user privileges

strk at refractions.net strk at refractions.net
Thu Sep 16 01:19:53 PDT 2004


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




More information about the postgis-users mailing list