CODEWITHSUNDEEP
linuxbashpostgresqlshellbackup
Luiz E.
Luiz E.

Reputation: 7239

Create PostgreSQL backup files with timestamp

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.

Upvotes: 9

Views: 13352

Answers (3)

Anton Shevelev
Anton Shevelev

Reputation: 1

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

Upvotes: 0

Ed Heal
Ed Heal

Reputation: 59997

Use backticks and the date command.

i.e.

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

Upvotes: 4

Anton Kovalenko
Anton Kovalenko

Reputation: 21507

Try this:

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

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

Upvotes: 25

Related Questions