Postgresql

A pre-configured one-click install solution for PostgreSQL 9.5 server, a powerful, enterprise class open source object-relational database.

Usage

You can install the appliance on any new or existing Linux server, download and run it as a virtual machine, use it as a base image for Docker or Vagrant, or launch it with a new cloud platform instance, VPS or dedicated server for supported hosting providers.

Launch in clouds
Aws ec2 Google cloud platform Digital ocean Microsoft azure Ibm bluemix Oracle cloud platform
Install
Install on Linux

You can install the appliance directly on any Linux with 64-bit kernel (>=2.6.32). Run from the command line:

curl -L http://jetware.io/appliances/jetware/postgresql95-170503/file/installer:nub_tgz/setup | sh

You’ll be asked to execute some operations as root via sudo during the installation.

How to use

To enter the runtime environment or to execute a command inside the runtime environment you can use the utility /jet/enter. If no arguments are present, the standard shell will be executed inside the runtime environment. You can specify a command as an argument, it will be executed inside the runtime environment.

For example, to start all services in the runtime environment you can do /jet/enter start. To execute a mysql client you can do /jet/enter mysql; or run first /jet/enter, and than run from the new command line mysql.

Download archive

You can download the archive, unpack it into the /jet directory, finish installation by executing the command /jet/enter /jet/own/bin/fasten and start the services by running /jet/enter start.

databases_postgresql-18sok4jdlqsar.tar.gz
107 MB
Run a container
Alpine 3.8
Ubuntu 18.04
Debian 9
CentOS 7
Docker

Copy Dockerfile into your project’s directory:

FROM alpine:3.8
RUN apk add sudo libcap tar
RUN adduser -S -h /jet -s /jet/login jet

RUN { wget -O - "http://jetware.io/appliances/jetware/postgresql95-170503/file/container:docker/setup" || echo exit 1; } | sh

WORKDIR /jet
USER jet
VOLUME ["/jet/prs"]
ENTRYPOINT ["/jet/login"]
CMD ["main"]

or build an image directly from the URL by executing the command:

docker build 'http://jetware.io/appliances/jetware/postgresql95-170503/file/container:docker/Dockerfile?os=alpine_3.8'

Copy Dockerfile into your project’s directory:

FROM ubuntu:18.04
RUN \
  echo "tzdata tzdata/Areas select Etc" | debconf-set-selections; \
  echo "tzdata tzdata/Zones/Etc select Universal" | debconf-set-selections; \
  apt-get update && \
    DEBIAN_FRONTEND=noninteractive DEBCONF_NONINTERACTIVE_SEEN=true \
      apt-get install -y tzdata netbase sudo wget libcap2-bin
RUN useradd --system -m --home /jet --shell /jet/login jet

RUN { wget -O - "http://jetware.io/appliances/jetware/postgresql95-170503/file/container:docker/setup" || echo exit 1; } | sh

WORKDIR /jet
USER jet
VOLUME ["/jet/prs"]
ENTRYPOINT ["/jet/login"]
CMD ["main"]

or build an image directly from the URL by executing the command:

docker build 'http://jetware.io/appliances/jetware/postgresql95-170503/file/container:docker/Dockerfile?os=ubuntu_18.04'

Copy Dockerfile into your project’s directory:

FROM debian:9-slim
RUN apt-get update && apt-get install -y netbase sudo wget libcap2-bin
RUN useradd --system -m --home /jet --shell /jet/login jet

RUN { wget -O - "http://jetware.io/appliances/jetware/postgresql95-170503/file/container:docker/setup" || echo exit 1; } | sh

WORKDIR /jet
USER jet
VOLUME ["/jet/prs"]
ENTRYPOINT ["/jet/login"]
CMD ["main"]

or build an image directly from the URL by executing the command:

docker build 'http://jetware.io/appliances/jetware/postgresql95-170503/file/container:docker/Dockerfile?os=debian_9'

Copy Dockerfile into your project’s directory:

FROM centos:7
RUN yum install -y sudo wget libcap
RUN useradd --system -m --home /jet --shell /jet/login jet

