From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | zach cruise <zachc1980(at)gmail(dot)com> |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: file system level backup |
Date: | 2014-01-04 22:49:23 |
Message-ID: | 52C88FF3.4080001@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 01/04/2014 02:13 PM, zach cruise wrote:
> I am still not understanding. You have a 2008 server at a and one at b.
> You copied the Postgres data files from 2008 server a to 2008 server b.
> This did not work, so you say you restored the data directory on server
> b from an old copy of the data directory at b.
>
> So where did that old copy come from?
>
> > short answer - from b itself (whatever was created right after
> installation).
>
> > long answer - 2008 servers at a and b. postgres 9.3s at a and b.
> added databases to postgres-a (postgres-b is empty/new). shutdown
> postgres-a and b. copied data-a and b to a network shared between
> server-a and b. deleted data-b on server-b. copied data-a from network
> to server-b.
>
> > restarted postgres-a and postgres-b. postgres-a succeeds. postgres-b
> fails.
>
> > so deleted data on server-b. restored data-b from network ("old
> copy") to server-b. restarted postgres-b. postgres-b still fails.
>
So is there anything in the Windows system logs?
Does the Task Manager show another Postgres running?
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | zach cruise | 2014-01-05 00:37:21 | Re: file system level backup |
Previous Message | zach cruise | 2014-01-04 22:13:30 | Re: file system level backup |