Search Postgresql Archives

pg_dump'ed file contains "DROP DATABASE"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



[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 





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux