Differences between version 2 and predecessor to the previous major change of PostgreSQL.
Other diffs: Previous Revision, Previous Author, or view the Annotated Edit History
Newer page: | version 2 | Last edited on Monday, October 7, 2002 10:38:02 pm | by PerryLorier | Revert |
Older page: | version 1 | Last edited on Thursday, August 1, 2002 12:21:21 am | by MattBrown | Revert |
@@ -2,4 +2,10 @@
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.