From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_restore to new database wants to wipe out the old database? |
Date: | 2018-10-30 22:25:57 |
Message-ID: | 8271fb47-8f04-a02b-2927-e475659274dd@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/30/2018 05:16 PM, David G. Johnston wrote:
> On Tue, Oct 30, 2018 at 3:09 PM Ron <ronljohnsonjr(at)gmail(dot)com
> <mailto:ronljohnsonjr(at)gmail(dot)com>> wrote:
>
> Hi,
>
> v9.6.9
>
> Why is pg_restore trying to drop my production database, when I (think
> I) am telling it to create the new database "Molson"?
>
> Straight from the pg_restore documentation:
> -C
>
> "When this option is used, the database named with |-d| is used only to
> issue the initial |DROP DATABASE| and |CREATE DATABASE| commands. All data
> is restored into the database name that appears in the archive."
So I've got to explicitly CREATE DATABASE "Molson" and then
pg_restore -d Molson Molson
>
> Also
> " pg_restore -vcC --if-exists --jobs=8 -d postgres Molson "
>
> pg_restore [connection-option...] [option...] [filename]
>
> "Molson" is a file name; pg_restore doesn't use the file name aside from
> finding where the data you want to restore is located.
>
> David J.
>
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolas Paris | 2018-10-30 23:08:00 | Full-text Search - Thesaurus relationships |
Previous Message | David G. Johnston | 2018-10-30 22:16:13 | Re: pg_restore to new database wants to wipe out the old database? |