problem with pg_restore and user privileges

From: "Stefano Bonnin" <stefano(dot)bonnin(at)comai(dot)to>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: problem with pg_restore and user privileges
Date: 2004-09-16 09:29:57
Message-ID: 013701c49bcf$bb39cf00$0501a8c0@comai04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I'm a Postgis user, and I have a problem restoring data from 7.4 to 8.0.0beta2.

I use the postgis_restore.pl script that comes with postgis distribution.

I do the following for the dump:
pg_dump -Fc mydb >mydb.sql

and the script does the following restore operations:
... some commands ...
open( PSQL, "| ./psql -a dbname") || die "Can't run psql\n";
... pg_restore -l mydb.sql >dump.list

... some commands ..

something like:

.. pg_restore -L dump.list mydb.sql

... some commands ..

It seems to work except for the user privileges. At the end, no user privileges are restored in the new database

My doubt is the following:
pg_restore -l mydb.sql >dump.list

dump the privileges information in the dump.list file or not?
some hints?
Thanks
Reds

Browse pgsql-general by date

  From Date Subject
Next Message Najib Abi Fadel 2004-09-16 09:36:42 Re: pg_dump in cycle
Previous Message Ilia Chipitsine 2004-09-16 09:01:23 Re: pg_dump in cycle