ports/97206: [maintainer]] make mail/exilog more PostgreSQL friendly

[Larry Rosenman]

>Number:         97206
>Category:       ports
>Synopsis:       [maintainer]] make mail/exilog more PostgreSQL friendly
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          maintainer-update
>Submitter-Id:   current-users
>Arrival-Date:   Sat May 13 16:30:17 GMT 2006
>Closed-Date:
>Last-Modified:
>Originator:     Larry Rosenman
>Release:        FreeBSD 6.1-STABLE amd64
>Organization:
LERCTR Consulting
>Environment:
System: FreeBSD thebighonker.lerctr.org 6.1-STABLE FreeBSD 6.1-STABLE #54: Sat May 13 10:21:24 CDT 2006 root at thebighonker.lerctr.org:/usr/obj/usr/src/sys/THEBIGHONKER amd64


>Description:
PostgreSQL doesn't have an "OPTIMIZE TABLE" command, so we replace
that with "VACUUM ANALYZE" which does roughly the same thing.
>How-To-Repeat:
>Fix:
place the following in ports/mail/exilog/files/patch-exilog_sql.pm
--- /usr/local/www/exilog/exilog_sql.pm	Tue Feb 21 16:23:56 2006
+++ exilog_sql.pm	Wed Aug 24 09:22:29 2005
@@ -208,7 +208,7 @@
 sub _pgsql_sql_optimize {
   my $where = shift || "nothing";
 
-  my $sql = "OPTIMIZE TABLE ".$where;
+  my $sql = "VACUUM ANALYZE  ".$where;
   my $sh = $dbh->prepare($sql);
   $sh->execute;
   $sh->finish;

>Release-Note:
>Audit-Trail:
>Unformatted: