Postgres Pro
Downloads
Home   >   mailing lists

pg_restore to new database wants to wipe out the old database? - Mailing list pgsql-general

From Ron
Subject pg_restore to new database wants to wipe out the old database?
Date
Msg-id 4a6e3243-7fcd-e7b3-4279-ce57bc5cf5ac@gmail.com
Whole thread Raw
Responses Re: pg_restore to new database wants to wipe out the old database?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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"?

$ cd /backup
$ pg_dump -d proddb -j 8 -Fd --no-synchronized-snapshots -Z0 -v -f proddb 2> proddb_pgdump.log

$ mv proddb Molson
$ pg_restore -vcC --if-exists --jobs=8 -d postgres Molson
pg_restore: connecting to database for restore
pg_restore: dropping DATABASE proddb
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 145485; 1262 16385 DATABASE proddb TAP
pg_restore: [archiver (db)] could not execute query: ERROR:  database "proddb" is being accessed by other users
DETAIL:  There are 3 other sessions using the database.
    Command was: DROP DATABASE IF EXISTS "proddb";
 
pg_restore: processing item 145482 ENCODING ENCODING
pg_restore: processing item 145483 STDSTRINGS STDSTRINGS
pg_restore: processing item 145484 SEARCHPATH SEARCHPATH
pg_restore: processing item 145485 DATABASE proddb
pg_restore: creating DATABASE "proddb"
pg_restore: [archiver (db)] could not execute query: ERROR:  database "proddb" already exists
    Command was: CREATE DATABASE "proddb" WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
 
Thanks


--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Question about servicescript for stopping and starting postgresqlinstance
Next
From: "David G. Johnston"
Date:
Subject: Re: pg_restore to new database wants to wipe out the old database?