pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problem in starting PGSQL8.1 service.
3+ messages / 3 participants
[nested] [flat]

* Problem in starting PGSQL8.1 service.
@ 2006-08-04 17:47  RPK <rohitprakash123@indiatimes.com>
  0 siblings, 2 replies; 3+ messages in thread

From: RPK @ 2006-08-04 17:47 UTC (permalink / raw)
  To: pgsql-admin


I modified one of the .CONF files located in the Postgresql\Data Folder. I
just changed the amout of shared_Buffer from 1000 to 100 and Max_Connections
from 100 to 2.

But after that the PGSQL service stopped working. It stopped listening to
the local host. I have installed PostgreSQL on my desktop stand-alone
machine (as a service).

I changed the .CONF files to their default values, but still it stopped
working. Later I had to re-install it to get things work properly.

Please let me know why it happened and how to get rid of this problem.
-- 
View this message in context: http://www.nabble.com/Problem-in-starting-PGSQL8.1-service.-tf2052505.html#a5654742
Sent from the PostgreSQL - admin forum at Nabble.com.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Problem in starting PGSQL8.1 service.
@ 2006-08-08 10:17  Kis <kjt@takarnet.hu>
  parent: RPK <rohitprakash123@indiatimes.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Kis János Tamás @ 2006-08-08 10:17 UTC (permalink / raw)
  To: pgsql-admin

2006. August 04. Friday 19.47 dátummal RPK ezt írta:
> I modified one of the .CONF files located in the Postgresql\Data
> Folder. I just changed the amout of shared_Buffer from 1000 to 100
> and Max_Connections from 100 to 2.
>
> But after that the PGSQL service stopped working. It stopped
> listening to the local host. I have installed PostgreSQL on my
> desktop stand-alone machine (as a service).
>
> I changed the .CONF files to their default values, but still it
> stopped working. Later I had to re-install it to get things work
> properly.
>
> Please let me know why it happened and how to get rid of this
> problem.

What do you see, then you run the "net start <service name>" command 
in your shell, and what is in the postgresql.log file?

bye,
kjt


McAfee SCM 4.1 által ellenőrizve!


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Problem in starting PGSQL8.1 service.
@ 2006-08-18 10:55  Magnus Hagander <mha@sollentuna.net>
  parent: RPK <rohitprakash123@indiatimes.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Magnus Hagander @ 2006-08-18 10:55 UTC (permalink / raw)
  To: RPK <rohitprakash123@indiatimes.com>; pgsql-admin

> I modified one of the .CONF files located in the Postgresql\Data
> Folder. I just changed the amout of shared_Buffer from 1000 to 100
> and Max_Connections from 100 to 2.
> 
> But after that the PGSQL service stopped working. It stopped
> listening to the local host. I have installed PostgreSQL on my
> desktop stand-alone machine (as a service).
> 
> I changed the .CONF files to their default values, but still it
> stopped working. Later I had to re-install it to get things work
> properly.
> 
> Please let me know why it happened and how to get rid of this
> problem.

You need to check your logfiles - both the ones in pg_log, and the
application eventlog. They should contain a hint about what's wrong.

//Magnus

 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-08-18 10:55 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-04 17:47 Problem in starting PGSQL8.1 service. RPK <rohitprakash123@indiatimes.com>
2006-08-08 10:17 ` Kis <kjt@takarnet.hu>
2006-08-18 10:55 ` Magnus Hagander <mha@sollentuna.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox