Re: Pg 7.3.1 & DBD::Pg 1.21

That's a different error than the first pg_hba.conf...

Sounds like a pgoptions.conf dilemmna -- It TCP/IP enabled ? Did you start
postgres with TCP/IP enabled ?

"Ren Salomo" <rene(at)ibiz(dot)com(dot)br> wrote in message
news:20030123165709(dot)356e2f0b(dot)rene(at)ibiz(dot)com(dot)br(dot)(dot)(dot)
> Tom lane,
> =20
> I've restarted Pg before, that's why still received the error message...
N=
> ow that I've stopped and started it again the following message
appears...=
> =20
>
> DBI
connect('dbname=3Dslave;host=3D164.35.10.17;port=3D5432','username=3Dpg=
> sql',...) failed: could not connect to server: Connection refused at
pg_con=
> nect.pl line 16
>
> Is there any compatible problem with Pg and DBD::Pg? What am I doing
wrong=
> ? =3Do)
>
> Thanks...
>
> On Thu, 23 Jan 2003 12:58:51 -0500
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> > =3D?ISO-8859-1?Q?Ren=3DEA_Salom=3DE3o?=3D <rene(at)ibiz(dot)com(dot)br> writes:
> > > I was trying to connect to Pg 7.3.1 using perl and DBD::Pg 1.21,
howev=
> er the following error occurs:=20
> > > $ perl pg_connect.pl=20
> > > FATAL: No pg_hba.conf entry for host 164.35.10.17, user pgsql,
databas=
> e slave
> >=20
> > The error message is pretty specific. Are you sure you edited the right
> > pg_hba.conf? Did you SIGHUP the postmaster after you edited it?
> >=20
> > regards, tom lane
> >=20
>
> Thanks.
> -----------------------------=20
> Ren=EA Salom=E3o
> Ibiz Tecnologia -- www.ibiz.com.br
>
>
> $ psql -l -p 5432=20=20=20=20=20=20
> List of databases
> Name | Owner=20
> -----------+-------
> slave | pgsql
> template0 | pgsql
> template1 | pgsql
> (3 rows)
>
> Vers=E3o:
> [pgsql(at)slave:5432]#select version();
> -[ RECORD 1 ]--------------------------------------------------------
> version | PostgreSQL 7.3.1 on i586-pc-linux-gnu, compiled by GCC 2.96
>
> PG_HBA.CONF:
> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
>
> local all all trust
> host all all 127.0.0.1 255.255.255.255 trust
> host all all 164.35.10.17 255.255.255.0 trust
>
> Vers=E3o:
> $ perl -e 'use DBI; print "$DBI::VERSION\n"' --> 1.32
> $ perl -e 'use DBD::Pg; print "$DBD::Pg::VERSION\n";' --> 1.21
>
>
> Fun=E7=E3o Perl:
> #!/usr/bin/perl
>
> use DBI;
> use DBD::Pg;
> use strict;
>
> my $dbh;
>
> my $dbname=3D'slave';
> my $host=3D'164.35.10.17';
> my $port=3D'5432';
> my $options=3D'';
> my $username=3D'pgsql';
> my $password=3D'pgsql';
>
> $dbh =3D DBI->connect("dbi:Pg:dbname=3D$dbname;host=3D$host;port=3D$port",
> "$username",
> "$password",
> { RaiseError =3D> 1, AutoCommit =3D> 0 }) || die $DBI::errstr;
>
> print "Connected!!!\n";
>
> my $hSt =3D $dbh->prepare('SELECT * FROM table;');
>
> $hSt->execute;
>
> while(my @raD =3D $hSt->fetchrow_array()) { print "$raD[0]\t$raD[1]\n";}
>
> $hSt->finish;
>
> $dbh->disconnect;
>
> print "Disconnected!!!\n";
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly