Differences between version 11 and predecessor to the previous major change of PostgreSQL.
Other diffs: Previous Revision, Previous Author, or view the Annotated Edit History
| Newer page: | version 11 | Last edited on Thursday, June 2, 2005 12:59:57 pm | by AristotlePagaltzis | 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
.
+[PostgreSQL | http://www.postgresql.org] is an
OpenSource DataBase engine that supports most of the [
ANSI] [
SQL]
spec. It has
support for things such as Triggers and SubSelect~s
.
-The client psql is not as good as the mysql client but there are apparently some good Web interfaces for it.
+The client <tt>
psql</tt>
is not as good as the <tt>
mysql</tt>
client but there are apparently some good [
Web]
interfaces for it.
-See [here|http://www.postgresql.org
] for more info
-
-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
]
+*
PostgresVsMysql for a comparison with
[MySQL
]
+*
[Native psql for Windows | http:
//psql
.sourceforge
.net/
]
