Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # linux
- PGPASSWORD="password" pg_dump -h host -p port -U username database > file.sql
- # windows (NO SPACE between 'password' and '&&')
- SET PGPASSWORD=password&& pg_dump -h host -p port -U username database > file.sql
- # alternative
- pg_dump --dbname=postgresql://username:password@host:port/database > file.sql
- # restore
- psql -U postgres database < file.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement