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 12:07:49 |
Message-ID: | CA+OCxoyTmrqj=5B_romSP6Y_L12bS6KULQ4yRMUxUo7wNhKsAA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2011-07-08 12:28:35 | Re: Cannot see the start server Icon |
Previous Message | Mamatha_Kagathi_Chan | 2011-07-08 12:04:30 | Re: Cannot see the start server Icon |