RUN { wget -O - "http://jetware.io/appliances/jetware/postgresql95-170503/file/container:docker/setup" || echo exit 1; } | sh

WORKDIR /jet
USER jet
VOLUME ["/jet/prs"]
ENTRYPOINT ["/jet/login"]
CMD ["main"]

or build an image directly from the URL by executing the command:

docker build 'http://jetware.io/appliances/jetware/postgresql95-170503/file/container:docker/Dockerfile?os=centos_7'
Download a virtual machine
CentOS 7
Debian 8
Ubuntu 14.04
VMWare
databases_postgresql-18sok4jdlqsar-vmware-centos_7.zip
364 MB
databases_postgresql-18sok4jdlqsar-vmware-debian_8.zip
databases_postgresql-18sok4jdlqsar-vmware-ubuntu_14.04.zip
344 MB
VirtualBox
databases_postgresql-18sok4jdlqsar-virtualbox-centos_7.ova
443 MB
databases_postgresql-18sok4jdlqsar-virtualbox-debian_8.ova
417 MB
databases_postgresql-18sok4jdlqsar-virtualbox-ubuntu_14.04.ova
451 MB
Qemu/KVM
databases_postgresql-18sok4jdlqsar-qemu-centos_7.qcow2.gz
353 MB
databases_postgresql-18sok4jdlqsar-qemu-debian_8.qcow2.gz
278 MB
databases_postgresql-18sok4jdlqsar-qemu-ubuntu_14.04.qcow2.gz

You can access the virtual machine via console or SSH:

Login: jet
Password: jet
Development tools
CentOS 7
Debian 8
Ubuntu 14.04
Vagrant

You can use the appliance as a Vagrant base box for any OS with VirtualBox support (Windows, OS X, Linux).

Copy Vagrantfile in your project’s directory:

Vagrant.configure(2) do |config|
  config.vm.box = "jetware/jetware-postgresql95-centos_7"
  config.vm.box_url = "http://jetware.io/appliances/jetware/postgresql95-170503/download/image:base_image:vagrant?os=centos_7"
  config.vm.network "forwarded_port", guest: 80, host: 8080, auto_correct: true
end

or add base box to your local boxes:

vagrant box add "http://jetware.io/appliances/jetware/postgresql95-170503/download/image:base_image:vagrant?os=centos_7" --name "jetware/jetware-postgresql95-centos_7"

You can use the appliance as a Vagrant base box for any OS with VirtualBox support (Windows, OS X, Linux).

Copy Vagrantfile in your project’s directory:

Vagrant.configure(2) do |config|
  config.vm.box = "jetware/jetware-postgresql95-debian_8"
  config.vm.box_url = "http://jetware.io/appliances/jetware/postgresql95-170503/download/image:base_image:vagrant?os=debian_8"
  config.vm.network "forwarded_port", guest: 80, host: 8080, auto_correct: true
end

or add base box to your local boxes:

vagrant box add "http://jetware.io/appliances/jetware/postgresql95-170503/download/image:base_image:vagrant?os=debian_8" --name "jetware/jetware-postgresql95-debian_8"

You can use the appliance as a Vagrant base box for any OS with VirtualBox support (Windows, OS X, Linux).

Copy Vagrantfile in your project’s directory:

Vagrant.configure(2) do |config|
  config.vm.box = "jetware/jetware-postgresql95-ubuntu_14.04"
  config.vm.box_url = "http://jetware.io/appliances/jetware/postgresql95-170503/download/image:base_image:vagrant?os=ubuntu_14.04"
  config.vm.network "forwarded_port", guest: 80, host: 8080, auto_correct: true
end

or add base box to your local boxes:

vagrant box add "http://jetware.io/appliances/jetware/postgresql95-170503/download/image:base_image:vagrant?os=ubuntu_14.04" --name "jetware/jetware-postgresql95-ubuntu_14.04"

Configuration

Main settings

config

Directories

Configurations: /jet/etc
Log files: /jet/log
Applications: /jet/app
Applications data: /jet/var
Temporary files: /jet/tmp
Persistent data: /jet/prs

postgresql

Administrator username: postgres
Administrator password: empty
Port: 5432
Socket: