[postgis-users] postgis_restore.pl and user privileges

[Stefano Bonnin]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20040916/368792be/attachment.html>