Re:

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(dot)Tishler(at)dothill(dot)com
Hazlet, NJ 07730 USA WWW: http://www.dothill.com