From: | Düster Horst <Horst(dot)Duester(at)bd(dot)so(dot)ch> |
---|---|
To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Privileges where not restored |
Date: | 2005-01-19 16:33:37 |
Message-ID: | 5B025B1F39D6D4119F5700508BEEEC66F94CB7@srsofaioi4546.ktso.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)duester(at)bd(dot)so(dot)ch
www.sogis.so.ch
From | Date | Subject | |
---|---|---|---|
Next Message | David.Jacques | 2005-01-19 17:38:11 | Building a list of fields ? |
Previous Message | jsuen | 2005-01-19 12:24:11 | postmaster eating up memory |