Skip to content

Instantly share code, notes, and snippets.

@SpacePurr
Created February 18, 2022 09:02
Show Gist options
  • Save SpacePurr/1e75587d32f85277361d37297c26b5c4 to your computer and use it in GitHub Desktop.
Save SpacePurr/1e75587d32f85277361d37297c26b5c4 to your computer and use it in GitHub Desktop.
postgre restor
psql.exe --host localhost --port 5432 --username=postgres --dbname=template1 –c "CREATE DATABASE UAT_RNB WITH OWNER = postgres ENCODING = 'UTF8' CONNECTION LIMIT = -1"
pg_restore --host localhost --port 5432 --username=postgres --dbname=UAT_RNB --no-owner --no-privileges --verbose D:\work\backups\uat_20220208.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment