We are in the process of migrating this forum. A new space will be available soon. We are sorry for the inconvenience.

CentOS 5.9 a Postgresql ...


Lewyx
05-08-2014, 22:30
Nie dubluj tematów.

filo1
04-08-2014, 23:19
Witajcie,


chciałbym dowiedzieć się czy mając dedyka z centOS 5.9 i bazą danych postgresql 8.4 czy mogę bazę postgresql bez problemowo zaktualizować do 9.3 ?

Pytam dlatego, ponieważ od pewnego czasu baza mi się wyłącza, w logach mam następujące błędy:

WARNING: nonstandard use of \\ in a string literal at character 67
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
LOG: could not receive data from client: Connection timed out
LOG: unexpected EOF on client connection
LOG: could not receive data from client: Connection timed out
LOG: unexpected EOF on client connection
WARNING: nonstandard use of \\ in a string literal at character 67
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \' in a string literal at character 47
HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...').
WARNING: nonstandard use of escape in a string literal at character 47
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING: nonstandard use of escape in a string literal at character 47
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
LOG: background writer process (PID 7412) was terminated by signal 9: Killed
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
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.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
WARNING: terminating connection because of crash of another server process

shared buffers ustawiłem zgodnie z dokumentacją postgresa, czyli 1/4 dostępnej pamięci serwera.

Czy mógłby ktoś mi tutaj podpowiedzieć ?.

Pozdrawiam.