[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
backup/restore to new server
- Subject: backup/restore to new server
- From: david <..hidden..>
- Date: Wed, 23 Feb 2011 11:56:25 +1100
This is actually about postgres, not LSMB, so hopefully it's not off-topic.
I've cloned my server (using mondoarchive) that contains my LSMB and I'm
installing into a virtual machine. This has taken a significant amount
of time, and now the new VM database is out of date to the old "live"
server, so I have to dump the database from the old server and
re-instate it into the VM before going live.
If I do
# pg_dumpall > dump.sql
# scp dump.sql /path/to/new/server/
# psql -f dump.sql postgres
will psql over-write the old, out-of-date database or is there some
magic I have to do?