Skip to content

Instantly share code, notes, and snippets.

@jjoergensen

jjoergensen/postgresql_backup_and_restore.sh

Created December 6, 2011 15:23
Show Gist options
  • Save jjoergensen/1438561 to your computer and use it in GitHub Desktop.
Save jjoergensen/1438561 to your computer and use it in GitHub Desktop.
Download ZIP
Verify that postgresql has started
Raw
postgresql_backup_and_restore.sh
pg_dump -Upostgres --format=c --file=testdb_backup.sqlc testdb
pg_restore -Upostgres --verbose --format=c testdb_backup.sqlc
Raw
postgresql_try_create_db.sh
cd /opt/postgres/9.1/bin
createdb testdb
psql
# \c testdb
Raw
source_postgresql.sh
. /opt/postgres/9.1/pg91-openscg.env
Raw
try_connect_postgresql.sh
su postgres
psql
# (and quit with \q)
Raw
verify_postgresql.sh
sudo invoke-rc.d postgres-9.1-openscg status
# or
# telnet 127.0.0.1 5432
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment