View Source: PostgreSQL - Waikato Linux Users Group

You are viewing an old revision of this page. View the current version.

OpenSource database engine that supports most (if not all) of the ANSI SQL spec. Has support for things such as Triggers and Sub selects.

The client psql is not as good as the mysql client but there are apparently some good Web interfaces for it.

See [here|http://www.postgresql.org] for more info


!!!Postgres hints:
!!IDENT authentication failed for user

Postgresql under [Debian] by default uses [IDENT] authentication to authenticate a user connecting to the database.  In english this means that you can only connect to the database with the same username as your unix login.  This can be edited in /etc/postgres/pg_hba.conf (Host Based Authentication) by changing "ident sameuser" with "trust" to let anyone connect to the database with any username without a password, or "crypt" etc..  The file is well commented, refer to it for more details.

15 pages link to PostgreSQL:

Version 2, saved on Monday, October 7, 2002 10:38:02 pm by PerryLorier

Edit PageHistory Diff Info LikePages