Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YxM71-0001o7-BM for pgsql-admin@arkaria.postgresql.org; Tue, 26 May 2015 21:10:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YxM70-0002tb-DQ for pgsql-admin@arkaria.postgresql.org; Tue, 26 May 2015 21:10:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YxM6z-0002sH-Fp for pgsql-admin@postgresql.org; Tue, 26 May 2015 21:10:09 +0000 Received: from mgap1c-mgmt.jacksonnational.com ([12.148.227.38]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1YxM6s-0006mo-SW for pgsql-admin@postgresql.org; Tue, 26 May 2015 21:10:07 +0000 X-IronPort-AV: E=Sophos;i="5.13,501,1427774400"; d="scan'208,217";a="217749910" Received: from vtunpep1c.jacksonnational.com (HELO DC01PXMBP003.jacksonnational.com) ([10.12.111.24]) by mgap1c-mgmt.jacksonnational.com with ESMTP; 26 May 2015 17:10:00 -0400 Received: from DC01PXMBP003.jacksonnational.com (10.8.105.32) by DC01PXMBP003.jacksonnational.com (10.8.105.32) with Microsoft SMTP Server (TLS) id 15.0.1044.25; Tue, 26 May 2015 17:09:57 -0400 Received: from DC01PXMBP003.jacksonnational.com ([10.8.105.32]) by DC01PXMBP003.jacksonnational.com ([10.8.105.32]) with mapi id 15.00.1044.021; Tue, 26 May 2015 17:09:57 -0400 From: "Rossi, Maria" To: "'pgsql-admin@postgresql.org'" Subject: refreshing a database with pg_dump and psql Thread-Topic: refreshing a database with pg_dump and psql Thread-Index: AdCX92LhAM50QmmKRLavNnnviY7mMQ== Date: Tue, 26 May 2015 21:09:57 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.8.96.1] x-tm-as-product-ver: SMEX-11.0.0.1251-8.000.1202-21572.003 x-tm-as-result: No--46.113100-0.000000-31 x-tm-as-user-approved-sender: Yes x-tm-as-user-blocked-sender: No Content-Type: multipart/alternative; boundary="_000_f39c1b101fe5410a93f57d2f5a0edefeDC01PXMBP003jacksonnati_" MIME-Version: 1.0 X-DLP-JNL: Passed X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_f39c1b101fe5410a93f57d2f5a0edefeDC01PXMBP003jacksonnati_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I have a database that was created from a 'pg_dump -C'. No problems there.= Then I ran the pg_dump again, this time without the -C. and tried to lo= ad it. But got a bunch of 'object already exist'. Can't I refresh an existing database from a plain pg_dump? Is there an op= tion that I have to use? Thanks. Maria A Rossi Database Administration PGDS (US) email: maria.rossi@us.pgds.com cell phone: 517.256.4392 work phone: 517.367.3099 work phone extension: 23099 --_000_f39c1b101fe5410a93f57d2f5a0edefeDC01PXMBP003jacksonnati_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I have a database that was created from a ‘pg_= dump –C’.  No problems there.  Then  I ran the p= g_dump  again, this time without the –C. and tried to load it.&n= bsp;  But   got a bunch of ‘object already exist’= ;.   

Can’t I refresh an existing database from a pl= ain pg_dump?  Is  there an option that I have to use?<= /p>

Thanks.

 

 

Maria A Rossi

Database Administration

PGDS (US)=

email: maria.rossi@us.pgds.com
cell phone: 517.256.4392

work phone: 517.367.3099
work phone extension: 23099
=

 

--_000_f39c1b101fe5410a93f57d2f5a0edefeDC01PXMBP003jacksonnati_--