| From: | zach cruise <zachc1980(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: file system level backup |
| Date: | 2014-01-05 00:37:21 |
| Message-ID: | CAL8icXygNmzUHWZAO77c4FnY_DJoY31+B2Mxq6Em+_p6CbdMqg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
> looks like file system level backups don't work well on windows because
they get corrupted during transfer.
Does the Task Manager show another Postgres running?
> no
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-01-05 01:08:07 | Re: file system level backup |
| Previous Message | Adrian Klaver | 2014-01-04 22:49:23 | Re: file system level backup |