Re: file system level backup - Mailing list pgsql-general

From Adrian Klaver
Subject Re: file system level backup
Date
Msg-id 52C877C4.6070002@gmail.com
Whole thread Raw
In response to file system level backup  (zach cruise <zachc1980@gmail.com>)
Responses Re: file system level backup  (zach cruise <zachc1980@gmail.com>)
List pgsql-general
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@gmail.com


pgsql-general by date:

Previous
From: zach cruise
Date:
Subject: file system level backup
Next
From: Adrian Klaver
Date:
Subject: Re: Suddenly all tables were gone