PostgreSQL
Read about PostgreSQL's open source database management system for your business. Includes info on PostgreSQL, pricing, key information, and FAQs.
Updated on November 14th, 2023
The SMB Guide is reader-supported. When you buy through links on our site, we may earn an affiliate commission. Learn more
PostgreSQL, also known as Postgre, is a widely-used open source database management system. PostgreSQL is run by the PostgreSQL Global Development Group.
Pricing:
PostgreSQL is a free product.
Review:
Pros: Free, robust solution that runs on all major operating systems.
Cons: Does not offer master-to-master replications.
Bottomline: Reliable solution to manage your business's databases.
Key Information:
Legal Name | PostgreSQL Global Development Group |
Founder | Andrew Yu |
Founding Date | Jan 01, 1994 |
Number of Employees | 700 |
Number of Customers | 1000000 |
Website |
FAQs:
How is PostgreSQL different from MySQL?
Both Postgre and MySQL are open-source Object-Relational Database Management Systems and have more or less the same features and functionality. However, MySQL does charge for proprietary use and offers several paid editions. As PostgreSQL is a non-profit organization, it remains free for both individual users and companies.
What is PostgreSQL used for?
PostgreSQL is an extensible, general-purpose object-relational database management system that enables you to add custom functions developed. To do this, you would use different programming languages, for instance, C/C++ and Java.
What does PostgreSQL mean?
PostgreSQL is an open-source object-relational database management system (ORDBMS). It uses and extends the SQL language to safely store and scale complicated data workloads. Postgre is known for its robust feature set, architecture, reliability, and data security. PostgreSQL runs on all major operating systems and is ACID-compliant.
Is PostgreSQL free to use?
PostgreSQL is completely free. There are no paid tiers or premium plans.
How many PostgreSQL data types are there?
There are five PostgreSQL data types. These include "Primitives" such as Boolean, "Structured" such as UUID, "Document" including JSON and XML, "Geometry" such as Point, and "Customizations" such as Composite and Custom Types.
How do you install PostgreSQL?
Before you can use PostgreSQL you need to install it. Step-by-step instructions are available under Documentation and Manuals on their website. You can download the PostgreSQL latest version on the homepage.
Where can I find PostgreSQL documentation?
On the platform's home page, click on "Documentation" to access current and archived manuals.
How do I create PostgreSQL describe tables and/or a PostgreSQL log?
All documentation for describing tables and creating logs can be found under "Documentation" on PostgreSQL's website.
Where can I find PostgreSQL training?
PostgreSQL DBA training sessions are held throughout the year in many countries. For the latest schedule of training sessions, go to its website.
How do I get in touch with PostgreSQL support?
On the website, select "Support" on the main menu to access a variety of community and commercial support options. There are many local PostgreSQL User Groups all over the world, as well as an active internet relay chat and Slack community where you can ask questions.
Is there PostgreSQL for Mac?
PostgreSQL is the default database on the Mac OS Server as of OS X Server version 10.7.