471,056 Members | 1,598 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,056 software developers and data experts.

problem with pg_restore and user privileges

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?
Nov 23 '05 #1
0 1102

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Ron Johnson | last post: by
4 posts views Thread by Ben Dewey | last post: by
1 post views Thread by Plant Thomas | last post: by
7 posts views Thread by Tim Penhey | last post: by
1 post views Thread by Alexander Cohen | last post: by
1 post views Thread by ruben | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.