On 01/04/2014 12:54 PM, zach cruise wrote:
so i installed 9.3 x64 on two windows 2008 servers from one set of installation files. then i created databases on postgresql a, shutdown all the servers, copied /data/ (from "show data_directory") from postgresql a to postgresql b. in short, i did a full file system level backup (http://www.postgresql.org/docs/9.3/static/backup-file.html).
Questions: 1) Both servers are x64? 2) What installation files(Graphical installer, source,etc)? 3) Does the data directory have the config files?
however, postgresql b won't start ("not listening")?
4) How are you starting? 5) What is the exact error message and where are you seeing it?
so i restored postgresql b's old /data/, but it still won't start?!
6) So there was an existing Postgres instance at b? 7) What version was it?
help! (longer answer - what's the best way to copy data from a to b?)
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general