pg_restore to new database wants to wipe out the old database?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_restore to new database wants to wipe out the old database?
Date: 2018-10-30 22:08:35
Message-ID: 4a6e3243-7fcd-e7b3-4279-ce57bc5cf5ac@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-10-30 22:16:13 Re: pg_restore to new database wants to wipe out the old database?
Previous Message Adrian Klaver 2018-10-30 21:11:45 Re: Question about servicescript for stopping and starting postgresql instance