Home | Mirror | Search |
Backup
pg_dump -i -h localhost -p 5432 -U user -Fc -c -f "your_db.backup" your_db
Restore
pg_restore -i -h localhost -p 5432 -U user -d your_db -v -c -Fc "your_db.backup"
local -> remote
set PG_HOME="C:\Program Files\PostgreSQL\8.1\bin" %PG_HOME%\pg_dump.exe -i -h localhost -p 5432 -U woodart -Fc -c -f "woodart.backup" woodart %PG_HOME%\pg_restore.exe -i -h woodart.8800.org -p 5432 -U woodart -d woodart -v -c -Fc "woodart.backup"