Geography Reference
In-Depth Information
Host
The host name where the database resides. This can just be local-
host if you are running QGIS on the same machines as Post-
greSQL/PostGIS.
Database
The name of
the PostgreSQL
database
to which
you want to
connect.
Port
The port number on which the database listens. This is filled in
with the default value when you open the dialog box, and you
do not need to change it unless your database is listening on a
different port.
Username
The username used to connect to the database.
Password
The password for the database user. QGIS supports a blank pass-
word if the PostgreSQL database is configured to support trusted
connections from your machine.
Save Password
This saves the password along with the rest of the connection
information. Depending on your computing environment, this may
be a security risk. If you don't store the password, QGIS will
prompt you for it at connection time.
Only Look in the geometry_columns Table
Clicking this prevents QGIS from looking through all your tables
to see whether they contain a geometry column. This can speed
up displaying the list of layers to choose from if you always have
an entry in geometry_columns for every spatial layer.
Only Look in the 'public' Schema
This constrains QGIS to only look in the public schema when
searching for spatially enabled tables.
In Figure 7.3 , on the previous page, we are running QGIS on the same
machine as the database, so we specified “localhost.” Our database
is named “gis_data,” and we are using the standard PostgreSQL port.
Once you have filled in the connection information, you can use the
Test Connect button to test the connection. If it fails, check the param-
eters again. If they are correct, you may have to check the PostgreSQL
 
Search WWH ::




Custom Search