On 2/20/23 11:36, pf@pfortin.com wrote:
> On Mon, 20 Feb 2023 11:06:34 -0800 Adrian Klaver wrote:
>
>> On 2/20/23 10:27, pf@pfortin.com wrote:
>>> [Still a newbie; but learning fast...]
>>>
>>> Hi,
>
> Notwithstanding the man page, my take is that the DROP DATABASE statement
> needs to be eliminated at pg_dump creation by pgAdmin4. Taking this to
> that mailing list.
It just dawned on me you might be doing all of this through the
pgAdmin4 GUI.
In which case from most recent documentation:
https://www.pgadmin.org/docs/pgadmin4/6.20/index.html
Backup Dialog:
https://www.pgadmin.org/docs/pgadmin4/6.20/backup_dialog.html
Options tab:
"
Move the switch next to Include CREATE DATABASE statement towards right
position to include a command in the backup that creates a new database
when restoring the backup.
Move the switch next to Include DROP DATABASE statement towards right
position to include a command in the backup that will drop any existing
database object with the same name before recreating the object during a
backup.
"
So the default is not to include those options.
For Restore dialog:
https://www.pgadmin.org/docs/pgadmin4/6.20/restore_dialog.html
Options tab(for custom format):
"
Move the switch next to Include CREATE DATABASE statement towards right
position to include a command that creates a new database before
performing the restore.
Move the switch next to Clean before restore towards right position to
drop each existing database object (and data) before restoring.
"
Again the default is to not include those options.
>
> Thanks Tom & Adrian!
>
>>> Was my 134 table[1] myname DB saved because it was open?
>
> Tom: Yup.
>
>>> If the dump file
>>> contains the above statements, how can I be absolutely certain I won't
>>> lose the DB?
>
> Tom:
> Reading the manual is advisable. --create --clean specifies exactly
> that the target database is to be dropped and recreated.
>
> regards, tom lane
>
>>> I'm obviously quite paranoid now...
>>
>> You will lose the database if you do as the docs specify for -C:
>>
>> "
>> -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.
>> "
>>
>>
>> It will then be recreated with whatever information is in "dumpfile". If
>> that is the same data or new data you want then you are fine. Otherwise
>> you will need to be more specific about what you are trying to achieve.
>>
>>
>>>
>>> [1] 3 types of tables: ~40%=8.5M rows; ~40%=33M rows; ~20%=varying sizes
>>>
>>> Thanks,
>>> Pierre
>>>
>>>
>>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
