pg_dump'ed file contains "DROP DATABASE"

From: pf(at)pfortin(dot)com
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pg_dump'ed file contains "DROP DATABASE"
Date: 2023-02-20 18:27:05
Message-ID: 20230220132705.3a81a48f.pfortin@pfortin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[Still a newbie; but learning fast...]

Hi,

A remote team member is helping out by dumping some of his tables via
pgAdmin4 on Windows. My DB is on Linux.

The other day, I restored his first file with:
pg_restore --host "localhost" --port "5432" --username "postgres"
--no-password --dbname "myname" --create --clean --verbose "dumpfile"

when I saw this:

pg_restore: dropping DATABASE myname
Command was: DROP DATABASE myname;

pg_restore: error: could not execute query:
ERROR: cannot drop the currently open database

Digging into the pg_dump'ed files, I see:

CREATE DATABASE myname WITH TEMPLATE = template0 ENCODING = 'UTF8'
LOCALE_PROVIDER = libc LOCALE = 'English_United States.1252';
DROP DATABASE myname;
^^^^^^^^^^^^^^^^^^^^^

Was my 134 table[1] myname DB saved because it was open? If the dump file
contains the above statements, how can I be absolutely certain I won't
lose the DB? I'm obviously quite paranoid now...

[1] 3 types of tables: ~40%=8.5M rows; ~40%=33M rows; ~20%=varying sizes

Thanks,
Pierre

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-02-20 18:35:57 Re: pg_dump'ed file contains "DROP DATABASE"
Previous Message David G. Johnston 2023-02-20 17:21:00 Re: pg_reload_conf()