ipv6 vs. LAMP

Thu Oct 21 21:43:54 UTC 2010

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 at ufp.org - CCIE 3440
        PGP keys at http://www.ufp.org/~bicknell/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 826 bytes
Desc: not available
URL: <http://mailman.nanog.org/pipermail/nanog/attachments/20101021/60f88a7c/attachment.sig>