Child pages
  • PostgreSQL Primer

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This tutorial is by no means a replacement for the excellent PostgreSQL documentation that can be found here. The goal of this tutorial is to provide a starting point for the most common actions for working with PostgreSQL, with pointers to more in-depth documentation where applicable.   

Table of Contents

Installing PostgreSQL

While PostgreSQL comes bundles with Servoy, the PostgreSQL installation provided through the Servoy All-In-One installer is a basic installation. Thus many people prefer  

...

As of Servoy 5.2 PostgreSQL is bundled with Servoy by default. The bundles PostgreSQL is however a very basic install. For production purposes it is also possible to use a dedicated PostgreSQL installer from EnterpriseDB.

Upgrading PostgreSQL

Starting and stopping PostgreSQL manually

Running PostgreSQL as a Service

Performing backups

...

Manual backups

...

Scheduled backups

...

PostgreSQL Database Admin tool

...