Обсуждение:
hello just want to ask why i can't connect to postgresql for cygwin using php? postgresql just closes when the connection is started. i followed all the instructions except that i started postmaster using: pg_ctl start -o "-i". and i also started ipc-daemon using: ipc-daemon &. my machine is a win98 (first edition) having CPU of 500Mhz network card of Realtek 8029as and memory of 128 MB. I think my cygwin version is the latest. here are the version of the required files: - postgresql-7.1.1-1.tar.gz - crypt-1.0-1.tar.gz (is this alright?) - readline-4.1-2.tar.gz - zlib-1.1.3-6.tar.gz - cygwin-1.3.1-1.tar.gz here's the error in php: Warning: Unable to connect to PostgresSQL server: pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. in /home/sgp/www/index_from.php on line 16 here's the error in cygwin: ' FATAL 1: Bad abstime external representation '\N You're respons will be much appreciated. Thank you very much.
shem,
On Fri, May 18, 2001 at 02:49:10PM +0800, shem wrote:
> hello just want to ask why i can't connect to postgresql for cygwin using
> php?
> postgresql just closes when the connection is started.
> i followed all the instructions except that i started postmaster using:
> pg_ctl start -o "-i".
> and i also started ipc-daemon using: ipc-daemon &.
> my machine is a win98 (first edition) having CPU of 500Mhz network card of
> Realtek 8029as and memory of 128 MB.
> I think my cygwin version is the latest.
> here are the version of the required files:
> - postgresql-7.1.1-1.tar.gz
> - crypt-1.0-1.tar.gz (is this alright?)
> - readline-4.1-2.tar.gz
> - zlib-1.1.3-6.tar.gz
> - cygwin-1.3.1-1.tar.gz
>
> here's the error in php:
> Warning: Unable to connect to PostgresSQL server: pqReadData() -- backend
> closed the channel unexpectedly. This probably means the backend terminated
> abnormally before or while processing the request. in
> /home/sgp/www/index_from.php on line 16
Try connecting with psql, as in the following:
$ psql -h localhost template1
Do you get the same error?
> here's the error in cygwin:
> ' FATAL 1: Bad abstime external representation '\N
Sorry, I'm not sure what to make of the above.
Jason
--
Jason Tishler
Director, Software Engineering Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp. Fax: +1 (732) 264-8798
82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA WWW: http://www.dothill.com
shem,
On Mon, May 21, 2001 at 12:33:04PM +0800, shem wrote:
> > Try connecting with psql, as in the following:
> >
> > $ psql -h localhost template1
> >
> > Do you get the same error?
>
> i didn't have any errors when i did that when i'm at cygwin, BUT when i
> tried it on a linux box (from another machine) it those errors.
>
> This is the error in linux:
> i typed (just an example):
> $ psql -h acomputer -u
> user: user
> password: ******
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
>
> The error in cygwin is the same as below.
The above seems to indicate that you need to edit your pg_hba.conf file
to enable php (i.e., non-local) access.
> Thank you for you're answers!
You're welcome.
> - just another question, is this a mailing list? if so how do i subscribe
> without using the web (email only)?
See the following for instructions:
http://postgresql.readysetnet.com/users-lounge/subunsub.html
In the future, please post to pgsql-cygwin@postgresql.org instead of
sending private email so other can benefit too.
Thanks,
Jason
--
Jason Tishler
Director, Software Engineering Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp. Fax: +1 (732) 264-8798
82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA WWW: http://www.dothill.com