Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied - Mailing list pgsql-general

From John T. Dow
Subject Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
Date
Msg-id 201006081244.o58CiS1d033875@web7.nidhog.com
Whole thread Raw
In response to Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied  ("John T. Dow" <john@johntdow.com>)
List pgsql-general
On Tue, 08 Jun 2010 10:25:49 +0800, Craig Ringer wrote:

>On 8/06/2010 9:11 AM, John T. Dow wrote:
>> OP here....
>>
>> We removed AVG from the computer and rebooted.
>>
>> Same problem.
>
>OK, good to know. Thanks very much for testing that, and my apologies
>for recommending something that didn't work out. Of course, it would
>have been hard to progress without eliminating that possible factor.
>
>> Could it be 2000 Server? SP4? I've seen reports of other problems that went away depending on the version of
Windows.
>
>Well, certainly I'd expect that Pg on Windows 2000 server gets about
>zero regular testing. Why would you deploy a server OS that's already 10
>years out of date, went EOL five years ago, and lost even the option of
>paid extended support this year?
>
>http://support.microsoft.com/lifecycle/?LN=en-au&x=14&y=11&p1=7274
>





Good point.

It's not my server, it's my client's server, and I don't know the history of it.

They have mentioned another computer which runs XP I believe. It's dedicated to a single task and could double as the
databaseserver, although I don't think it has any RAID. I will suggest that we try installing Postgres on that computer
andsee if the problem goes away. If so, they might choose to make that their solution (perhaps adding another hard
driveand a RAID controller). The application, daily backups, and WAL files could all live on the original server. 

If they go that route, we'd never know for certain what the original problem was.

I'll post back after anything is done.

JOhn









>It'd be interesting to investigate this issue ... but win2k server isn't
>exactly easy to come by. Anyone on the list got a win2k server (or
>license) around they can do some experimenting on? All I have here is
>NT4 (not kidding - legacy system) and Win2k8 plus the usual desktop
>suspects.
>
>--
>Craig Ringer
>
>
>--
>Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general



pgsql-general by date:

Previous
From: "Jaiswal Dhaval Sudhirkumar"
Date:
Subject: >>relation with OID 1211822032 does not exist
Next
From: Craig Ringer
Date:
Subject: Re: >>relation with OID 1211822032 does not exist