Where is located your server postgresql and client problem? If they are in different machines, so the problem is just like Abe said. By default, postgresql allows only connections from localhost. You can change that by changing your pg_hba.conf and postgresql.conf files to allow other hosts to connect.
Checkout pg_hba.conf file, which is located in your Postgresql Data folder. This file has some instructions inside it which will get you running. In your postgresql.conf file, you will need to find a line which reads: interfaces = localhost and change it to "*". This file also has explanations about it. I hope it helps. On Sat, Oct 30, 2010 at 12:44, Abe Gillespie <[email protected]> wrote: > If you're running SharpDevelop, which is Windows only, does that mean you're > running your test program from two different machines? If so then you need to > configure your DB's pg_hba.conf file. > > Sent from phone. Please excuse brevity and mistakes. > > On Oct 30, 2010, at 9:00 AM, "manfred.braun" <[email protected]> wrote: > >> Hi All ! >> >> I am just experimental working on the sample shown >> [http://www.mono-project.com/PostgreSQL] for postgres. The program compiles >> fine, this way: >> >> # gmcs -debug+ -t:exe NpgSqlTest.cs -r:System.Data -r:Npgsql >> >> but crashes with this message: >> >> # mono --debug NpgSqlTest.exe >> >> Unhandled Exception: Npgsql.NpgsqlException: >> Connection refused >> at Npgsql.NpgsqlClosedState.Open (Npgsql.NpgsqlConnector context) >> [0x00000] >> at Npgsql.NpgsqlConnector.Open () [0x00000] >> at Npgsql.NpgsqlConnectorPool.GetPooledConnector (Npgsql.NpgsqlConnection >> Connection) [0x00000] >> >> The completely unexpected thing is:If I make a project with SharpDevelop the >> program [without source changes!] compiles AND runs !!!!!!!!!!!!!!!!! It is >> NOT a "connection refused" issue [at the same time, I am connected]. >> >> Anyone any ideas, what happening here? >> >> I am just in a early beginner situation, where I expect all [simple] proggis >> to compile and run from the commandline. This looks like missing a compiler >> switch [I think, I tried them all], a defined environment or something like >> this. >> >> I am using: >> >> debian lenny, 2.6.26-2-686 >> mono 1.9.1, containing corelib 2.0 >> >> Any help would be really great! >> >> br++mabra >> >> >> _______________________________________________ >> Mono-list maillist - [email protected] >> http://lists.ximian.com/mailman/listinfo/mono-list > _______________________________________________ > Mono-list maillist - [email protected] > http://lists.ximian.com/mailman/listinfo/mono-list > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
