Course Content
ACID Properties and Query Processing
0/2
PostgreSQL Replication
0/1
PostgreSQL Upgrade
0/1
PostgreSQL Tutorial for Absolute Beginners [Administration]
About Lesson

PostgreSQL has massive support and that has a lot of options to choose from. PostgreSQL includes streaming and logical replication built-in to the core package of the software. You may also able to set up asynchronous replication for PostgreSQL to have a more high-availability cluster while making a stand by node process your read queries.

Support for Several Procedural Languages: PL/pgSQL, PL/Tcl, PL/Perl, and PL/Python:

Since version 9.4, PostgreSQL has a great feature where you can define a new procedural language in accordance to your choice. Although not all varieties of programming languages are supported, it has a number of languages that are supported. Currently, with base distribution, it includes PL/pgSQL, PL/Tcl, PL/Perl, and PL/Python. The external languages are:

  1. PL/Java
  2. PL/Lua
  3. PL/R
  4. PL/sh
  5. PL/v8