[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:
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
More information about the freebsd-ports
mailing list