Andy Farrell wrote:
>
> REGARDING postgre install/perl interface
>
> Hello,
>
> I'm having trouble installing the perl interface to postgresql. Postgres
> seems to have installed correctly. The regression tests worked as documented
> after the install.
>
> One quirk with psql though is that if I don't specify an existing database to
> use (e.g., template1) on the command line, I get the following error:
>
> Connection to database 'postgres' failed.
> FATAL 1: Database postgres does not exist in pg_database
>
> Is the 'postgres' database suppose to be created? How was it suppose to be
> created (i.e., did initdb not work correctly)?
>
> Back to the perl problem. The make file seems to be created appropriately
> and the make works as documented. The 'make test' fails on the second test
> which attempts to connect to postgres using the 'template1' database. The
> following error is reported:
>
> not ok 2: 0, 1
> connectDB() failed: Is the postmaster running and accepting TCP/IP(with -i)
> connections at 'localhost' on port '5432'?
>
> The options in the pg_hba.conf file are:
> local all trust
> host all 199.4.254.38 255.255.255.255 trust
>
> I'm running Perl5.00403, Solaris 2.5.1 on a Sun Ultra 10 and using PostGreSQL
> v6.3.
>
> Any help would be sincerely appreciated,
> Andy
the test-script relies on the fact, that you are
using TCP/IP sockets. Starting the postmater with
-i should solve your problem.
Edmund
--
Edmund Mergl mailto:E.Mergl@bawue.de
Im Haldenhau 9 http://www.bawue.de/~mergl
70565 Stuttgart fon: +49 711 747503
Germany gsm: +49 171 2645325