TurnKey PostgreSQL Live CD is an open source distribution of Linux designed from the ground up to provides users with an easy-to-use method for deploying dedicated servers with the PostgreSQL database. It is based on the well known Debian GNU/Linux operating system.
PostgreSQL is an open source, fully-featured and object-relational database system that features ACID transactions, Unicode support, views, foreign keys, outer joins, triggers, and sequences. This TurnKey appliance contains all the necessary components for installing and deploying a working PostgreSQL server.
The PostgreSQL package provided has been configured to listen on port 5432/TCP for all network interfaces and accepts connections from all hosts. In addition, the phpPgAdmin software is installed by default for easy administration of the PostgreSQL databases.
Among other features, we can mention support for PostGIS spatial and geographic objects system, encrypted passwords, as well as various Webmin modules for configuring PostgreSQL, Apache and PHP.
While the default username for the Webmin and SSH components is root, the default username for PostgreSQL and phpPPgAdmin is postgres. Keep in mind that the 'postgres' user is trusted when connecting over local UNIX sockets.
The project is distributed as Live CD ISO images that can be burned to CD discs or written to USB flash drives. In addition, virtual images for Xen, OpenVZ, OpenStack, OVF and OpenNode are provided on the project's homepage.
From the boot prompt for the Live CDs, users will be able to install the appliance on a local disk drive, as well as to try it without installing anything on their computers (demo mode). The text-mode installation requires users to only partition the disk and install the bootloader.
During the first boot configuration process, it is possible to enter a password for the root (system administrator) account, as well as for the 'postgres' account. Optionally, you can enable the TurnKey hub services (Domain Management, Dynamic DNS, Backup and Migration).
What is new in this release:
- Updated PostgreSQL to latest Debian Stretch package.
- Install Adminer directly from stretch/main repo
- Note: Please refer to turnkey-core's changelog for changes common to all appliances. Here we only describe changes specific to this appliance.
What is new in version 13.0:
- PostgreSQL:
- Latest Debian Wheezy package version of PostgreSQL.
- Bugfix for package transition [#80].
- Removed hardcoded PGSQL version [#107], thanks Jenny Qian!
What is new in version 11.3-lucid-x86:
- 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
What is new in version 11.2-lucid-x86:
- 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
What is new in version 2009.02-hardy-x86:
- Rebuilt on top of TurnKey Core, the new common base for all software appliances, which is assembled from Ubuntu 8.04.2 LTS packages.
- A bugfix in the daily auto-updates mechanism. Significant usability and security enhancements: confconsole support for systems with multiple NICs, password-free login in demo mode, SSL support, database password setting during installation, no passwords in demo mode, many generically useful Webmin modules, and improved embedded documentation.
Comments not found