Sunday, April 13, 2008

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.

No comments: