Jan
25
2012
New post as http://t.co/q0Q9Y0…
New post as http://t.co/q0Q9Y0TS – : To restore a “plain” postgresql backup … http://t.co/EZWaiR7B #twittertools
Jan
25
2012
To restore a “plain” postgresql backup …
1. Drop/Recreate the target database using PGAdmin
2. Be sure to add logins to all roles that are referenced in the backup script. This should only be necessary the first time. The phonesystem db references the following logins… phonesystem, phoneadmin, logsreader.
3. From a terminal window run the following command
sudo psql -d phonesystem -U seths -f “<path-to-backup>”
Seth
