From: | William Leite Araújo <william(dot)bh(at)gmail(dot)com> |
---|---|
To: | "Andrew Stewart" <astew(at)wam(dot)umd(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Strange startup error |
Date: | 2006-03-17 20:46:45 |
Message-ID: | bc63ad820603171246w5912a8dfle39b0afcc463f465@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
pg_ctl status [-D /postgres/data/dir]
On 3/17/06, Andrew Stewart <astew(at)wam(dot)umd(dot)edu> wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
William Leite Araújo
From | Date | Subject | |
---|---|---|---|
Next Message | SunWuKung | 2006-03-17 21:00:55 | Re: pgsql variables from records |
Previous Message | Peter Wiersig | 2006-03-17 20:42:09 | Re: Strange startup error |