In a message written on Thu, Oct 21, 2010 at 01:53:49PM -0700, Christopher McCrory wrote:
open to the world. After a few google searches, it seems that PostgreSQL is in a similar situation.
I don't know when PostgreSQL first supported IPv6, but it works just fine. I just fired up a stock FreeBSD 8.1 system and built the Postgres 8.4 port with no changes, and viola: postgresql# netstat -a Active Internet connections (including servers) Proto Recv-Q Send-Q Local Address Foreign Address (state) tcp4 0 0 localhost.postgresql *.* LISTEN tcp6 0 0 localhost.postgresql *.* LISTEN $ psql -h ::1 psql (8.4.4) Type "help" for help. pgsql=# \l List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------+-------+----------+-----------+-------+------------------- pgsql | pgsql | UTF8 | C | C | postgres | pgsql | UTF8 | C | C | template0 | pgsql | UTF8 | C | C | =c/pgsql : pgsql=CTc/pgsql template1 | pgsql | UTF8 | C | C | =c/pgsql : pgsql=CTc/pgsql (4 rows) ~pgsql/data/pg_hba.conf contains: # CIDR-ADDRESS specifies the set of hosts the record matches. # It is made up of an IP address and a CIDR mask that is an integer # (between 0 and 32 (IPv4) or 128 (IPv6) inclusive) that specifies # the number of significant bits in the mask. Alternatively, you can write # an IP address and netmask in separate columns to specify the set of hosts. And later: # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust So of your "LAMP" stack, I'm pretty sure all the L's are in good shape (Linux/FreeBSD/NetBSD/etc), the A is in good shape, been working fine for years. Perhaps the M needs some work on the MySQL side, but I'm fairly sure PostgreSQL is solid. I'm not exactly sure how the P would need IPv6 support, but I think it's generally a non-issue there other than updating software that acutally stores IPv4 addresses... -- Leo Bicknell - bicknell@ufp.org - CCIE 3440 PGP keys at http://www.ufp.org/~bicknell/