public inbox for [email protected]
help / color / mirror / Atom feedProper format for pg_dump file date
5+ messages / 3 participants
[nested] [flat]
* Proper format for pg_dump file date
@ 2024-06-19 15:55 Rich Shepard <[email protected]>
2024-06-19 16:14 ` Re: Proper format for pg_dump file date David G. Johnston <[email protected]>
2024-06-19 17:15 ` Re: Proper format for pg_dump file date Ron Johnson <[email protected]>
0 siblings, 2 replies; 5+ messages in thread
From: Rich Shepard @ 2024-06-19 15:55 UTC (permalink / raw)
To: [email protected]
Is the correct date format for pg_dump
<filename>-$(date +%Y-%m-%d).sql
or
<filename>-YYYY-MM-DD.sql
or something else?
TIA,
Rich
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Proper format for pg_dump file date
2024-06-19 15:55 Proper format for pg_dump file date Rich Shepard <[email protected]>
@ 2024-06-19 16:14 ` David G. Johnston <[email protected]>
2024-06-19 17:13 ` Re: Proper format for pg_dump file date Rich Shepard <[email protected]>
1 sibling, 1 reply; 5+ messages in thread
From: David G. Johnston @ 2024-06-19 16:14 UTC (permalink / raw)
To: Rich Shepard <[email protected]>; +Cc: [email protected]
On Wed, Jun 19, 2024 at 8:55 AM Rich Shepard <[email protected]>
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Proper format for pg_dump file date
2024-06-19 15:55 Proper format for pg_dump file date Rich Shepard <[email protected]>
2024-06-19 16:14 ` Re: Proper format for pg_dump file date David G. Johnston <[email protected]>
@ 2024-06-19 17:13 ` Rich Shepard <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: Rich Shepard @ 2024-06-19 17:13 UTC (permalink / raw)
To: [email protected]
On Wed, 19 Jun 2024, David G. Johnston wrote:
> 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,
I use the default text format so restoration is by psql.
Rich
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Proper format for pg_dump file date
2024-06-19 15:55 Proper format for pg_dump file date Rich Shepard <[email protected]>
@ 2024-06-19 17:15 ` Ron Johnson <[email protected]>
2024-06-19 17:38 ` Re: Proper format for pg_dump file date Rich Shepard <[email protected]>
1 sibling, 1 reply; 5+ messages in thread
From: Ron Johnson @ 2024-06-19 17:15 UTC (permalink / raw)
To: pgsql-general
On Wed, Jun 19, 2024 at 11:55 AM Rich Shepard <[email protected]>
wrote:
> Is the correct date format for pg_dump
> <filename>-$(date +%Y-%m-%d).sql
> or
> <filename>-YYYY-MM-DD.sql
>
"Click select" stops at dash in some ssh clients, but not in others.
That's what drives *my* decision making.
(Also, "%F" is equivalent to "%Y-%m-%d".)
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Proper format for pg_dump file date
2024-06-19 15:55 Proper format for pg_dump file date Rich Shepard <[email protected]>
2024-06-19 17:15 ` Re: Proper format for pg_dump file date Ron Johnson <[email protected]>
@ 2024-06-19 17:38 ` Rich Shepard <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: Rich Shepard @ 2024-06-19 17:38 UTC (permalink / raw)
To: pgsql-general
On Wed, 19 Jun 2024, Ron Johnson wrote:
> "Click select" stops at dash in some ssh clients, but not in others.
> That's what drives *my* decision making.
>
> (Also, "%F" is equivalent to "%Y-%m-%d".)
Thanks, Ron.
Rich
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2024-06-19 17:38 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-19 15:55 Proper format for pg_dump file date Rich Shepard <[email protected]>
2024-06-19 16:14 ` David G. Johnston <[email protected]>
2024-06-19 17:13 ` Rich Shepard <[email protected]>
2024-06-19 17:15 ` Ron Johnson <[email protected]>
2024-06-19 17:38 ` Rich Shepard <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox