Обсуждение: Cannot see the start server Icon

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@pgadmin.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@dell.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

Hi,

 

I reset the value but still the problem prevails. I am still getting the following error at the cmd prompt

 

C:\Program Files (x86)\PostgresPlus\9.0SS\bin>pg_ctl start -D "C:/Program Files

(x86)/PostgresPlus/9.0SS/data

server starting

 

C:\Program Files (x86)\PostgresPlus\9.0SS\bin>2011-07-08 15:24:02 IST FATAL:  re

quested shared memory size overflows size_t

 

 

 When I restarted the system I got the error

 

But My internet connection is fine and I was able to download the drivers through stack builder.

 Also I do not see the green start server icon in the start up menu which is mentioned in all the documents and forum discussions.

 

Thanks,

Mamatha

 

---

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: Friday, July 08, 2011 2:21 PM

To: Chan, Mamatha Kagathi
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Cannot see the start server Icon

 

 

On Fri, Jul 8, 2011 at 9:44 AM, <Mamatha_Kagathi_Chan@dell.com> wrote:

Hi,

 

Following is present in the postgresql.conf.

 

# - Memory -

 

#shared_buffers = 32MB               # min 128kB

shared_buffers = 902521              # min 128kB or max_connections*16kB

Yes - try setting it to 512MB.

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

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

Hi Dave,

 

Due to some technical issue I was not able to download the 9.0.4 version successfully. Hence I Uninstalled and reinstalled the 9.0.2 version. After completing the installation I was able to see the service and I no more get the error while starting the service and each time Postmaster.OPTS file is being generated. However, I am still not able to start the server and I get the following message. I also get the error in the second screen shot every now and then. I feel there is some connectivity issue with postgres alone. Hence I am attaching the pg_hba file with this mail. Please let me know if you can help me here.

 

 

 

Thanks,

Mamatha

---

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: Friday, July 08, 2011 5:59 PM

To: Chan, Mamatha Kagathi
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Cannot see the start server Icon

 

 

On Fri, Jul 8, 2011 at 1:23 PM, <Mamatha_Kagathi_Chan@dell.com> wrote:

Hi Dave,

 

After rebooting the system (twice) I still do not see the service and get the same message. I am pasting the screenshot of the service manager, I see only scheduler services.

 

I'm not sure what's happened in that case. Please download http://www.enterprisedb.com/postgresql-904-installers-win32 (that's the PG 9.0.4 installer) and run it. It should upgrade/reinstall the Postgres Plus Standard Server database component. 

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

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

Hi Dave,

 

I am pasting the content of the error window as mentioned below. I am attachin the log as found in Pg_log and I have also mentioned the messages as found in event log.

 

---------------------------

Error

---------------------------

An error occured checking the catalog:

 

Host  not found

 

Hint:Please check internet connection or proxy server configurations.

---------------------------

OK  

---------------------------

 

EVENT LOG (repetitively)

 

Timed out waiting for server startup

Waiting for server startup...

 

 

Thanks,

Mamatha

---

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: Monday, July 11, 2011 6:30 PM

To: Chan, Mamatha Kagathi
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Cannot see the start server Icon

 

Hi,

 

Your second screenshot is just black, so I can't see the error. Can you please check the logs (event log, and in $PGDATA/pg_log) for errors, and send a readable version of the screenshot?

 

Thanks.

On Mon, Jul 11, 2011 at 1:37 PM, <Mamatha_Kagathi_Chan@dell.com> wrote:

Hi Dave,

 

Due to some technical issue I was not able to download the 9.0.4 version successfully. Hence I Uninstalled and reinstalled the 9.0.2 version. After completing the installation I was able to see the service and I no more get the error while starting the service and each time Postmaster.OPTS file is being generated. However, I am still not able to start the server and I get the following message. I also get the error in the second screen shot every now and then. I feel there is some connectivity issue with postgres alone. Hence I am attaching the pg_hba file with this mail. Please let me know if you can help me here.

 

 

 

Thanks,

Mamatha

---

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: Friday, July 08, 2011 5:59 PM

To: Chan, Mamatha Kagathi
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Cannot see the start server Icon

 

 

On Fri, Jul 8, 2011 at 1:23 PM, <Mamatha_Kagathi_Chan@dell.com> wrote:

Hi Dave,

 

After rebooting the system (twice) I still do not see the service and get the same message. I am pasting the screenshot of the service manager, I see only scheduler services.

 

I'm not sure what's happened in that case. Please download http://www.enterprisedb.com/postgresql-904-installers-win32 (that's the PG 9.0.4 installer) and run it. It should upgrade/reinstall the Postgres Plus Standard Server database component. 

--
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