public inbox for [email protected]  

help / color / mirror / Atom feed

Proper 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]>
  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 16:14  David G. Johnston <[email protected]>
  parent: 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 17:13  Rich Shepard <[email protected]>
  parent: David G. Johnston <[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 17:15  Ron Johnson <[email protected]>
  parent: 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 17:38  Rich Shepard <[email protected]>
  parent: Ron Johnson <[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