sudo -u postgres createuser -D -A -P myuser
sudo -u postgres createdb -O myuser mydb
pg_dump -i -h localhost -p 5432 -U myuser -f "/tmp/mydb.sql" mydb --schema=mydb_schema
psql -h localhost -p 5432 -U myuser -d mydb < mydb.sql
pg_dump -i -h localhost -p 5432 -U myuser -F c -b -v -f "/tmp/mydb.backup" mydb --schema=mydb_schema
pg_restore -i -h localhost -p 5432 -U myuser -d mydb -v "/tmp/mydb.backup"
sudo -u postgres createdb -O myuser mydb
pg_dump -i -h localhost -p 5432 -U myuser -f "/tmp/mydb.sql" mydb --schema=mydb_schema
psql -h localhost -p 5432 -U myuser -d mydb < mydb.sql
pg_dump -i -h localhost -p 5432 -U myuser -F c -b -v -f "/tmp/mydb.backup" mydb --schema=mydb_schema
pg_restore -i -h localhost -p 5432 -U myuser -d mydb -v "/tmp/mydb.backup"
Comments
Post a Comment