PostgreSQL FAQs

The best way to check your version is to connect to the database and issue the following command:

sudo -u postgres psql 

The following statement displays the PostgreSQL server version along with the build information:

SELECT version();					version
------------------------------------------------------------------------------------------------------------
PostgreSQL 10.6 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 8.2.1 20180905 (Red Hat 8.2.1-3), 64-bit
(1 row)

If you don't have a PostgreSQL account, you can query the PostgreSQL packages directly on the database server. The output may vary depending on the MySQL version installed:

 linux> yum list installed | grep -i postgres 

There are links on the PostgreSQL site that covers the following topics:

• Database related topics (e.g. performance, replication, cluster, security, and etc.)
• PostgreSQL User groups
• Jobs & Recruiting

If your faculty or unit is supported by UBC IT’s Database Administration team, please contact them via their webform.

If your faculty or unit is not supported by UBC IT's Database Administration team, you can find support from a number of open source forums, such as the PostgreSQL Community, or from a commercial version of PostgreSQL support vendor more in-depth support.

Yes, the PostgreSQL tool pgAdmin provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and more.

We do not offer training; however, there are a number of third party companies that offer this training that you might be able to find online

Please complete our Database Administration Team webform for assistance on this.

PostgreSQL runs on both Linux and Windows operation systems For more information, please visit this page.

You can find the information about lifecycles on the following pages:

PostgeSQL Versioning Policy

If your faculty or unit is supported by UBC IT’s Database Administration team, please contact them via their webform. If your faculty or unit is not supported by UBC IT's Database Administration team, you can find support from a number of open source forums, such as the PostgreSQL Community, or from a commercial version of PostgreSQL support vendor more in-depth support.

UBC IT Database Administration team offers a 24 hours monitoring service for their database services.

We want UBC IT's Database Administration team to onboard our database. What sort of fee is required to do that?

Please fill out the Database Administration Team webform for more information.

Yes, please fill out the Database Administration Team webform and we will get in touch with you about it.

If it is a generally available (GA) product, then it should be reasonable to use.

Instructions on how to download PostgreSQL can be found here.

PostgreSQL Web site indicates that “The PostgreSQL Global Development Group supports a major version for 5 years after its initial release. After its five year anniversary, a major version will have one last minor release containing any fixes and will be considered end-of-life (EOL) and no longer supported”. More Information of when support ends for a particular version of PostgreSQL can be found here.