>> "open_datasync"
>
> This setting is only safe if you disable write cache.
Thanks you for explanation.
I expected that default installation does not cause data loss in any
maschine configuration.
I don't remember was write cache enabling Windows default setting or was it
set by me.
Andrus.
> > What version exactly was this? There was some changes in
> 8.0.2 in this
> > area on win32. The default sync method was also changed at
> this point.
>
> "PostgreSQL 8.0.2 on i686-pc-mingw32, compiled by GCC gcc.exe
> (GCC) 3.4.2 (mingw-special)"
There we go. That explains it - you have t
> What version exactly was this? There was some changes in 8.0.2 in this
> area on win32. The default sync method was also changed at this point.
"PostgreSQL 8.0.2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)"
> What's the output of "show wal_sync_method"?
"open_datas
> > And do your disks honour the fsync? Was a power failure the
> cause of this?
>
>
> I have usual office PC using Quantum FireballP LM20.5 20 GB
> IDE HDD with
> XP drivers.
> How to determine is fsync working or not ?
> I use default postgres.conf file ( added only listen_addresses = '*'
klient table has oid 66079
file 66079 size is 13 MB
in correct copy klient table file size is 5MB
it seems that other table, nomenkla oid=65783 is added to the end of
klient table.
How to repair file 66079 so that it contains only 3686 rows from beginning ?
---(end
It seems that corrupted table klient contains data from some other table.
select * from firma1.klient limit 3686;
Seems to return all data from table.
Starting at row 3687 table contains data from other table.
VACUUM command returns:
INFO: vacuuming "firma1.klient"
ERROR: invalid page heade
>> Today morning suddenly one table in one database, firma1.klient is
>> corrupted. When trying to backup it using pgAdmin III I get the log
>> below and backup is not created.
>
> What caused this? Presumably you had a power/system-failure or similar?
Windows XP does not respond and I pressed
Andrus wrote:
I have Postgres 8 running on Windows XP
The size of data subdirectory is 326 MB
Today morning suddenly one table in one database, firma1.klient is
corrupted. When trying to backup it using pgAdmin III I get the log below
and backup is not created.
What caused this? Presumably
