Home > mailing lists

pg_dump -n schema -Fc has a DROP DATABASE command... confused - Mailing list pgsql-admin

From	Wells Oliver
Subject	pg_dump -n schema -Fc has a DROP DATABASE command... confused
Date	January 21, 2022 07:44:26
Msg-id	CAOC+FBWrBPQOeL5_BXL2Xypr9aoJ56fbLsusyM7GU=5nXXaB_Q@mail.gmail.com Whole thread Raw
Responses	Re: pg_dump -n schema -Fc has a DROP DATABASE command... confused ("David G. Johnston" <david.g.johnston@gmail.com>) Re: pg_dump -n schema -Fc has a DROP DATABASE command... confused (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-admin

I did a few pg_dumps of different schemas using:

pg_dump -h host dbname -n schema -Fc > schema.dump

Opening it in VIM brings up a binary file (compressed, sure) but it looks like this:

Which contains the line "DROP DATABASE". Which is weird-- it does not drop the database, I mean, I restored from the same file. Why is this in there?

Doing a text dump w/o -Fc yields a text file with no DROP statement.

More just curious, less afraid at this point.

From: Scott Ribe
Date: 21 January 2022, 02:12:03
Subject: Re: Password authorization

From: "David G. Johnston"
Date: 21 January 2022, 07:57:21
Subject: Re: pg_dump -n schema -Fc has a DROP DATABASE command... confused