Search code examples
linuxbashpostgresqlshellbackup

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.

Solution

  • Try this:

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

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