PostgreSQL

Advanced Object-relational Database System

Description

PostgreSQL is a fully featured object-relational database with many enterprise features: ACID transactions, inheritance, unicode and strong support for the SQL-92 standard including subqueries, views, outer joins, foreign keys, sequences and triggers. It is also highly extensible and allows users to define internal functions in C, C++, Java, Perl, TCL, Python, Ruby, PHP and PL/PgSQL.

Included in this Appliance

This appliance includes all standard features and on top of that:

  • Web Control Panel
  • Adminer administration frontend for PostgreSQL (listening on port 12322 – uses SSL).
  • Webmin modules for configuring PostgreSQL.
  • PostgreSQL is configured to listen on its default port (5432/tcp) on all interfaces by default, and accept connections from all hosts. In a production environment, it is recommended to limit incoming connections to specific hosts by configuring Host and User access in /etc/postgresql/9.1/main/pg_hba.conf.
  • PostgreSQL password encryption enabled by default (security).
  • The postgres user is trusted when connecting over local unix sockets (convenience).
  • PostGIS support.

Usage details & Logging in for Administration

No default passwords: For security reasons there are no default passwords. All passwords are set at system initialization time.

Ignore SSL browser warning: browsers don’t like self-signed SSL certificates, but this is the only kind that can be generated automatically. If you have a domain configured, then via Confconsole Advanced menu, you can generate free Let’s Encypt SSL/TLS certificates.

Web – point your browser at either:

  1. http://12.34.56.789/ – not encrypted so no browser warning
  2. https://12.34.56.789/ – encrypted with self-signed SSL certificate

Note: some appliances auto direct http to https.

Web – point your browser at either:

  1. http://12.34.56.789/ – not encrypted so no browser warning
  2. https://12.34.56.789/ – encrypted with self-signed SSL certificate

Note: some appliances auto direct http to https.

Username for database administration:

Login as PostgreSQL username postgres at

  1. https://12.34.56.789:12322/ – Adminer database management web app
  2. PostgreSQL command line tool:
    $ psql -U postgres -h localhost
    Password for user postgres:
    Type "help" for help.
    
    postgres=#
    

Username for OS system administration:

Login as root

  1. Point your browser to:
  2. Login with SSH client:
    ssh root@12.34.56.789
    

* Replace 12.34.56.789 with a valid IP or hostname.

kisspng-postgresql-relational-database-management-system-m-5b2627cf3bd403.5133174715292272152451

Support Details

Supported By: Bamboozle
License: GNU AGPL v3

 

More  Links

Documentation: Technical overviews, how-tos, release notes, and support material

Tutorials: DevOps and development guidelines

AskCommunity: Connect, share and learn

More Marketplace Apps

mariaDB: The leading OpenSource Database

WordPress: Deploy fast and secure WordPress with one click.

Mattermost: The best and secure Slack Alternative

Check out our marketplace for more apps.

Create your PostgreSQL Appliance

Deploys instantly. 2 month free with annual plans.