postgresql on Ubuntu with pgAdminIII

On my eeeXubuntu Gutsy pgAdmin fails when processing schema on some joins, if use 8.3 version.

Thats way I have downgraded to postgresql 8.2 .
(removed all 8.3 packages, and installed 8.2 version)

# sudo apt-get install postgresql-8.2

than initialized db on already prepared space on flash card:
from postgres user:

# /usr/lib/postgresql/8.2/bin/initdb -D /media/disk/pg_db/

For convinience I have added /usr/lib/postgresql/8.2/bin/ in PATH
and started in the directory

# pg_ctl -D /media/disk/pg_db -l /media/disk/pg_db_1.log start

than Applications->System->pgAdmin III

push connect button, and insert connection parameters as shown.

than doubleclick on server , and walk pg tree.

how to stop postgres on ubuntu Linux

After been installed, postgres started automatically.

you can look on command line used to start it

$ ps -ef | grep post
postgres 12089     1  0 10:38 ?        
00:00:00 /usr/lib/postgresql/8.3/bin/postgres 
-D /var/lib/postgresql/8.3/main 
-c config_file=/etc/postgresql/8.3/main/postgresql.conf
...other postgres processes...

it can not be stopped by not owner or sudo:

~$ sudo /usr/lib/postgresql/8.3/bin/pg_ctl stop 
/var/lib/postgresql/8.3/main/
[sudo] password for rtg:
pg_ctl: cannot be run as root
Please log in (using, e.g., "su") as the (unprivileged) user that will
own the server process.
$ /etc/init.d/postgresql-8.3 stop
* Stopping PostgreSQL 8.3 database server                                                         * Error: You must run this program as the cluster owner (postgres)
          [fail]

To stop, set postgres password first.

It is unknown at the beginning.

rtg@deeeb:~$ su postgres
Password: 
su: Authentication failure
Sorry.

to set it:

sudo passwd postgres

set password;
then login ,

su postres
put your password you set before

and stop it,OK:

$ /usr/lib/postgresql/8.3/bin/pg_ctl stop 
-D /var/lib/postgresql/8.3/main/
waiting for server to shut down.... done
server stopped

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).