TurnKey Linux Virtual Appliance Library

New TurnKey PostgreSQL appliance (2008.12.04-hardy)

Thu, 2008/12/04 - 18:52

Notes

  • PostgreSQL is configured to listen on port 5432 TCP on all interfaces by default
  • Host and user access should be configured in /etc/postgresql/8.3/main/pg_hba.conf
  • Exemplary firewall configuration has been setup, but not enabled.
  • PHPPgAdmin is configured to force SSL connections
    • To use your own SSL certificate, replace /etc/lighttpd/server.pem
  • This release includes all updates included in the 2008.10.17-hardy-x86 releases, such as the new configuration console, and web management interface, as well as several important bugfixes such as LP#301251 and LP#303498

Default credentials (service, username, password)

console, webmin, ssh root <blank>
postgresql / phppgadmin postgres postgres

Major component versions

kernel 2.6.24-22.45
lighttpd 1.4.19-0ubuntu3
postgresql 8.3.5-0ubuntu0.8.04
postgresql-contrib 8.3.5-0ubuntu0.8.04
phppgadmin 4.1.3-0.1
iptables 1.3.80debian1-1ubuntu2

Links