Dear Lois,
thank you for your help.
And sorry for forgotten my "pg_hba.conf", that is really important.
Here it comes:
# Database administrative login by UNIX sockets
local all postgres ident sameuser
# TYPE DATABASE USER CIDR-ADDRESS METHOD
#host all all
# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1 255.255.255.255
trust
# IPv6 local connections:
host all all ::1/128 md5
I called this script from my home-dir under Linux. It worked allready with
PostgreSQL 7.5 but not with 8.1 and the postgre-datebase-cluster.
Gruss Christian
> Christian,
> What does your "pg_hba.conf" file look like? If you haven't made any
> changes in there, for where/who/how is allowed to connect to this
> postgreSQL db instance, it's possible that's the first place to start.
> Second, it looks like in your connect string, you haven't identified a
> host to connect to.
>
> ("DBI:Pg:dbname=test2;host=HOSTNAME;port=PORT_IF_OTHER_THAN_5432",
> "postgres"... seems correct)
>
> Those would be the first two places to check. Let me know how:
> 1) you have/have not configured the pg_hba.conf file
> 2) from where is script executing from? (remote - TCP socket -, local
> UNIX/Windows file socket)
>
> Regards,
>
--
10 GB Mailbox, 100 FreeSMS/Monat http://www.gmx.net/de/go/topmail
+++ GMX - die erste Adresse für Mail, Message, More +++
