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 Plus Standard Server.
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.
PostGIS is a powerful spatial database extension you can use with Postgres Plus Standard
Server. This tutorial shows how quickly you can setup and begin using a spatially enabled
database that can be applied to a variety of applications.
PostGIS is a powerful spatial database extension bundled with Postgres Plus Advanced Server.
This tutorial shows how to install, setup, and begin using a spatially enabled database
that can be applied to a variety of applications.
Learn how to use the pgAdmin GUI in Standard Server (Postgres Studio in Advanced Server) to
safeguard Postgres Plus databases. You will then be able to build a database and an application
for a Technical Evaluation, knowing you can easily create intermittent database backups of
your work and restore them if needed.
A competent partitioning strategy can yield dramatic results speeding up response times
for activities like long queries, backups, reporting and regular maintenance tasks. This
tutorial shows you how to quickly create table partitions and then query the data
across both partitions.
Table partitions use simple rules driven by data values in table rows to spread the rows
among the partitions. This increases query and maintenance efficiency. 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.
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 archiving old records from a table, vacuuming certain tables, or
performing application-oriented operations such as batch posting daily transactions to accounts.
Migrating from Oracle to another database is not a trivial task and will have a
variety of issues that need to be resolved either manually, with migration tools,
or with compatible feature/function mappings and substitutions. Before attempting
your migration, read about the most common issues you'll encounter and how easily
they are handled with Postgres Plus Advanced Server.
