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: 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

Responses

Browse pgsql-admin by date

  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