Home, home on the Ra..

Our server move is done, and Rdbhost.com now runs on a later version of PostgreSQL, a later OS version, and is on a new server company. We were looking to upgrade the software versions, and Slicehost announced their planned termination, so off we went.

The new server hosting is with Rackspace. They seem to have a good reputation, so hopefully this will work out for us.

Rdbhost.com now runs on PostgreSQL 9.0.4. This is an upgrade from 8.3, and provides us some useful new features.

We have, in the past, setup roles as an automated website operation, but had to handoff permission setting to the user, requiring you to use SQL to set permissions for each table, index, or other resource, for each role. PostgreSQL 9.0 supports setting permissions globally (within the schema) for a given role, and permits setting default permissions for resources not yet created. For now, that is useful to you in manually setting privileges, but we will be providing an automated setup to set permissions broadly for each role.

Rdbadmin has been upgraded to accommodate system table changes in the PostgreSQL upgrade.

David

Comments are welcome.