ONLamp: Automating PostgreSQL Tasks

"You can and should automate routine database tasks, to remove the possibility of user error and to let yourself focus on other, more interesting work. If you use PostgreSQL on Unix or Linux, you can combine the shell with PostgreSQL's psql client to automate database chores.

"If you haven't yet created your database and you believe that you will be iteratively destroying and re-creating it as the project's needs become clearer, the first chore you should automate is the creation of the database itself..."

Complete Story

Related Stories:

• ZDNet UK: PostgreSQL Goes Enterprise This Christmas(Nov 29, 2004)
• ZDNet UK: Oxford University's Computer Centre Embraces PostgreSQL(Nov 10, 2004)
• Linux Journal: Learning PostgreSQL at the Big Nerd Ranch(Oct 18, 2004)
• DevX: PostgreSQL Version 8's Transaction Savepoints Can Save Your Data(Oct 10, 2004)