----- Original Message -----
From: "Jeff Davis" <[EMAIL PROTECTED]>
To: "Ardian Xharra" <[EMAIL PROTECTED]>
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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
