From: | Andrew Stewart <astew(at)wam(dot)umd(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Strange startup error |
Date: | 2006-03-17 20:05:17 |
Message-ID: | 441B167D.3010901@wam.umd.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have had postgres working perfectly up until recently. Now suddenly I
get an error when trying to run postgres:
% psql
psql: FATAL: No pg_hba.conf entry for host localhost, user postgres,
database postgres
% postmaster &
LOG: could not bind Unix socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not,
remove socket file "/tmp/.s.PGSQL.5432" and retry.
WARNING: could not create Unix-domain socket
FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=5432002, size=3768320, 03600).
HINT: This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space. To reduce the
request size (currently 3768320 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 300) and/or its max_connections
parameter (currently 50).
The PostgreSQL documentation contains more information about
shared memory configuration.
Anyone have an ideas?
-Andrew Stewart
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-17 20:23:37 | Re: efficiency of group by 1 order by 1 |
Previous Message | karly | 2006-03-17 19:21:23 | pgsql variables from records |