Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id UAA14461 for postgres-redist; Thu, 26 Oct 1995 20:06:04 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199510270306.UAA14461@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from ns.mport.com (ns.mport.com [205.179.28.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id UAA14360 for ; Thu, 26 Oct 1995 20:06:03 -0700 Received: (from uucp@localhost) by ns.mport.com (8.7) id DAA00836; Fri, 27 Oct 1995 03:05:50 GMT Received: from adminlib/mail/surrcmd/maillog by ns.mport.com; Thu, 26 Oct 95 20:05 PDT Subject: Interfacing postgres with WWW (fwd) To: shum@cs.und.nodak.edu (Alex Shum), postgres@postgres.Berkeley.EDU Date: Thu, 26 Oct 95 15:01:43 PDT From: Bruce Korb Reply-To: bkorb@mport.com Content-Type: text/plain Message-ID: <309005490.d82@admin.mport.com> X-Mailer: ELM [version 2.3 PL11] Original-Content-Type: text/plain Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Thu, 26 Oct 95 20:06:04 -0700 Resent-XMts: smtp In Alex Shum's message: > Hi, > > Just curious if anyone has successfully written a CGI program interfacing > postgres with the web. I tried both pgtclsh and libpq and both of them > result in a server error while trying to connect to the backend. Also, > please let me know if you are able to compile pgperl5 and have it work > with WDB. Any help in this area will be very appreciated. > > Thanks. There is no magic to cgi. The http process runs as some sort of user. ("root", or "nobody", or somebody else) This user must have read and maybe write permission for the DB in question. Works fine for me (http://www.mport.com/vendors.html - everything under that grabs data from a postgres database). -- Bruce Korb | Microport, Inc. bkorb@mport.com | 108 Whispering Pines Dr. (408) 438-8649 | Scotts Valley, CA 95066 ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU". If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ============================================================================== URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/