On Wed, Jun 19, 2024 at 8:55 AM Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:
Is the correct date format for pg_dump
<filename>-$(date +%Y-%m-%d).sql
or
<filename>-YYYY-MM-DD.sql
or something else?
If you are doing a custom format dump using .sql as the extension is objectively wrong. it is correct if you are doing an sql dump, but those are generally best avoided.
David J.