.pgdump file extension

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

.pgdump file extension

apt.postgresql.org Repository Update
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.
Reply | Threaded
Open this post in threaded view
|

Re: .pgdump file extension

Bruce Momjian
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  <[hidden email]>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

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