Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 517B09FB4F6 for ; Mon, 23 Apr 2007 11:49:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 57094-02 for ; Mon, 23 Apr 2007 11:49:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id A8B049FB2FB for ; Mon, 23 Apr 2007 11:49:13 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l3NEn9wn002040; Mon, 23 Apr 2007 10:49:09 -0400 (EDT) To: Jaume Sabater cc: pgsql-admin@postgresql.org Subject: Re: pg_dump and pg_restore with different owners In-reply-to: <462C9BD3.6090405@linuxsilo.net> References: <46273CDE.50401@linuxsilo.net> <462C9BD3.6090405@linuxsilo.net> Comments: In-reply-to Jaume Sabater message dated "Mon, 23 Apr 2007 13:43:15 +0200" Date: Mon, 23 Apr 2007 10:49:09 -0400 Message-ID: <2039.1177339749@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/208 X-Sequence-Number: 25272 Jaume Sabater writes: >> But I got these errors: >> >> pg_restore: [archiver (db)] Error while PROCESSING TOC: >> pg_restore: [archiver (db)] Error from TOC entry 3751; 0 0 COMMENT >> SCHEMA public postgres >> pg_restore: [archiver (db)] could not execute query: ERROR: must be >> owner of schema public >> Command was: >> COMMENT ON SCHEMA public IS 'Standard public schema'; >> pg_restore: WARNING: no privileges could be revoked >> pg_restore: WARNING: no privileges could be revoked >> pg_restore: WARNING: no privileges were granted >> pg_restore: WARNING: no privileges were granted >> WARNING: errors ignored on restore: 1 You can ignore these. --no-owner plus do the restore as the new owner is the correct procedure. regards, tom lane