PostgreSQL

From Bobs Projects
Revision as of 21:20, 5 September 2011 by Bob Edwards (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

PostgreSQL is an open-source SQL database server.

Use with Open/LibreOffice Base

PostgreSQL is a supported backend database for openoffice.org/libreoffice "base" database application. On Debian/Ubuntu Linux, install openoffice.org-sdbc-postgresql:

# apt-get install openoffice.org-sdbc-postgresql

Then start openoffice.org/libreoffice "base" and select "postgresql" as the backend database. During 2nd stage of configuration, enter:

dbname=databaseName host=databaseHost

In the third configuration screen (Authentication), enter database username and tick the password prompt box.

Finish configuration.

Then enter password to connect to PostgreSQL backend server.