R
R
Roman_ Outside2015-07-31 15:11:44
PostgreSQL
Roman_ Outside, 2015-07-31 15:11:44

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

1 answer(s)
P
Pavel Vasterov, 2015-07-31
@new_Roman

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 question

Ask a Question

731 491 924 answers to any question