FYI:
*WARNING* Almost *all* of my VM's stopped working today. I got some error on startup - but before they could really even start to start up.
*In case you have this problem* here is the work around I figured out, it is strange:
1. In virtual box there are some alternate ways to start a VM, one is called "Detachable Start"
2. Start your failing VM using "Detachable Start", you may have to start it twice
3. When it starts is will have crashed Windows and rebooted Windows ( so you will not have the state you saved the VM in )
4. Once it starts, snapshot it and that new snapshot will start up normally.
Friday, May 27, 2016
Friday, May 6, 2016
PostgreSQL database backup and restore
I needed to backup a DB then reset a VM and then put the backup on it.
This is what I did ( I think )
To dump it to a file of sql commands:
pg_dump -U [user-name] [source db name] -f [name of file to dump it to]
One nice thing is that it is human readable.
To reinstall it:
This is what I did ( I think )
To dump it to a file of sql commands:
pg_dump -U [user-name] [source db name] -f [name of file to dump it to]
One nice thing is that it is human readable.
To reinstall it:
- I had to drop the existing DB with the same name ( I used pgAdmin III to do so)
- I recreated an empty DB with the same name, and since I needed extensions, I added the 2 extensions I needed.
- Then I loaded it in ( which could have been to a different DB name, but in my case I used the same one ):
pgsl -U [user-name] -d [db name to restore to] -f [name of the dump file]
Also note that the commands are found in PostgreSQL's bin directory.
Subscribe to:
Posts (Atom)