Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- set PGUSER=postgres
- set PGPASSWORD=xxx
- set OUTPUTPATH=e:\myfile.backup
- set DB=whatever
- set HOST=whatever
- pg_dump -h %HOST% -p 5432 -U %PGUSER% -F c -b -v -f %OUTPUTPATH% %DB%
- rem TCP port to unblock is 5432
- echo "host all all 0.0.0.0/0 md5" >> /etc/postgresql/9.3/main/pg_hba.conf
- reload service
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement