Monday, October 17th, 2005
PostgreSQL and MySQL can both use local sockets to handle communication between the client and the server. An indepth description of sockets can be found here, but basically they are special files that act like network connections. The difference is that instead of being available over the network, it’s only available locally. If you only use local connections, make sure you disable the network connections for increased security.
PostgreSQL’s local socket looks something like this:
srwxrwxrwx 1 postgres postgres 0 Oct 17 16:57 /tmp/.s.PGSQL.5432
And MySQL’s looks like this:
srwxrwxrwx 1 mysql daemon ...
http://raven-seo-tools.com/blog/2549/bootclean-whacked-my-sockets