Re: file system level backup

From: zach cruise <zachc1980(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, sameer(dot)kumar(at)ashnik(dot)com
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: file system level backup
Date: 2014-01-06 15:03:10
Message-ID: CAL8icXwYkYDKprSaKa2TitygZzWBWTLQ_nTBne9e=E5Uy-Jtyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am not sure if you have already answered it and I have somehow missed it:
- Are these 'a' and 'b' on two different servers? ( I think they are on
different servers)

> yes

- Did you stop the server on 'b' before you replaced the files and
attempted a startup?

> yes

> thanks. it doesn't help. i also tried pg_ctl without luck (
http://www.postgresql.org/docs/9.3/static/app-pg-ctl.html)

What exact pg_ctl command you used?

> "pg_ctl start" and "pg_ctl stop"

---

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.

Whoa, how did we get to that conclusion?

> as a safety, i had also renamed old data-b. when copying old data-b
from the network didn't work, i renamed it back. and that worked.

Well all that proves is that there is some difference between the data
directories. That could be corruption, it could be something else.

Since we are on the subject of corruption and this is Windows, do you have
anti-virus software running on these machines?

If so, is it pointed at the directories in question?

> yes (symantec) but it is pointed to both directories, old data-b and
renamed old data-b, so i doubt if that is the issue.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Woodbridge 2014-01-06 15:13:46 How to check for pending CancelRequest from C/C++ function
Previous Message Pfuntner, John 2014-01-06 15:00:29 Do I have to free storage in a UDF if I raise an error?