Вобщем навернулась у меня Постгря. Не стого ни с сяго.

ОС Windows 2003 Standart
Версия постгри: 8.1.5-14.1C

Цитаты из лога за пятницу (в понедельник ужо все лежало):

автор
2008-08-15 11:22:13 ERROR: deadlock detected
2008-08-15 11:22:13 DETAIL: Process 254000 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationShareLock on relation 58425 of database 16404; blocked by process 254000.
2008-08-15 11:22:13 WARNING: there is no transaction in progress
2008-08-15 16:01:38 ERROR: deadlock detected
2008-08-15 16:01:38 DETAIL: Process 254000 waits for ApplicationExclusiveLock on relation 61579 of database 16404; blocked by process 255204.
Process 255204 waits for ApplicationExclusiveLock on relation 61515 of database 16404; blocked by process 254000.
2008-08-15 16:01:38 WARNING: there is no transaction in progress
2008-08-15 16:01:40 ERROR: deadlock detected
2008-08-15 16:01:40 DETAIL: Process 255204 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255204.
2008-08-15 16:01:40 WARNING: there is no transaction in progress
2008-08-15 16:02:52 ERROR: deadlock detected
2008-08-15 16:02:52 DETAIL: Process 255204 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255204.
2008-08-15 16:02:52 WARNING: there is no transaction in progress
2008-08-15 16:04:47 ERROR: could not write block 2351 of relation 1663/16404/61966: Invalid argument
2008-08-15 16:04:47 CONTEXT: writing block 2351 of relation 1663/16404/61966
2008-08-15 16:04:47 WARNING: there is no transaction in progress
2008-08-15 16:05:52 ERROR: deadlock detected
2008-08-15 16:05:52 DETAIL: Process 254000 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationShareLock on relation 58341 of database 16404; blocked by process 254000.
2008-08-15 16:05:52 WARNING: there is no transaction in progress
2008-08-15 16:05:53 ERROR: deadlock detected
2008-08-15 16:05:53 DETAIL: Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255204.
Process 255204 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
2008-08-15 16:05:53 WARNING: there is no transaction in progress
2008-08-15 16:06:01 ERROR: deadlock detected
2008-08-15 16:06:01 DETAIL: Process 255204 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255204.
2008-08-15 16:06:01 WARNING: there is no transaction in progress
2008-08-15 16:06:09 ERROR: deadlock detected
2008-08-15 16:06:09 DETAIL: Process 254000 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 254000.
2008-08-15 16:06:09 WARNING: there is no transaction in progress
2008-08-15 16:06:11 ERROR: deadlock detected
2008-08-15 16:06:11 DETAIL: Process 254000 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 254000.
2008-08-15 16:06:11 WARNING: there is no transaction in progress
2008-08-15 16:06:20 ERROR: deadlock detected
2008-08-15 16:06:20 DETAIL: Process 255296 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 254000.
Process 254000 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255296.
2008-08-15 16:06:20 WARNING: there is no transaction in progress
2008-08-15 16:06:28 ERROR: deadlock detected
2008-08-15 16:06:28 DETAIL: Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 254000.
Process 254000 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
2008-08-15 16:06:28 WARNING: there is no transaction in progress
2008-08-15 16:07:02 ERROR: deadlock detected
2008-08-15 16:07:02 DETAIL: Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255204.
Process 255204 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
2008-08-15 16:07:02 WARNING: there is no transaction in progress
2008-08-15 16:08:39 ERROR: deadlock detected
2008-08-15 16:08:39 DETAIL: Process 255296 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255204.
Process 255204 waits for ApplicationExclusiveLock on relation 62212 of database 16404; blocked by process 255296.
2008-08-15 16:08:39 WARNING: there is no transaction in progress
2008-08-15 16:08:57 ERROR: deadlock detected
2008-08-15 16:08:57 DETAIL: Process 254000 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationShareLock on relation 58341 of database 16404; blocked by process 254000.
2008-08-15 16:08:57 WARNING: there is no transaction in progress
2008-08-15 16:09:29 ERROR: deadlock detected
2008-08-15 16:09:29 DETAIL: Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 254000.
Process 254000 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255296.
2008-08-15 16:09:29 WARNING: there is no transaction in progress
2008-08-15 16:09:30 ERROR: deadlock detected
2008-08-15 16:09:30 DETAIL: Process 255204 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 254000.
Process 254000 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255204.
2008-08-15 16:09:30 WARNING: there is no transaction in progress
2008-08-15 16:09:33 ERROR: deadlock detected
2008-08-15 16:09:33 DETAIL: Process 254000 waits for ApplicationExclusiveLock on relation 61579 of database 16404; blocked by process 255204.
Process 255204 waits for ApplicationExclusiveLock on relation 61515 of database 16404; blocked by process 254000.
2008-08-15 16:09:33 WARNING: there is no transaction in progress
2008-08-15 16:10:58 ERROR: deadlock detected
2008-08-15 16:10:58 DETAIL: Process 254000 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 254000.
2008-08-15 16:10:58 WARNING: there is no transaction in progress
2008-08-15 16:11:07 ERROR: deadlock detected
2008-08-15 16:11:07 DETAIL: Process 254000 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 254000.
2008-08-15 16:11:07 WARNING: there is no transaction in progress
2008-08-15 16:11:25 ERROR: deadlock detected
2008-08-15 16:11:25 DETAIL: Process 254000 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 254000.
2008-08-15 16:11:25 WARNING: there is no transaction in progress
2008-08-15 16:12:57 ERROR: deadlock detected
2008-08-15 16:12:57 DETAIL: Process 255296 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 254000.
Process 254000 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255296.
2008-08-15 16:12:57 WARNING: there is no transaction in progress
2008-08-15 16:13:01 ERROR: deadlock detected
2008-08-15 16:13:01 DETAIL: Process 255204 waits for ApplicationExclusiveLock on relation 61515 of database 16404; blocked by process 254000.
Process 254000 waits for ApplicationExclusiveLock on relation 61579 of database 16404; blocked by process 255204.
2008-08-15 16:13:02 WARNING: there is no transaction in progress
2008-08-15 16:14:41 ERROR: deadlock detected
2008-08-15 16:14:41 DETAIL: Process 254000 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255204.
Process 255204 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 254000.
2008-08-15 16:14:41 WARNING: there is no transaction in progress
2008-08-15 16:15:03 ERROR: deadlock detected
2008-08-15 16:15:03 DETAIL: Process 255204 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255204.
2008-08-15 16:15:03 WARNING: there is no transaction in progress
2008-08-15 16:15:32 ERROR: deadlock detected
2008-08-15 16:15:32 DETAIL: Process 255204 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255204.
2008-08-15 16:15:32 WARNING: there is no transaction in progress
2008-08-15 16:15:39 ERROR: deadlock detected
2008-08-15 16:15:39 DETAIL: Process 255204 waits for ApplicationExclusiveLock on relation 61579 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 61515 of database 16404; blocked by process 255204.
2008-08-15 16:15:39 WARNING: there is no transaction in progress
2008-08-15 16:16:27 ERROR: deadlock detected
2008-08-15 16:16:27 DETAIL: Process 255204 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 254000.
Process 254000 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255204.
2008-08-15 16:16:27 WARNING: there is no transaction in progress
2008-08-15 16:16:34 ERROR: deadlock detected
2008-08-15 16:16:34 DETAIL: Process 255204 waits for ApplicationExclusiveLock on relation 61515 of database 16404; blocked by process 254000.
Process 254000 waits for ApplicationExclusiveLock on relation 61579 of database 16404; blocked by process 255204.
2008-08-15 16:16:34 WARNING: there is no transaction in progress
2008-08-15 16:16:51 ERROR: deadlock detected
2008-08-15 16:16:51 DETAIL: Process 254000 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255204.
Process 255204 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 254000.
2008-08-15 16:16:51 WARNING: there is no transaction in progress
2008-08-15 16:17:13 ERROR: deadlock detected
2008-08-15 16:17:13 DETAIL: Process 255204 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255204.
2008-08-15 16:17:13 WARNING: there is no transaction in progress
2008-08-15 16:17:19 ERROR: deadlock detected
2008-08-15 16:17:19 DETAIL: Process 255296 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 283252.
Process 283252 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 254000.
Process 254000 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255296.
2008-08-15 16:17:19 WARNING: there is no transaction in progress
2008-08-15 16:17:22 ERROR: deadlock detected
2008-08-15 16:17:22 DETAIL: Process 254000 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 283252.
Process 283252 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 254000.
2008-08-15 16:17:22 WARNING: there is no transaction in progress
2008-08-15 16:17:27 ERROR: deadlock detected
2008-08-15 16:17:27 DETAIL: Process 254000 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 254000.
2008-08-15 16:17:27 WARNING: there is no transaction in progress
2008-08-15 16:18:44 ERROR: deadlock detected
2008-08-15 16:18:44 DETAIL: Process 283252 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 283252.
2008-08-15 16:18:44 WARNING: there is no transaction in progress
2008-08-15 16:19:37 ERROR: could not read block 108 of relation 1663/16404/2659: Invalid argument
2008-08-15 16:19:37 WARNING: there is no transaction in progress
2008-08-15 16:20:55 ERROR: deadlock detected
2008-08-15 16:20:55 DETAIL: Process 283252 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 254000.
Process 254000 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 283252.
2008-08-15 16:20:55 WARNING: there is no transaction in progress
2008-08-15 16:21:19 ERROR: deadlock detected
2008-08-15 16:21:19 DETAIL: Process 254000 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 283252.
Process 283252 waits for ApplicationExclusiveLock on relation 62192 of database 16404; blocked by process 254000.
2008-08-15 16:21:19 WARNING: there is no transaction in progress
2008-08-15 16:46:42 ERROR: deadlock detected
2008-08-15 16:46:42 DETAIL: Process 283252 waits for ApplicationExclusiveLock on relation 59394 of database 16404; blocked by process 255296.
Process 255296 waits for ApplicationShareLock on relation 259096 of database 16404; blocked by process 283252.
2008-08-15 16:46:42 WARNING: there is no transaction in progress
2008-08-15 16:47:00 ERROR: deadlock detected
2008-08-15 16:47:00 DETAIL: Process 255296 waits for ApplicationExclusiveLock on relation 61515 of database 16404; blocked by process 283252.
Process 283252 waits for ApplicationExclusiveLock on relation 61579 of database 16404; blocked by process 255296.
2008-08-15 16:47:00 WARNING: there is no transaction in progress
2008-08-15 18:01:37 ERROR: could not open relation 1663/16404/62226: Invalid argument
2008-08-15 18:01:37 CONTEXT: writing block 115 of relation 1663/16404/62226
2008-08-15 18:01:37 WARNING: there is no transaction in progress
2008-08-15 18:38:45 ERROR: could not open relation 1663/16404/61932: Invalid argument
2008-08-15 18:38:45 CONTEXT: writing block 36390 of relation 1663/16404/61932
2008-08-15 20:27:41 FATAL: could not access status of transaction 19837364
2008-08-15 20:27:41 DETAIL: could not open file "pg_clog/0012": Invalid argument
2008-08-15 20:27:41 LOG: server process (PID 255296) was terminated by signal 1
2008-08-15 20:27:41 LOG: terminating any other active server processes
2008-08-15 20:27:41 WARNING: terminating connection because of crash of another server process
2008-08-15 20:27:41 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-08-15 20:27:41 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-08-15 20:27:41 WARNING: terminating connection because of crash of another server process
2008-08-15 20:27:41 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2008-08-15 20:27:41 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2008-08-15 20:27:41 LOG: all server processes terminated; reinitializing
2008-08-15 20:27:41 LOG: database system was interrupted at 2008-08-15 20:27:40 Московское время (лето)
2008-08-15 20:27:41 LOG: checkpoint record is at 10/6A763178
2008-08-15 20:27:41 LOG: redo record is at 10/6A763178; undo record is at 0/0; shutdown FALSE
2008-08-15 20:27:41 LOG: next transaction ID: 20073129; next OID: 329981
2008-08-15 20:27:41 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2008-08-15 20:27:41 LOG: database system was not properly shut down; automatic recovery in progress
2008-08-15 20:27:42 LOG: redo starts at 10/6A7631C0
2008-08-15 20:27:42 PANIC: could not open relation 1663/16404/317574: No such file or directory

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
2008-08-15 20:27:42 LOG: startup process (PID 313592) was terminated by signal 3
2008-08-15 20:27:42 LOG: aborting startup due to startup process failure
2008-08-15 20:27:42 LOG: logger shutting down


