Re: Data corruption - Mailing list pgsql-general

From Ardian Xharra
Subject Re: Data corruption
Date
Msg-id 0d4601c70824$39f80970$0f01a8c0@Boxxo
Whole thread Raw
In response to Data corruption  ("Ardian Xharra" <axharra@boxxo.info>)
List pgsql-general

----- Original Message -----
From: "Jeff Davis" <pgsql@j-davis.com>
To: "Ardian Xharra" <axharra@boxxo.info>
Cc: "postgreSQL postgreSQL" <pgsql-general@postgresql.org>
Sent: Tuesday, November 14, 2006 2:12 PM
Subject: Re: [GENERAL] Data corruption


> On Tue, 2006-11-14 at 13:34 -0500, Ardian Xharra wrote:
>> Hi all,
>>
>> We have a database installed on Intel Xeon (Dell) and running on
>> postgreSQL 8.1.
>> And the database couldn't start. Here is the logfile of what happend:
>>
>> 2006-11-14 00:28:38 PANIC:  could not write to log file 6, segment 239
>> at offset 6430720, length 16384: Permission denied
>>
>
> Are you running PostgreSQL as a user other than the one that owns the
> data directory? Did the filesystem somehow get mounted in RO mode?
>
> Regards,
> Jeff Davis

I'm running under Windows.
PostgreSQL runs through user postgres created during the installation.
The filesystem is NTFS

>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.409 / Virus Database: 268.14.5/533 - Release Date: 13/11/2006
>
>



pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: database dump then restore on another system?
Next
From: "Dave Page"
Date:
Subject: Re: Trouble migrating from PostgreSQL --> Oracle