Re: Weird Behavior!!!

Renê Salomão wrote:
> Hi list,
>

Hi,

I am not sure I understand what you ask exactly.
It looks like you don't know why you cannot connect to 7.3

Please check:
- you stopped the postmaster for 7.3 before starting 7.2 and vise versa.
- Right now it looks like you try to connect via TCP/IP which you should
enable when you start postgres. Are you sure you editted postgresql.conf
in your 7.3 datadirectory? (propably in /usr/local/pgsq/data)

It should look something like this:

#
# Connection Parameters
#
tcpip_socket = true
#ssl = false

#max_connections = 32
#superuser_reserved_connections = 2

port = 5432
#hostname_lookup = false
#show_source_port = false

Another thing:
- Let everybody connect in your pg_hba.conf to test if your script works
anyway.

Now you have two different lines.

host all 164.35.10.0 255.255.255.0 crypt

host all all 164.35.10.0 255.255.255.0 md5

Good luck,

Regards,
Erwin

PS: One more thing: I have the same double install as you do and putted
my new postgresql-bin at the beginning of the path because I want these
(custom) scripts to execute and not the ones in /usr/bin that were
placed there by 7.2

> Me and Perl again... =3Do)
>
> I have two versions of Pg in my machine!!!! 7.2.3 & 7.3.1
>
> I have the perl code to connect to Pg, however I'm only able to connect
> to Pg 7.2.3, the error message in Pg 7.3.1 is :
>
> Pg 7.2.3: perl pg_connect.pl
>
> [pgsql(at)ibizs04 examples]$ perl pg_connect.pl=20
> Connected!!!
> 97422620003680 bompreco Lj. Cabula bompreco Lj. Cabula
> 97422620003761 bompreco Lj. FINAL 03761 bompreco Lj. FINAL 03761
> Disconnected!!!
>
> Pg 7.3.1: perl pg_connect.pl
>
> [pgsql(at)ibizs04 examples]$ perl pg_connect.pl=20
> FATAL: No pg_hba.conf entry for host 164.35.10.17, user pgsql, database
> corban DBI
> connect('dbname=3Dcorban;host=3D164.35.10.17;port=3D5432','pgsql',...) fail=
> ed:
> FATAL: No pg_hba.conf entry for host 164.35.10.17, user pgsql, database
> corban at pg_connect.pl line 16
>
> Perl Package version:
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> [pgsql(at)ibizs04]$ perl -e 'use DBI; use DBD::Pg; print "DBI:
> $DBI::VERSION, DBD::Pg $DBD::Pg::VERSION\n";'=20
>
> DBI: 1.32, DBD::Pg 1.21
>
>
> PG_CONNECT.PL
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> #!/usr/bin/perl
>
> use DBI;
> use DBD::Pg;
> use strict;
>
> my $dbh;
>
> my $dbname=3D'corban';
> 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",=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
> =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20
> "$password",=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
> =20=20=20=20=20=20=20=20=20=20=20=20
> { RaiseError =3D> 1, AutoCommit =3D> 0 }) || die
> $DBI::errstr;
>
> print "Connected!!!\n";
>
> my $hSt =3D $dbh->prepare('SELECT * FROM table Limit 2;');
>
> $hSt->execute;
>
> while(my @raD =3D $hSt->fetchrow_array()){ print
> "$raD[0]\t$raD[1]\t$raD[2]\n";}
>
> $hSt->finish;
>
> $dbh->disconnect;
>
> print "Disconnected!!!\n";
>
>
>
> [pgsql(at)corban:5432]#select version();
> -[ RECORD 1 ]--------------------------------------------------------
> version | PostgreSQL 7.3.1 on i586-pc-linux-gnu, compiled by GCC 2.96
>
> [pgsql(at)ibizs04 examples]$ /usr/local/postgresql-7.3.1/bin/psql -l
> List of databases
> Name | Owner | Encoding=20=20
> -----------+-------+-----------
> corban | pgsql | SQL_ASCII
> db | pgsql | LATIN1
> template0 | pgsql | SQL_ASCII
> template1 | pgsql | SQL_ASCII
> (4 rows)
>
> pg_hba.conf
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
>
> local all all md5
> host all all 164.35.10.0 255.255.255.0 md5
>
>
> [pgsql(at)corban:5433]#select version();
> -[ RECORD 1 ]--------------------------------------------------------
> version | PostgreSQL 7.2.3 on i586-pc-linux-gnu, compiled by GCC 2.96
>
> [pgsql(at)ibizs04 examples]$ psql -l
> List of databases
> Name | Owner=20
> -----------+-------
> corban | pgsql
> db | pgsql
> template0 | pgsql
> template1 | pgsql
> (4 rows)
>
> pg_hba.conf
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE=20
> # AUTH_ARGUMENT
> #=20
> local all crypt=20
> host all 164.35.10.0 255.255.255.0 crypt
>
> -----------------------------=20
> Ren=EA Salom=E3o
> Ibiz Tecnologia -- www.ibiz.com.br
> (011) 5579-3178 - R. 211
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)