Re: pg_dump'ed file contains "DROP DATABASE"

2023-02-20 Thread Adrian Klaver
On 2/20/23 19:22, p...@pfortin.com wrote: On Mon, 20 Feb 2023 15:24:23 -0800 Adrian Klaver wrote: It just dawned on me you might be doing all of this through the pgAdmin4 GUI. Sorry for any confusion... I get it now... A team member uses pgAdmin4 to load separate table(s) into his DB; th

Re: pg_dump'ed file contains "DROP DATABASE"

2023-02-20 Thread pf
On Mon, 20 Feb 2023 15:24:23 -0800 Adrian Klaver wrote: >On 2/20/23 11:36, p...@pfortin.com wrote: >> On Mon, 20 Feb 2023 11:06:34 -0800 Adrian Klaver wrote: >> >>> On 2/20/23 10:27, p...@pfortin.com wrote: [Still a newbie; but learning fast...] Hi, > >> >> Notwithstanding t

Re: pg_dump'ed file contains "DROP DATABASE"

2023-02-20 Thread Adrian Klaver
On 2/20/23 11:36, p...@pfortin.com wrote: On Mon, 20 Feb 2023 11:06:34 -0800 Adrian Klaver wrote: On 2/20/23 10:27, p...@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_dum

Re: pg_dump'ed file contains "DROP DATABASE"

2023-02-20 Thread Adrian Klaver
On 2/20/23 11:36, p...@pfortin.com wrote: On Mon, 20 Feb 2023 11:06:34 -0800 Adrian Klaver wrote: On 2/20/23 10:27, p...@pfortin.com wrote: [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

Re: pg_dump'ed file contains "DROP DATABASE"

2023-02-20 Thread pf
On Mon, 20 Feb 2023 11:06:34 -0800 Adrian Klaver wrote: >On 2/20/23 10:27, p...@pfortin.com wrote: >> [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 r

Re: pg_dump'ed file contains "DROP DATABASE"

2023-02-20 Thread Adrian Klaver
On 2/20/23 10:27, p...@pfortin.com wrote: [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" --us

Re: pg_dump'ed file contains "DROP DATABASE"

2023-02-20 Thread Tom Lane
p...@pfortin.com writes: > 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" > Was my 134 table[1] myname DB saved because it was open? Yup. > If the dump