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