[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Postgre SQL TCP/IP access FC2?

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.)

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.

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]