THE ZEPINT NETWORK

programmer assist
Web DevelopmentSecurityRIA DevelopmentOperating SystemsHardwareGraphicsDesktop DevelopmentDatabasesCommunity
Microsoft SQL MS Access Mysql Oracle PostgreSQL Sybase

PostgreSQL PostgreSQL XML Feeds

PostgreSQL Questions PostgreSQL Solutions PostgreSQL Articles

PostgreSQL is a free object-relational database server (database management system), released under the flexible BSD-style license. It offers an alternative to other open-source database systems (such as MySQL and Firebird), as well as to proprietary systems such as Oracle, Sybase, IBM's DB2 and Microsoft SQL Server.

PostgreSQL service connection problem

DiggBlinkRedditDeliciousTechnorati

question by RPK | Easy

I modified one of the .CONF files located in the PostgresqlData 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. I am using PGSQL 8.1 on Windows XP

Post reply Subscriptions

Re: PostgreSQL service connection problem

reply by Bejaan

I had something similliar happen when I upgraded to 8.01 from a release candidate. (win xp, SP2) I don't remember exactly what the problem ended up being, but I seem to remember that it was related to an incorrect path statement, or a service not being started properly or the like. I'd suggest you check all your config files and make sure any services are running properly.

Post reply Subscriptions

Re: PostgreSQL service connection problem

reply by RPK

I checked the settings of the .CONF files. The settings were same. Where it stores the PATH and OWNER PERMISSIONS?

Post reply Subscriptions

Got a PostgreSQL Question?

Just Sign Up and ask the top PostgreSQL experts!

Search via Google

User Login

Email Address

Password

PostgreSQL Experts

Rank Expert Points
#1 Support@PA 500
This a list of the Top PostgreSQL experts, how many points do you have?

Leading Experts

Rank Expert Points
#1 frankzzsword 4600
#2 Bejaan 2900
#3 csfreak 1100
#4 Anurag 700
#5 keyvez 700
#6 nnarasimha 600
#7 Nakata 600
#8 martinig 600
#9 mastercomputers 400
#10 Huntress 150
#11 Adkron 150
#12 Yogesh 100
#13 lexxwern 100
#14 Mustan Khan 100
#15 poizn 100
This is a list of overall best performing experts, how many points do you have?
Copyright © 2007 Programmer Assist. All rights reserved.
Military Global | CBSE Results | Aero India 2007 - Reports, Photographs, Videos - Exclusive Coverage