Postgre SQL TCP/IP access FC2?

Eric Scott scottclansman at cwazy.co.uk
Fri Dec 10 20:53:33 UTC 2004


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




More information about the fedora-list mailing list