Re: .pgdump file extension

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(at)momjian(dot)us> https://momjian.us
EnterpriseDB https://enterprisedb.com

The usefulness of a cup is in its emptiness, Bruce Lee