[postgis-users] postgis_restore.pl and user privileges

[Stefano Bonnin]

... but the only parameter of pg_restore that can act on the privileges
restoring operation is

****
            -x, --no-privileges     skip restoration of access privileges
(grant/revoke)
****

so, I think, the privilege are restored by default....

... or not?

Thanks

----- Original Message ----- 
From: <strk at refractions.net>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Thursday, September 16, 2004 9:04 AM
Subject: Re: [postgis-users] postgis_restore.pl and user privileges


> On Thu, Sep 16, 2004 at 08:34:03AM +0200, Stefano Bonnin wrote:
> > Hi,
> >
> > I'm migrating my databases from pg7.4 to pg8.0.0beta2 and I'm using
postgis_restore.pl script.
> >
> > All it seems work *but* the script doesn't restore the database users
and privileges.
> >
> > I did the following operations:
> >
> > pg_dump -Fc mydatabase >mydatabase.sql
> >
> > postgis_restore.pl postgis.sql new_db_name mydatabase.sql
> >
> > The db is now completely restored but only with the postgres user
> >
> > Thanks in advance.
> > RedS
>
> Stefano, the postgis_restore.pl currently calls 'pg_restore' with
> no additional arguments. Edit the perl script and try adding the
> required arg. Eventually arguments-passing will be possible through
> postgis_restore.pl directly.
>
> --strk;
>
> > _______________________________________________
> > 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
>