Tutorials

Getting Started with Postgres Plus® Tutorial for Windows®

Master the basic operations of Postgres Plus and get into the interesting parts of your evaluation faster. This tutorial covers the basics of starting and stopping the database server, checking the server's status, using the pgAdmin GUI administrator's / developer's tool, and accessing the SQL...

How to Enable Audit Logging in EDB Postgres™ Advanced Server

EDB Postgres Advanced Server provides enterprise audit logging capabilities for tracking and analyzing database activities. You can audit user connection activity, user SQL activity including Errors, rollbacks, all DDL, all DML, all SQL statements, and even capture middle tier data tracking specific application users and IP addresses.  This tutorial makes setup quick and easy.

Getting Started with EDB Postgres™ Advanced Server on Linux®

Master the basic operations of EDB Postgres on Linux and get into the interesting parts of your evaluation faster. This tutorial covers the basics of starting and stopping the database server, checking the server's status, using the Postgres Enterprise Manager client, and accessing the SQL command line console.

How to Setup pgAgent for Postgres Plus

pgAgent is a pre-bundled enterprise module installed by default with Postgres Plus Standard Server and Postgres Plus Advanced Server. The pgAgent job scheduler allows authorized users to schedule jobs consisting of one or more SQL or shell/batch steps. Common uses include scheduled tasks such as...

Enabling Row movement and Updateable Partition Keys

Table partitions use simple rules driven by data values in table rows to spread the rows among the partitions. This provides multiple run time and maintenance efficiencies. However, once you have partitioned a table it is sometimes necessary to automatically move rows between the partitions following updates to data values that change which partition the row should reside in. This Quick Tutorial shows how to automatically move data across partitions and maintain partition keys at the same time.

How to Setup and Use PostGIS with Postgres Plus Advanced Server

PostGIS is a powerful spatial database extension bundled with Postgres Plus Advanced Server that adds spatial data types, functions and operators. This tutorial shows how to install, setup, and begin using a spatially enabled database that can be applied to a variety of applications.

How to Setup Slony-I Replication with Postgres Plus

Slony is a master to multiple slaves replication system with cascading and failover capabilities. When used with Postgres Plus, it becomes a powerful tool used for safeguarding data, failover/standby capabilities, optimizing online transaction processing, offloading reporting/BI queries, backup and restore, and migrating systems. This tutorial shows how to efficiently setup a basic master-slave system that can be applied to a variety of applications.

How to Set Up PgBouncer Connection Pooling with Postgres Plus Standard Server

PgBouncer is a lightweight connection pooler for Postgres Plus that dramatically reduces the processing time and resources for maintaining a large number of client connections to one or more databases. PgBouncer is typically used to increase the number of user connections that can be handled in a high performance environment. This tutorial shows how to effectively setup and configure a pgBouncer environment for Postgres PlusStandard Server.