.pgdump file extension
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/app-pgdump.html
Description:
Please consider entering a suggested name extension for pg_dump files in
custom format. For example ".pgdump". Nobody would have any doubts that this
is a database backup copy. Over the past 20 years, I have seen many times
that .dump files were treated by various administrators as some minor
temporary files. The abbreviation "PG", on the other hand, is quite
recognizable as PostgreSQL. And such less competent administrators, things
related to PostgreSQL do not touch and the backups will be safe.
On Sat, Jan 2, 2021 at 01:10:26PM +0000, PG Doc comments form wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/app-pgdump.html
Description:Please consider entering a suggested name extension for pg_dump files in
custom format. For example ".pgdump". Nobody would have any doubts that this
is a database backup copy. Over the past 20 years, I have seen many times
that .dump files were treated by various administrators as some minor
temporary files. The abbreviation "PG", on the other hand, is quite
recognizable as PostgreSQL. And such less competent administrators, things
related to PostgreSQL do not touch and the backups will be safe.
This is an interesting idea, but perhaps pgdb.dump might be better. I
agree db.dump isn't clear that it is related to Postgres.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee