Архив метки: pg_dumpall

SET postgresbindir=C:\Program Files\PostgreSQL\9.2.1-1.1C\bin SET backupdir=e:\backup cd /D %postgresbindir% создаем pgpass.conf echo server:5432:*:postgres:password > %APPDATA%\postgresql\pgpass.conf Полный бэкап баз rem dump_all pg_dump –file=%backupdir%\%date:~6,4%%date:~3,2%%date:~0,2%_postgres –host=server –username=postgres postgres Бэкап отдельной базы с компрессией rem staff pg_dump –file=%backupdir%\%date:~6,4%%date:~3,2%%date:~0,2%_stuff –compress=9 –host=dbserver –username=postgres staff http://www.postgresql.org/docs/8.3/static/libpq-pgpass.html http://wiki.postgresql.org/wiki/Automated_Backup_on_Windows