X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 06BBD3A461B for ; Thu, 20 Jan 2005 04:07:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09090-08 for ; Thu, 20 Jan 2005 04:07:15 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 823803A461E for ; Thu, 20 Jan 2005 04:07:14 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id j0K478Qa005905 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Wed, 19 Jan 2005 21:07:10 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id j0K4784x097426; Wed, 19 Jan 2005 21:07:08 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id j0K477v8097425; Wed, 19 Jan 2005 21:07:07 -0700 (MST) (envelope-from mfuhr) Date: Wed, 19 Jan 2005 21:07:07 -0700 From: Michael Fuhr To: =?iso-8859-1?Q?D=FCster?= Horst Cc: "'pgsql-admin@postgresql.org'" Subject: Re: Privileges where not restored Message-ID: <20050120040707.GA97306@winnie.fuhr.org> References: <5B025B1F39D6D4119F5700508BEEEC66F94CB7@srsofaioi4546.ktso.ch> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <5B025B1F39D6D4119F5700508BEEEC66F94CB7@srsofaioi4546.ktso.ch> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/202 X-Sequence-Number: 16061 On Wed, Jan 19, 2005 at 05:33:37PM +0100, Düster Horst wrote: > 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. Are you sure reordering was necessary? Did you try to restore without reordering the objects? > After reordering the DB objects I restore the DB with > pg_restore -L db.lst -v db.dmp | psql -d db You could also specify the database as an option to pg_restore and skip piping the output into psql, unless perhaps you have a specific reason for using psql. > All DB objects where restored but not their user previleges. Hmmm...I see the same behavior. The following restores objects with their original permissions: pg_restore -d testdb db.dump The following restores objects without their permissions: pg_restore -l db.dump > db.list pg_restore -d testdb -L db.list db.dump > 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 see that as well; I'll mention it on pgsql-bugs. -- Michael Fuhr http://www.fuhr.org/~mfuhr/