Hi,
I'm running Postgres 7.3.2 and since a couple of week I can read in the log
( twice in a week ):
Apr 8 16:00:03 sdr2 postgres[16882]: [255913] DEBUG: child process (pid
9081) was terminated by signal 11
Apr 8 16:00:03 sdr2 postgres[16882]: [255914] LOG: server process (pid
9081) was terminated by signal 11
Apr 8 16:00:03 sdr2 postgres[16882]: [255915] LOG: terminating any other
active server processes
This is all activity that was performed by the process 9081
( is always the same select that genereate the signal 11 ):
Apr 8 16:00:03 sdr2 postgres[9081]: [255912] LOG: connection received:
host=192.168.135.69 port=33274
Apr 8 16:00:03 sdr2 postgres[9081]: [255913] LOG: connection authorized:
user=push database=empdb
Apr 8 16:00:03 sdr2 postgres[9081]: [255914] DEBUG: /usr/bin/postmaster
child[9081]: starting with (
Apr 8 16:00:03 sdr2 postgres[9081]: [255915] DEBUG: ^Ipostgres
Apr 8 16:00:03 sdr2 postgres[9081]: [255916] DEBUG: ^I-v131072
Apr 8 16:00:03 sdr2 postgres[9081]: [255917] DEBUG: ^I-p
Apr 8 16:00:03 sdr2 postgres[9081]: [255918] DEBUG: ^Iempdb
Apr 8 16:00:03 sdr2 postgres[9081]: [255919] DEBUG: )
Apr 8 16:00:03 sdr2 postgres[9081]: [255920] DEBUG: InitPostgres
Apr 8 16:00:03 sdr2 postgres[9081]: [255921] DEBUG:
StartTransactionCommand
Apr 8 16:00:03 sdr2 postgres[9081]: [255922-1] LOG: query: set datestyle
to 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII
' then 'UNKNOWN' else
Apr 8 16:00:03 sdr2 postgres[9081]: [255922-2] getdatabaseencoding() end;
Apr 8 16:00:03 sdr2 postgres[9081]: [255923] DEBUG: ProcessUtility
Apr 8 16:00:03 sdr2 postgres[9081]: [255924] DEBUG:
CommitTransactionCommand
Apr 8 16:00:03 sdr2 postgres[9081]: [255925] DEBUG:
StartTransactionCommand
Apr 8 16:00:03 sdr2 postgres[9081]: [255926] DEBUG: ProcessQuery
Apr 8 16:00:03 sdr2 postgres[9081]: [255927] DEBUG:
CommitTransactionCommand
Apr 8 16:00:03 sdr2 postgres[9081]: [255928] LOG: duration: 0.016100 sec
Apr 8 16:00:03 sdr2 postgres[9081]: [255929] DEBUG:
StartTransactionCommand
Apr 8 16:00:03 sdr2 postgres[9081]: [255930-1] LOG: query: SELECT
id_publisher FROM v_psl_package_info WHERE id_publisher = 30 AND
publisher_na
me = 'ReutersNews' AND
Apr 8 16:00:03 sdr2 postgres[9081]: [255930-2] id_package = 178 AND
package_name = 'ReutersNews_IT'
Reagards
Gaetano