Re: Cannot see the start server Icon - Mailing list pgadmin-support
From | Dave Page |
---|---|
Subject | Re: Cannot see the start server Icon |
Date | |
Msg-id | CA+OCxoyTmrqj=5B_romSP6Y_L12bS6KULQ4yRMUxUo7wNhKsAA@mail.gmail.com Whole thread Raw |
In response to | Re: Cannot see the start server Icon (Dave Page <dpage@pgadmin.org>) |
List | pgadmin-support |
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@dell.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@pgadmin.org] > Sent: Friday, July 08, 2011 5:19 PM > > To: Chan, Mamatha Kagathi > Cc: pgadmin-support@postgresql.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@dell.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@pgadmin.org] > Sent: Friday, July 08, 2011 5:00 PM > > To: Chan, Mamatha Kagathi > Cc: pgadmin-support@postgresql.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
pgadmin-support by date: