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.
Sunday, April 13, 2008
postgresql on Ubuntu with pgAdminIII
Posted by Roman G. at 11:37 PM
Labels: eee pc, eeeXubuntu, GNU/Linux, Postgres
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment