Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 31 Jan 2005 02:17:08 +0100
From:      Palle Girgensohn <girgen@FreeBSD.org>
To:        ports@freebsd.org
Subject:   [HEADS UP] PostgreSQL ports split into -server & -client
Message-ID:  <E200B81EA7454A9AFA88A1CF@palle.girgensohn.se>

next in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?E200B81EA7454A9AFA88A1CF>