[HEADS UP] PostgreSQL ports split into -server & -client

Palle Girgensohn girgen at FreeBSD.org
Sun Jan 30 17:17:11 PST 2005

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:


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 


More information about the freebsd-ports mailing list