Обсуждение:
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