Do you provide any monitoring services for my database?Where can I find information regarding the lifecycles of PostgreSQL?Does PostgreSQL provide any visual tools?I'm not sure if what version of PostgreSQL that I am using. How do I determine that?
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
Are there any sources of support or information on the PostgreSQL community?
There are links on the PostgreSQL site that covers the following topics:
I would like to get support for PostgreSQL from UBC IT's Data Administration team, how do I do that?
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.
Does PostgreSQL provide any visual tools?
Yes, the PostgreSQL tool pgAdmin provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and more.
Where can I find PostgeSQL training and certification?
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.
Who can I get help for high availability architecture?
Please complete our Database Administration Team webform for assistance on this.
What operating systems can be used with PostgreSQL?
PostgreSQL runs on both Linux and Windows operation systems For more information, please visit this page.
Where can I find information regarding the lifecycles of PostgreSQL?
You can find the information about lifecycles on the following pages:
I want to perform database backup, but I don't have the privileges to do it. What do I do?
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.
Do you provide any monitoring services for my database?
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.
Can you help me upgrade my PostgreSQL version?
Yes, please fill out the Database Administration Team webform and we will get in touch with you about it.
Is it okay to use PostSQL 13, future releases?
If it is a generally available (GA) product, then it should be reasonable to use.
How do I download PostgreSQL?
Instructions on how to download PostgreSQL can be found here.
How do I determine when support ends (EOL) for particular version of PostgreSQL?
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.