TurnKey (http://www.turnkeylinux.org/)
providing easy way to get a PostgreSQL instance up and running on your server
or VM (VMware, VirtualBox, Xen, KVM) of choice in just a couple of minutes. It
is designed to provide users with a pre-integrated, turn-key operating system
environment that is carefully built from the ground up with the minimum
components needed to run PostgreSQL with maximum usability, efficiency, and
security.
Feature highlights
- SSL support out of the box
- PHPPgAdmin administration front-end for PostgreSQL
- auto-updated daily with the latest security patches
- easy to use configuration console and web management interface
- minimal footprint - includes only minimum components needed
- packaged as installable Live CD that runs on real machines and most types of virtual machines (e.g., VMWare, VirtualBox)
- based on Ubuntu 8.04.2 Hardy LTS
- PostGIS support
1. Download “Open Virtualization Format(OVF)” from TURNKEY site
Unzip the downloaded file
2. Import the turnkey ovf file from Oracle VM VirtualBox. If you don’t have Oracle VM VirtualBox then you can download from Oracle site
Select File menu and select "Import Apliance.."
Select downloaded turnkey ovf (Open Visualization Format) file
3. I got following error when I try to import , it might be the issue because of virtual box configuration or virtual box unsupported ( My version 4.2.0 r80737)
Error when importing
Failed to import appliance E:\Software\postgresql\turnkey-postgresql-12.1-squeeze-amd64\turnkey-postgresql-12.1-squeeze-amd64.ovf.
Error reading "E:\Software\postgresql\turnkey-postgresql-12.1-squeeze-amd64\turnkey-postgresql-12.1-squeeze-amd64.ovf": unknown element "Config" under Item element, line 47.
Result Code: VBOX_E_FILE_ERROR (0x80BB0004)
Component: Appliance
Interface: IAppliance {3059cf9e-25c7-4f0b-9fa5-3c42e441670b}
I opened the “turnkey-postgresql-12.1-squeeze-amd64.ovf”
and lines 47 indicate as follows.
Line 47 at turnkey-postgresql-12.1-squeeze-amd64.ovf file
So I have removed that - segment, it
is related to USB Controller (EHCI). When I try to import again it threw
following error.
Failed to import appliance E:\Software\postgresql\turnkey-postgresql-12.1-squeeze-amd64\turnkey-postgresql-12.1-squeeze-amd64.ovf.
The SHA1 digest of 'turnkey-postgresql-12.1-squeeze-amd64.ovf' does not match the one in 'turnkey-postgresql-12.1-squeeze-amd64.mf' (VERR_MANIFEST_DIGEST_MISMATCH).
Result Code: VBOX_E_FILE_ERROR (0x80BB0004)
Component: Appliance
Interface: IAppliance {3059cf9e-25c7-4f0b-9fa5-3c42e441670b}
It is because , "manifest" (.mf) file has the SHA1 checksums and since we remove - segment from “turnkey-postgresql-12.1-squeeze-amd64.ovf”
it is not matched. So I have simply removed “turnkey-postgresql-12.1-squeeze-amd64.mf”
file from ovf folder and tried again , it worked fine.
Select the "Reinitialize the MAC address of all network cards" if you have more than one instance in VBox
4. Run the imported instance from Oracle VBox, It direct to postgre installation and configuration wizard.
Provide root password for TurnKey Linux
Provide DBA password for Postgres DB server
You can Skip this step , Press "Tab" to jump from to
Press Enter to
Default Network Configurations , you can change in if require
Advance Menu
Default admin postgres username is “postgres” , password which you provided in above step
5. I have changed the network configarion to “Host-Only” in VBox because for my case I only need to access the database from my Windows.
If you select "Host-Only" then connect can be make from your Host PC only
6. Setup the database connection from Windows host PC.6. Setup the database connection from Windows host PC.
Connection testing from Host PC
pgAdmin tool is GUI based tool you can download
from here http://www.pgadmin.org/
to connect to VBox postgres DB.
Connection properties in pgAdmin tool to connect VBox postgres DB
Connection properties in pgAdmin tool to connect VBox postgres DB
7. Done !
