Re: [GENERAL] Unable to connect to Postgresql

Поиск
Список
Период
Сортировка
От John Iliffe
Тема Re: [GENERAL] Unable to connect to Postgresql
Дата
Msg-id 201704092009.08111.john.iliffe@iliffe.ca
обсуждение исходный текст
Ответ на Re: [GENERAL] Unable to connect to Postgresql  (rob stone <floriparob@gmail.com>)
Ответы Re: [GENERAL] Unable to connect to Postgresql  (rob stone <floriparob@gmail.com>)
Список pgsql-general
On Sunday 09 April 2017 17:39:30 rob stone wrote:
> Hello John,
>
> > >
> > >
> > > > PHP and Postgresql are both running on same box.  It does have
> >
> > two
> >
> > > > interfaces, 192.168.1.6 and 192.168.1.7, and the test programme
> >
> > is
> >
> > > > available on either.  The reference to 192.168.1.10 is the client
> > > > machine, in this case my workstation, which is 192.168.1.10.
> > >
> > >
> > >
> > > Here is the error message you said came from the box running PHP:
> > > >> > ------------------------------------------
> > > >> > [Sun Apr 09 14:08:16.178126 2017] [php7:warn] [pid 24917:tid
> > > >> > 139671464015616] [client 192.168.1.10:59260] PHP Warning:
> > > >> > pg_connect(): Unable to connect to PostgreSQL server: could
> >
> > not
> >
> > > >> > connect to server: Connection refused\n\tIs the server running
> >
> > on
> >
> > > >> > host "192.168.1.6" and accepting\n\tTCP/IP
> >
> > connections on
> >
> > > >> > port 5432? in
> > > >> > /httpd/iliffe/testfcgi.php on line 132
> > > >> > -------------------------------------------
> > >
> > >
>
> This is a tad confusing to me.
>
> You have Apache, PHP, and Postgres all running on your LAN at
> 192.168.1.6.
>
>
> You are on 192.168.1.10.
>
> Your NOT doing "php -f testfcgi.php", so how does Apache "know" to run
> that script?

testfcgi.php is in the document root of the default named virtual server.
>
> Cheers,
> Rob


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Unable to connect to Postgresql
Следующее
От: John Iliffe
Дата:
Сообщение: Re: [GENERAL] Unable to connect to Postgresql