Privileges where not restored
От | Düster Horst |
---|---|
Тема | Privileges where not restored |
Дата | |
Msg-id | 5B025B1F39D6D4119F5700508BEEEC66F94CB7@srsofaioi4546.ktso.ch обсуждение исходный текст |
Ответы |
Re: Privileges where not restored
|
Список | pgsql-admin |
I want to migrate a DB from PG 7.4.6 to PG 8.0.0. Thus I dumped a PG 7.4.6 DB with the command pg_dump -Fc -h host -U user dbname > db.dmp (pg_dump Version (PostgreSQL) 8.0.0) after the dump I create a TOC list file with pg_restore -l db.dmp > db.lst (pg_restore Version (PostgreSQL) 8.0.0) This step is nessesary to reorder the DB objects for correct import. After reordering the DB objects I restore the DB with pg_restore -L db.lst -v db.dmp | psql -d db All DB objects where restored but not their user previleges. I did the above described steps successful with PG 7.4.6. The listfile created with PG 7.4.6 shows many records with the ACL keyword. These records are missing in the PG 8.0.0 created listfile. I would be grateful for any hint. With best regards Horst Düster --------------------------------- Dr. Horst Düster GIS-Koordinator /Amtschef Stv. Kanton Solothurn Amt für Geoinformation Abteilung SO!GIS Koordination Werkhofstr. 65 CH-4509 Solothurn Tel.: ++41 (0)32 627 25 32 Fax: ++41 (0)32 627 22 14 horst.duester@bd.so.ch www.sogis.so.ch
В списке pgsql-admin по дате отправления: