Backup of the PostgreSQL Database

At the end of the project I had to set up a simple but reliable backup for the PostgreSQL database. If you have some interest, I did describe the environment in a previous article "Ubuntu Server as Inexpensive Platform for J2EE". Here I describe the backup on that platform. With less changes the scripts works also on other UNIXes. The principle may be also used on MS Windows, but the implementation will be different.

Inexpensive Development Platform for J2EE

Once the server is ready (see my previous article) I need a similar inexpensive development environment. Inexpensive it's OK but uncomfortable would be bad. I have two different choices: the first is to create a small development corner on my office workstation. The second would be to buy a a net-book and use it as dedicated appliance.

The first option has the advantage of a powerful hardware and a large screen. The net-book is small and may be used everywhere. I decided to investigate both environments because the first is suitable for developing a new project or a major release and the second seems to be suitable for support and small changes.

Key-Based SSH Logins

I did found a lot of pages with good explanation of the theory and / or how to setup client and server and I don't want to write another one. The motivation of this article is only to have a concise check list to use with "copy & paste" when I have to set up a such login.