Re: Cannot see the start server Icon

Hi,

An hour back I ran upgrade on the PostsresPlus Database Server. I guess that has effected somehow and I do not see the Postgreysql service in the service manager. Do I uninstall and install again? Or am I missing something? Because , when I run the command suggested by you I got "The service name is Invalid" message at cmd.

Thanks,
Mamatha

________________________________
From: Dave Page [mailto:dpage(at)pgadmin(dot)org]
Sent: Friday, July 08, 2011 5:19 PM
To: Chan, Mamatha Kagathi
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Cannot see the start server Icon

Are you logged in as the service user (postgres, normally?). If not, you probably don't have the correct permissions on the data directory. In that case, either use the service manager to start the server, or use "net start postgresql-9.0"
On Fri, Jul 8, 2011 at 12:46 PM, <Mamatha_Kagathi_Chan(at)dell(dot)com<mailto:Mamatha_Kagathi_Chan(at)dell(dot)com>> wrote:
Hi,

After making the changes I am not getting the overflow message. Thanks for that. But I am getting the following error

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 17:08:34 IST LOG: coul
d not create file "postmaster.opts": Permission denied

Thanks,
Mamatha

________________________________
From: Dave Page [mailto:dpage(at)pgadmin(dot)org<mailto:dpage(at)pgadmin(dot)org>]
Sent: Friday, July 08, 2011 5:00 PM

To: Chan, Mamatha Kagathi
Cc: pgadmin-support(at)postgresql(dot)org<mailto:pgadmin-support(at)postgresql(dot)org>
Subject: Re: [pgadmin-support] Cannot see the start server Icon

Hi,

The file has:

#shared_buffers = 512MB # min 512MB
shared_buffers = 536870912 # min 512MB or max_connections*16kB

You've set the comment-out default and the comments, but not the actual configured value (actually, you've increased it further, making the situation worse)! Please change that section to:

#shared_buffers = 32MB # min 128kB
shared_buffers = 512MB # min 128kB or max_connections*16kB

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

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