[ADMIN] pgsql 8.3.3 "Invalid page header" leads to "FATAL: segment too big"

Hello, i have this serious problem in one of our remote vessels. (comm is done by minicom to the remote satelite modem) I think that this server was under some sort of constant resets or hardware failures. Initially,i had this problem: ERROR: invalid page header in block 672720 of relation "pg_t

Re: [ADMIN] pgsql 8.3.3 "Invalid page header" leads to "FATAL: segment too big"

2010/4/22 Achilleas Mantzios : > Hello, > i have this serious problem in one of our remote vessels. (comm is done by > minicom to the remote satelite modem) > I think that this server was under some sort of constant resets or hardware > failures. > Initially,i had this problem: > ERROR:  invalid

Re: [ADMIN] pgsql 8.3.3 "Invalid page header" leads to "FATAL: segment too big"

Achilleas Mantzios writes: > Then i did: (as i said i do not need the contents of msgsource - yet the > contents of msgno are vital) > dd if=/dev/zero of=/usr/local/var/lib/pgsql/data/base/125714957/125716013 > seek=672720 bs=8192 count=1 > However, after that, unfortunately i get constant pos

Re: [ADMIN] pgsql 8.3.3 "Invalid page header" leads to "FATAL: segment too big"

Στις Thursday 22 April 2010 16:53:05 ο/η Cédric Villemain έγραψε: > 2010/4/22 Achilleas Mantzios : > > Hello, > > i have this serious problem in one of our remote vessels. (comm is done by > > minicom to the remote satelite modem) > > I think that this server was under some sort of constant resets

Re: [ADMIN] pgsql 8.3.3 "Invalid page header" leads to "FATAL: segment too big"

Στις Thursday 22 April 2010 17:42:33 γράψατε: > Achilleas Mantzios writes: > > Then i did: (as i said i do not need the contents of msgsource - yet the > > contents of msgno are vital) > > dd if=/dev/zero of=/usr/local/var/lib/pgsql/data/base/125714957/125716013 > > seek=672720 bs=8192 count=1

Re: [ADMIN] pgsql 8.3.3 "Invalid page header" leads to "FATAL: segment too big"

2010/4/22 Achilleas Mantzios : > Στις Thursday 22 April 2010 16:53:05 ο/η Cédric Villemain έγραψε: >> 2010/4/22 Achilleas Mantzios : >> > Hello, >> > i have this serious problem in one of our remote vessels. (comm is done by >> > minicom to the remote satelite modem) >> > I think that this server

Re: [ADMIN] pgsql 8.3.3 "Invalid page header" leads to "FATAL: segment too big"

Στις Thursday 22 April 2010 19:02:00 ο/η Cédric Villemain έγραψε: > 2010/4/22 Achilleas Mantzios : > > Στις Thursday 22 April 2010 16:53:05 ο/η Cédric Villemain έγραψε: > >> 2010/4/22 Achilleas Mantzios : > >> > Hello, > >> > i have this serious problem in one of our remote vessels. (comm is done