I'm having what I'd have consider a strange problem with PostgreSQL and libpq. The PostgreSQL version is now 8.4.2 running under OpenBSD 4.7 I had the same problem under OpenBSD 4.3 with whatever PostgreSQL version that had. (a couple years older) My program runs something around 20-40 different queries through libpq. It all works, sometimes. Most of the time something stops, not always in the same place. Fairly often running exactly the same thing over again will work or stop in a different place. I wrote the program as CGI, mostly to let the web browser provide a user interface, but it isn't intended as an interactive program so much as a way of generating html pages that get stored and used later. The database is a local copy of the Internet Movie Database (see imdb.org/interfaces) downloaded as tarballs then loaded into a PostgreSQL database with imdbpy. It's quite large, but that's probably irrelevant. I'm running PostgreSQL with default settings in postgresql.conf and pg_hba.conf because I don't know what to set differently. Other than getting lots of "unexpected EOF on client connection" in PostgreSQL's log file there aren't any error messages. Both Apache and the PostgreSQL server are running on the same laptop. Apache isn't chrooted. Most of the time it isn't connected to anything. I put a tarball containing the program source, makefile, html calling page and sample output at: http://oldyashica.webs.com/postgresql/acorey.tar.gz Alan Corey -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
