PostgreSQL 8.0.0 Running "pg_restore -l" to create a list file and then restoring using "pg_restore -L" fails to restore ACLs. See the "Privileges where [sic] not restored" thread in pgsql-admin:
http://archives.postgresql.org/pgsql-admin/2005-01/msg00197.php As I mention in a followup in that thread, the following restores objects with their ACLs: pg_restore -d testdb db.dump The following doesn't restore ACLs: pg_restore -l db.dump > db.list pg_restore -d testdb -L db.list db.dump -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
