System lockup

From: DeJuan Jackson <djackson(at)speedfc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: System lockup
Date: 2003-03-28 16:25:16
Message-ID: 3E84776C.5050705@speedfc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Two systems both Red Hat running Postgres 7.3.2
Postgres (installed from tar) data is 1.8G total space (half of which is
static data touched once a night when I vacuum), there are web pages
(Apache 2.0.44, PHP 4.3.2), and scripts (also PHP 4.3.2) intereacting
with both boxes continuously. The only postgres.conf settings that are
moved from default are:
tcpip_socket = true
max_connections = 75
shared_buffers = 150

log_connections = true
log_pid = false
log_statement = true
log_duration = true
log_timestamp = true

stats_command_string = true
stats_row_level = true
stats_block_level = true

System 1:
Red Hat Linux release 8.0 (Psyche) [default server config without X]
kernel version 2.4.18
total system RAM 1.5G
only two services running on the system Postgres and sshd
OpenSSL 0.9.6b [engine] 9 Jul 2001
output from vmstat after 20 hours of uptime (look at the memory):
procs memory swap io system

r b w swpd free buff cache si so bi bo in cs us
0 0 0 0 46080 60348 1382608 0 0 10 6 265 11 0

System 2:
Red Hat Linux release 7.1 (Seawolf) [default server config without X]
kernel version 2.4.2
total system RAM 1G
only three services running on the system Postgres, sshd, and sendmail
(hadn't turned it off yet)
OpenSSL 0.9.6b [engine] 9 Jul 2001
output from vmstat after 20 hours of uptime (look at the memory):
procs memory swap io system
r b w swpd free buff cache si so bi bo in cs us
0 0 0 0 5988 25544 915880 0 0 3 4 58 34 2

I've been running postgres for years on Red Hat systems without a hitch,
but I can't for the life of me figure this one out. So, any help would
be appreciated.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Delao, Darryl W 2003-03-28 16:26:40 Postgres Syslog
Previous Message Jean-Luc Lachance 2003-03-28 16:23:18 Re: missing FROM-clause notice but nothing is missing ...