Skip to content

Instantly share code, notes, and snippets.

@Feroz-Istar
Last active July 18, 2022 15:00
Show Gist options
  • Save Feroz-Istar/879409e66fa50e38b2f45cf25c788031 to your computer and use it in GitHub Desktop.
Save Feroz-Istar/879409e66fa50e38b2f45cf25c788031 to your computer and use it in GitHub Desktop.
pg_dump --host database_ip --username "postgres" -W -F t db_name > backup.tar
pg_restore --host restore_db_ip --username "postgres" --dbname=dbname --verbose backup.tar
pg_restore -U postgres -h localhost -v -d business 2April18_postgresDB.dump
pg_dump -h db.talentify.in -U postgres --format=c -d business > db_postgres06dec.dump
psql -U postgres -d dvd -f public.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment