Skip site navigation (1) Skip section navigation (2)

Re: Cannot see the start server Icon

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Mamatha_Kagathi_Chan(at)dell(dot)com
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Cannot see the start server Icon
Date: 2011-07-08 08:22:20
Message-ID: CA+OCxowhZ4y1hXDNhZNJ1UMmr3wc6cOzia_p2zFkgy-mkTcgVg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
Hi,

Seems like this is probably the issue:

4.2011-07-06 12:30:54 IST FATAL:  requested shared memory size overflows
size_t

What do you have shared_buffers set to in the config? Typically on Windows
(unlike Unix/Linux) no more than 512MB should be used.

On Fri, Jul 8, 2011 at 7:57 AM, <Mamatha_Kagathi_Chan(at)dell(dot)com> wrote:

> ****
>
> Hi Dave,****
>
> ** **
>
> I found the following messages in the application log for Postgres.  The
> Multiple error set I have mentioned could be mostly the result of my attempt
> to start the service as I had mentioned earlier. I have displayed the logs
> in chronological order.****
>
> ** **
>
> ** **
>
> 1.  Waiting for server startup...****
>
> 2. Server started and accepting connections****
>
> -------multiple sets of the following messages****
>
> 3. Waiting for server startup...****
>
> 4.2011-07-06 12:30:54 IST FATAL:  requested shared memory size overflows
> size_t****
>
> 5. Timed out waiting for server startup****
>
> -------multiple sets of the above messages****
>
> ** **
>
> 6. pg_ctl: PID file "C:/Program Files
> (x86)/PostgresPlus/9.0SS/data/postmaster.pid" does not exist****
>
> 7. Is server running?****
>
> 8. pg_ctl: PID file "C:/Program Files
> (x86)/PostgresPlus/9.0SS/data/postmaster.pid" does not exist****
>
> 9. Is server running?****
>
> ** **
>
> Thanks,****
>
> Mamatha****
>
> ** **
>
> ** **
>
> ** **
>  ------------------------------
>
> *From:* Dave Page [mailto:dpage(at)pgadmin(dot)org]
> *Sent:* Friday, July 08, 2011 12:07 PM
> *To:* Chan, Mamatha Kagathi
> *Cc:* pgAdmin Support
>
> *Subject:* Re: [pgadmin-support] Cannot see the start server Icon
> ****
>
>  ** **
>
> [Please keep the mailing list CC'd]****
>
> On Fri, Jul 8, 2011 at 7:29 AM, <Mamatha_Kagathi_Chan(at)dell(dot)com> wrote:****
>
> Hi Dave,****
>
>  ****
>
> I did not find any windows event log for postgres, But I found the
> following log in the data directory.****
>
> ** **
>
> Postgres uses the Application log - did you check there?****
>
>  ****
>
>   ****
>
> When I am trying to log into PgAdmin III, * *I am getting the following
> window after I enter the password.****
>
> ****
>
>  ****
>
>  ** **
>
> That's normal if you try to connect to a server that's not listening.
> There's nothing particularly unusual in the log, it shows the server
> starting, a couple of errors that would have originated from commands sent
> to the server, and then:****
>
> ** **
>
> terminating connection due to administrator command****
>
> ** **
>
> There's nothing to indicate a startup failure.****
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB ****UK****: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company****
>



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2011-07-08 08:50:36
Subject: Re: Cannot see the start server Icon
Previous:From: Mamatha_Kagathi_ChanDate: 2011-07-08 06:57:36
Subject: Re: Cannot see the start server Icon

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group