А вот то что в понедельник уже меня встретило:

автор
2008-08-18 08:46:43 LOG: database system was interrupted while in recovery at 2008-08-15 20:27:41 Московское время (лето)
2008-08-18 08:46:43 HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2008-08-18 08:46:43 LOG: checkpoint record is at 10/6A763178
2008-08-18 08:46:43 LOG: redo record is at 10/6A763178; undo record is at 0/0; shutdown FALSE
2008-08-18 08:46:43 LOG: next transaction ID: 20073129; next OID: 329981
2008-08-18 08:46:43 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2008-08-18 08:46:43 LOG: database system was not properly shut down; automatic recovery in progress
2008-08-18 08:46:43 LOG: redo starts at 10/6A7631C0
2008-08-18 08:46:48 PANIC: could not open relation 1663/16404/317574: No such file or directory

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
2008-08-18 08:46:48 LOG: startup process (PID 2408) was terminated by signal 3
2008-08-18 08:46:48 LOG: aborting startup due to startup process failure
2008-08-18 08:46:49 LOG: logger shutting down


Люди добрые поделитесь знаниями мож кто сталкивался с таким... Благодарю заранее.

А теперь своме интересное! База поднялась!

Были Использованы следующие статьи:
http://www.hjackson.org/blog/archives/2004/12/19/postgresql-database-recovery
http://archives.postgresql.org/pgsql-performance/2004-06/msg00234.php

Одна команда resetxlog с нужными параметрами и я снова смог считать базу!