Re: Cannot see the start server Icon

I would suggest solving one problem at a time, otherwise things will
just get messy.

The machine may be in need of a reboot - sometimes the service control
manager doesn't immediately show updated services.

On Fri, Jul 8, 2011 at 1:04 PM, <Mamatha_Kagathi_Chan(at)dell(dot)com> wrote:
> 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> 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]
> Sent: Friday, July 08, 2011 5:00 PM
>
> To: Chan, Mamatha Kagathi
> Cc: 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

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

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