Advertisement
Guest User

Untitled

a guest
Jul 19th, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. set PGUSER=postgres
  2. set PGPASSWORD=xxx
  3. set OUTPUTPATH=e:\myfile.backup
  4. set DB=whatever
  5. set HOST=whatever
  6.  
  7. pg_dump -h %HOST% -p 5432 -U %PGUSER% -F c -b -v -f %OUTPUTPATH% %DB%
  8.  
  9. rem TCP port to unblock is 5432
  10. echo "host all all 0.0.0.0/0 md5" >> /etc/postgresql/9.3/main/pg_hba.conf
  11. reload service
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement