[postgis-users] postgis_restore.pl and user privileges

[strk at refractions.net]

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