From owner-freebsd-ports@FreeBSD.ORG Mon Jan 31 01:17:11 2005 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4AB1216A4CE for ; Mon, 31 Jan 2005 01:17:11 +0000 (GMT) Received: from melon.pingpong.net (82.milagro.bahnhof.net [195.178.168.82]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8E86243D3F for ; Mon, 31 Jan 2005 01:17:10 +0000 (GMT) (envelope-from girgen@FreeBSD.org) Received: from localhost (localhost.pingpong.net [127.0.0.1]) by melon.pingpong.net (Postfix) with ESMTP id 42AC44AC28 for ; Mon, 31 Jan 2005 02:17:09 +0100 (CET) Received: from melon.pingpong.net ([127.0.0.1]) by localhost (melon.pingpong.net [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 19601-04-11 for ; Mon, 31 Jan 2005 02:17:09 +0100 (CET) Received: from palle.girgensohn.se (1-2-8-5a.asp.sth.bostream.se [82.182.157.66]) by melon.pingpong.net (Postfix) with ESMTP id 121584AC3D for ; Mon, 31 Jan 2005 02:17:09 +0100 (CET) Date: Mon, 31 Jan 2005 02:17:08 +0100 From: Palle Girgensohn To: ports@freebsd.org Message-ID: X-Mailer: Mulberry/3.1.6 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at pingpong.net Subject: [HEADS UP] PostgreSQL ports split into -server & -client X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 31 Jan 2005 01:17:11 -0000 Welcome the PostgreSQL New Order! Big changes have been made to the PostgreSQL ports. The ports are all split into -server & -client parts. Hence, you can select a client only install on machines that don't run a database server locally. If you want to upgrade your postgresql7 installation to the New Order, you may run portupgrade -O databases/postgresql74-server postgresql7 Please note, though, that while this will upgrade your ports database, the installation of postgresql74-server + postgresql74-client will be almost identical to an installation of the previous postgresql7 port, except for the following: The PostgreSQL ports now support rc.subr, so to start the PostgreSQL server at boot time, add the following to /etc/rc.conf: postgresql_enable=yes There is a maintainance script installed in ${LOCALBASE}/etc/periodic/daily, and it can be controlled by a set of new knobs that can be set in periodic.conf. Use it for vacuuming your databases and get daily backups. Note that daily vacuuming is on by default. See the script for details. There is also a knob in Mk/bsd.ports.mk, `USE_PGSQL=yes', that porter's shall use when their port depends on PostgreSQL. Also, welcome PostgreSQL 8.0, which can now be installed from databases/postgresql80-(server|client). Cheers, Palle