Upgrading PostgreSQL

This is an old procedure, which is commonly understood by PostgreSQL administrators. However, if you’ve not done it before, over at the FreeBSD Diary there is a nice article describing how to upgrade the client and the server when moving from one version to the next (such as from 8.3.x to 8.4.x).

The basic thing to remember is that a complete dump of the databases is necessary, with the appropriate reload process. The article describes this process well.

Anybody who is interested in FreeBSD should follow the FreeBSD Diary; this “blog” has been around longer than blogs have been.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: