Thanks Adrian and Rich,
I will propose sqitch to the client, but I think they want something with a GUI frontend.
They want to deploy database changes, track which environments the change was deployed to, be able to rollback a change (with a rollback script), track when and if the change was rolled back and in which environment/database... so pretty much a deployment and tracking GUI software with a frontend.
In the past, for doing database deployments to Oracle, I created a tool using PHP (frontend/backend), MySQL (repository to track deployments and store deployment logs) and scripted the release scripts for deployment and rollback, and had my tool manage the scripts up the environments. The client is "looking" for something more open source for PostgreSQL. Do we have anything similar to this?
Neil