TurnKey Linux Virtual Appliance Library

New TurnKey PostgreSQL version (13.0)

Mon, 2013/10/28 - 21:17

Changes:

  • PostgreSQL:
    • Latest Debian Wheezy package version of PostgreSQL.
    • Bugfix for package transition [#80].
    • Removed hardcoded PGSQL version [#107], thanks Jenny Qian!
  • Note: Please refer to turnkey-core's changelog for changes common to all appliances. Here we only describe changes specific to this appliance.

Links

New TurnKey PostgreSQL version (12.1)

Thu, 2013/06/06 - 15:59

Changes:

  • Latest Debian Squeeze package version of PostgreSQL.
  • Note: Please refer to turnkey-core's changelog for changes common to all appliances. Here we only describe changes specific to this appliance.

Links

New TurnKey PostgreSQL version (12.0)

Thu, 2012/08/30 - 09:25

Changes:

  • PostgreSQL:
    • Reduced default shared_buffers to 24MB, as default Debian kernel SHMMAX is too low for the default 32MB. Increase per deployment: - /proc/sys/kernel/shmmax - /etc/postgres/8.4/main/postgresql.conf (shared_buffers)

Major component versions

lighttpd 1.4.28-2+squeeze1
postgresql 8.4.12-0squeeze1
phppgadmin 4.2.3-1.1squeeze2

Note: Please refer to turnkey-core's changelog for changes common to all appliances. Here we only describe changes specific to this appliance.

Links

New TurnKey PostgreSQL version (11.3)

Tue, 2011/12/06 - 09:18

Changes:

  • Installed security updates.
  • Enabled etckeeper garbage collection by default.
  • Upgraded to latest inithooks version (adhoc re-initialization via turnkey-init)
  • VMWare build: run vmware-config-tools.pl on first boot
  • Amazon EC2 EBS build: support resizing of root filesystem

Links

New TurnKey PostgreSQL version (11.2)

Tue, 2011/08/02 - 10:29

Changes:

  • Built-in support for TurnKey domain management and dynamic DNS configuration, powered by Amazon Route 53, a robust cloud DNS service: http://www.turnkeylinux.org/dns
  • Pre-installed all available security updates (see manifest for package versions)

Links

New TurnKey PostgreSQL version (11.1)

Thu, 2011/01/27 - 13:15

Changes:

  • Set PostgreSQL password is on firstboot (convenience, security).
  • Force PostgreSQL to use Unicode/UTF8.

Major component versions

phppgadmin 4.2.2-1ubuntu1
postgresql 8.4.5-0ubuntu10.04
lighttpd 1.4.26-1.1ubuntu3

Note: Please refer to turnkey-core's changelog for changes common to all appliances. Here we only describe changes specific to this appliance.

Links

New TurnKey PostgreSQL version (2009.10-2)

Wed, 2010/04/14 - 08:15

Changes:

  • Installed all security updates (see manifest for package versions).
  • Install security updates on firstboot (except when running live).
  • Bugfix: Updated apt preferences for auto-security updates (LP#550307).
  • Trick webmin into not checking for upgrades (managed by apt).
  • Included latest version of inithooks and updated scripts.
  • Included wget as per common request.

Links

New TurnKey Postgresql version (2009.10)

Fri, 2009/10/23 - 15:35

Changes:

  • di-live (installer) PostgreSQL component:
    • Added support for complex passwords (LP#416515).
    • Added CLI options (user/pass/query/chroot).
  • Pinned PHPPgAdmin to update directly from Debian (security).
  • Regenerates all secrets during installation / firstboot (security).

Major component versions

phppgadmin 4.2.2-1
postgresql 8.3.8-0ubuntu8.04
lighttpd 1.4.19-0ubuntu3.1

Note: Please refer to turnkey-core's changelog for changes common to all appliances. Here we only describe changes specific to this appliance.

Links

New TurnKey PostgreSQL version (2009.02-hardy)

Sat, 2009/02/28 - 18:08

Release focus: security, usability, bugfixes and updates

Changes:

  • support configuring postgresql password during installation
  • postgres password encryption enabled by default (security)
  • trust "postgres" user when connecting over local unix sockets (convenience)
  • set postgres password to "postgres" in live/demo mode
  • updated confconsole usage template to describe connecting with psql client
  • added postgis support
  • including webmin-postgresql

Major component versions

kernel 2.6.24-23.48
phppgadmin 4.2.2-1
postgresql 8.3.5-0ubuntu0.8.04
lighttpd 1.4.19-0ubuntu3

Note: please refer to turnkey-core's changelog for changes common to all appliances. Here we only describe changes specific to this appliance.

Links

New TurnKey PostgreSQL appliance (2008.12.04-hardy)

Thu, 2008/12/04 - 17: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