From owner-freebsd-questions@FreeBSD.ORG  Tue Jun  3 05:02:59 2003
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id AECB737B401
	for <freebsd-questions@freebsd.org>;
	Tue,  3 Jun 2003 05:02:59 -0700 (PDT)
Received: from perimeter.co.za (obelix.perimeter.co.za [209.212.102.154])
	by mx1.FreeBSD.org (Postfix) with ESMTP id E60D343F3F
	for <freebsd-questions@freebsd.org>;
	Tue,  3 Jun 2003 05:02:56 -0700 (PDT)
	(envelope-from bsd@perimeter.co.za)
Received: from localhost (localhost [127.0.0.1])
  (uid 9999)
  by perimeter.co.za with local; Tue, 03 Jun 2003 14:02:52 +0200
From: bsd@perimeter.co.za
To: "FreeBSD Question List" <freebsd-questions@freebsd.org>
Date: Tue, 03 Jun 2003 14:02:51 +0200
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-ID: <courier.3EDC8E6C.0001865F@perimeter.co.za>
Subject: Apache - mod_perl - PostgreSQL
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 03 Jun 2003 12:03:00 -0000

Hi all! 

I did the portupgrade of postgresql 7.3.2 -> 7.3.3 this morning.  Since then 
my mod_perl web pages will not talk to the databases..... 

It's wierd: 

1) postmaster is running, and I can manually psql and see the conent of the 
databases OK. 

2) Apache is running, and mod_perl is still good because the rest of the 
perl-generated page comes up fine. 

3) I can't track down any error messages in the apache logs. 

The SQL queries from perl just return empty results from the databases!  
When I manually run the identical query in psql it returns the correct 
results. 

Has anyone else had anything funny like this happen recently? 

Regards,
Patrick.