refreshing a database with pg_dump and psql

From: "Rossi, Maria" <maria(dot)rossi(at)us(dot)pgds(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: refreshing a database with pg_dump and psql
Date: 2015-05-26 21:09:57
Message-ID: f39c1b101fe5410a93f57d2f5a0edefe@DC01PXMBP003.jacksonnational.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 load it. But got a bunch of 'object already exist'.
Can't I refresh an existing database from a plain pg_dump? Is there an option that I have to use?
Thanks.

Maria A Rossi
Database Administration
PGDS (US)
email: maria(dot)rossi(at)us(dot)pgds(dot)com<mailto:maria(dot)rossi(at)us(dot)pgds(dot)com>
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2015-05-26 21:25:49 Re: refreshing a database with pg_dump and psql
Previous Message Scott Ribe 2015-05-26 20:53:58 Re: How to expand existing table-space