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?

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev 
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Reply via email to