Zoltan Boszormenyi <[EMAIL PROTECTED]> writes: > Harpreet Dhaliwal írta: >> is the host base configuration methodology in postgres superior to >> other RDBMS.
> If you ask me, yes. When I had to choose between MySQL 3.x and > PostgreSQL 6.5 a long ago and I was able to exclude the DB superuser > with REVOKE CONNECT from MySQL, I said "no, thanks". > I did it on purpose to prove that you can the external configuration > is better in this case. > And apart from fixing pg_hba.conf after you move the machine, > PostgreSQL is quite location agnostic network-wise. MySQL has a related problem, which is that they have embedded IPv4 addressing rather deeply into their client authentication logic (by making userids be [EMAIL PROTECTED] not just a username). This is probably why they still haven't got IPv6 support: http://bugs.mysql.com/bug.php?id=8836 I wonder what their plans are for fixing that ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend