Differences between version 8 and predecessor to the previous major change of PostgreSQL.
Other diffs: Previous Revision, Previous Author, or view the Annotated Edit History
| Newer page: | version 8 | Last edited on Tuesday, September 14, 2004 9:42:58 am | by DrewBroadley | Revert |
| Older page: | version 5 | Last edited on Thursday, June 19, 2003 5:32:19 pm | by CraigBox | Revert |
@@ -1,19 +1,8 @@
-OpenSource DataBase engine that supports most (if not all) of the ANSI SQL spec. Has support for things such as Triggers and Sub selects.
+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
+See http://www.postgresql.org for more info and PostgresVsMysql for a comparison with [MySQL].
-PostgresVsMysql
-
-!!!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.
-
-!!Upgrading from 7.2 to 7.3
-
-A couple of minor "gotchas". As above, check your pg_hba.conf file. Previously "password" authentication covered all forms of stored password. Now it is strict. If you are using md5 passwords, it MUST be md5.
-Also, in SQL-land, LIMIT used to be fairly forgiving about its arguments. It would accept MySQL format without blinking. Now it's strict - this caught me out on a basic weblog script I use which had been ported from MySQL.
-Finally, if you are a [Debian] user, don't believe the instructions in the update README!
-psql -e <dumpfile will NOT restore your database...you need to do psql template1 -e <dumpfile.
+See Also
:
+* PostgreSQLNotes
