[Qgis-user] SPIT not seeing PostGres SQL Connections

[Agustin Lobo]

Hi!

I've followed (not without pain, see at the end) the example
of creating a PostGIS database in G.Sherman book
p. 113-121 on ubuntu 10.04.
Thus, I have created a database named geospatial_desktop.
Nevertheless, when I try to use SPIT to load the data,
geospatial_desktop is not listed (actually nothing is listed)
in the PostgSQL connections list.
Is there any place where I have to tell QGIS the path
of the databases?

Problems I mentioned:
1. createdb -E UTF8 geospatial_desktop
resulted into
ident authentication failed for user "alobo"
which was solved by modifying /etc/postgresql/8.4/main/pg_hba.conf
according to
http://stackoverflow.com/questions/2942485/psql-fatal-ident-authentication-failed-for-user-postgres

2. The same command produced a second error:
createdb: could not connect to database postgres: FATAL: role  "alobo"
does not exist

This was solved by running the commands preceded by sudo -i -u postgres, i.e.

sudo -i -u postgres createdb -E UTF8 geospatial_desktop

as mentioned in
http://ubuntuforums.org/showthread.php?t=1515069

(actually, is it "normal" having to su to user postgres for using postgres?)

Agus