Postgre SQL TCP/IP access FC2?

Aly Dharshi aly.dharshi at telus.net
Fri Dec 10 21:31:40 UTC 2004


Are you using mono to compile your C# proggies ?

ASD.

Eric Scott wrote:
> Scot L. Harris wrote:
> 
>> On Thu, 2004-12-09 at 23:10, Eric Scott wrote:
>>  
>>
>>> Yo;  I'm trying to learn database access in C# on my FC2 box, but 
>>> when I compile my code it get's "connection refused" from my 
>>> postgresql installation (Set up with Webmin).  I googled and found 
>>> that peeps tend to have this problem with the Npgsql C# class because 
>>> Npqsql can't access PostGreSQL through Unix sockets, only TCP/IP.
>>>
>>> Anyway, how do I enable TCP/IP connection in PostGreSQL?  All the 
>>> howto's I found didn't seem to apply to my Fedora 2 system, as 
>>> /etc/postgresql.conf doesn't exist (Yes, PostGreSQL IS installed and 
>>> activated, or at least Webmin thinks so.)
>>>           Thanx,
>>>               ES
>>>   
>>
>>
>> You need to change the options in the /var/lib/pgsql/data/pg_hba.conf
>> and /var/lib/pgsql/data/postgresql.conf files.
>>
>> You will need to restart postgresql after making the changes to permit
>> tcp/ip connections to your database.
>>
>>  
>>
> Thanx! That did it. Now I can proudly say that I accessed  a SQL 
> database with code written in C# on Linux.
>     Cheerio,
>         ES
> 

-- 
Aly Dharshi
aly.dharshi at telus.net

	 "A good speech is like a good dress
	  that's short enough to be interesting
	  and long enough to cover the subject"




More information about the fedora-list mailing list