RE: postgres perl DBI - Mailing list pgsql-general

From Fetter, David M
Subject RE: postgres perl DBI
Date
Msg-id B1F9E0D87882D21182F8006094519AD804D6D8A5@mwabs021.emeryworld.com
Whole thread Raw
In response to postgres perl DBI  ("Fetter, David M" <Fetter.David@emeryworld.com>)
List pgsql-general
Silly me, I didn't even notice the mwabs504/505 difference.  I had my
.profile setup for another machine.  It compiled fine now.  Thanks.


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, July 31, 2000 6:30 PM
To: Fetter, David M
Cc: PostgreSQL-General (E-mail)
Subject: Re: [GENERAL] postgres perl DBI


"Fetter, David M" <Fetter.David@emeryworld.com> writes:
> DBI->connect(dbname=template1) failed: PQconnectPoll() -- connect()
failed:
> Connection refused
>         Is the postmaster running (with -i) at 'mwabs504'
>         and accepting connections on TCP/IP port '5432'?
>  at test.pl line 59

"Connection refused" at this stage generally means that the connect
request never got as far as the postmaster.  Are you sure you are
connecting to the right machine?  Your script

> [~/DBD-Pg-0.95] dmfetter@mwabs505! ps -ef|grep post
> dmfetter 24865 24254  0 21:35:38 pts/5    0:00 grep post
> postgres 23964     1  0 17:31:28 ?        0:00
> /usr/local/postgres/bin/postmaster -S -i

suggests you are on mwabs505 not mwabs504.

            regards, tom lane

pgsql-general by date:

Previous
From: abe
Date:
Subject: Someone Needed!!
Next
From: Tom Lane
Date:
Subject: random() function produces wrong range