Skip site navigation (1) Skip section navigation (2)

Privileges where not restored

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: (view raw, whole thread or download thread mbox)
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)

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



pgsql-admin by date

Next:From: David.JacquesDate: 2005-01-19 17:38:11
Subject: Building a list of fields ?
Previous:From: jsuenDate: 2005-01-19 12:24:11
Subject: postmaster eating up memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group