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/