Answer the question
In order to leave comments, you need to log in
What's the easiest way to automate PostgreSQL backups?
Good afternoon. I have Windows 2012 R2 with PosrgreSQL 9.3.4-1.1C(x64). Everything is set by default. How easy is it to automate backups?
Answer the question
In order to leave comments, you need to log in
pg_dump in cron?
pg_dump -U postgres mybase| gzip > ~/mybase.pgsql.gz
Yes, Windows, you can use kigwin environment or use psql.bat, you will need to specify the path to C:\Program Files\PostgreSQL\version\bin
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question