Re: file system level backup

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(dot)klaver(at)gmail(dot)com