Date: Sat, 13 May 2006 11:27:17 -0500 From: Larry Rosenman <ler@lerctr.org> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/97206: [maintainer]] make mail/exilog more PostgreSQL friendly Message-ID: <E1FewxZ-0001FE-25@thebighonker.lerctr.org> Resent-Message-ID: <200605131630.k4DGUHAu094643@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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@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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?E1FewxZ-0001FE-25>