started postgres investigation: pgAdmin

Discovered, that on my Kubuntu Gutsy postgres already present from the box.

However pgAdmin have no idea, on what servers are present, and asks for specifying properties.

$ ps -ef | grep post
postgres  5487     1  0 15:03 ?        00:00:00 /usr/lib/postgresql/8.2/bin/postgres -D /var/lib/postgresql/8.2/main -c config_file=/etc/postgresql/8.2/main/postgresql.conf
postgres  5514  5487  0 15:03 ?        00:00:00 postgres: writer process
postgres  5515  5487  0 15:03 ?        00:00:00 postgres: stats collector process
rtg      11325  6341  0 19:11 pts/0    00:00:00 grep post

Setting up localhost with defaults haven't helped.
pgAdmin3 includes nice html tutorial, attached to it's help.

Started reading it.

First nice feature I have seen after first look is perl integration.

Idea of having regular expressions in the names of fields and tables, looks nice, especially for specific tables, that can present on data processing servers.

It looks much more compact, and though much more robust then dynamic sql in sybase for example.
(If keep an idea that density of errors for page is constant for developer).