Create PostgreSQL backup files with timestamp

Question

I'm doing a dump like this pg_dump prod-db -U postgres > prod-db.sql, but would be cool if I could do a dump like pg_dump prod-db -U postgres > prod-db-{date}.sql and be able to generate a file like prod-db-06-02-13.sql via shell...
I have no idea on how to start nor where to looking for. Any ideas, links, docs would be much appreciated.

Stefano Mtangoo · Accepted Answer · 2018-01-19 16:49:46Z

25

Try this:

pg_dump prod-db -U postgres > prod-db-$(date +%d-%m-%y).sql

Here's the date manual, for other format options.

edited Jan 19, 2018 at 16:49

Stefano Mtangoo

6,5408 gold badges56 silver badges102 bronze badges

answered Feb 6, 2013 at 11:52

Anton Kovalenko

21.6k2 gold badges41 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mtasic85 · Accepted Answer · 2021-04-14 17:43:09Z

4

Use backticks and the date command.

i.e.

pg_dump prod-db -U postgres > prod-db-`date +%d-%m-%y`.sql

edited Apr 14, 2021 at 17:43

mtasic85

4,0933 gold badges21 silver badges28 bronze badges

answered Feb 6, 2013 at 11:53

Ed Heal

60.3k18 gold badges91 silver badges137 bronze badges

Comments

Anton Shevelev · Accepted Answer · 2024-02-28 09:53:05Z

0

pg_dump --file="{data_source}-{timestamp}-dump.sql"

answered Feb 28, 2024 at 9:53

Anton Shevelev

1

Collectives™ on Stack Overflow

Create PostgreSQL backup files with timestamp

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related