Thanks!
It ended up being the pg_hba.conf configured for ident
sameuser instead of
trust.
Kevin
-----Original Message-----
From: Jeroen T. Vermeulen [mailto:jtv xs4all.nl]
Sent: Friday, February 16, 2007 3:46 AM
To: Kevin Lambert
Cc: libpqxx-generalgborg.postgresql.org
Subject: Re: [libpqxx-general] pqxx::broken_connection error
when connecting
to database
On Fri, February 16, 2007 01:46, Kevin Lambert wrote:
> On two separate systems I have identical databases
named "kevin" (no
> quotes)
> with postgres installed and libpqxx installed. On both
systems if I
> log in as the postgres user I can run "psql"
and explore both
> databases and all of
> my information is present. On my development box if I
run my application
> which uses libpqxx it connects into the database and is
able to retrieve
> and
> update data but if I run the same exact application on
my target box
> (which
> also has FC6 installed) I end up getting
"broken_connect" exceptions every
> time I try to connect in. I have verified the database
and user both
> exist
> through psql and just can't figure out what else is
going wrong to not let
> me connect.
What error message are you getting with your exception? Is
the server
logging anything? The two setups may simply have different
authentication
configurations in pg_hba.conf.
Jeroen
_______________________________________________
Libpqxx-general mailing list
Libpqxx-generalgborg.postgresql.org
http://gborg.postgresql.org/mailman/listinfo/libpqxx
-general
|