Intro to PostgreSQL
PostgreSQL is an open source, ACID-compliant, object-oriented relational database. PostgreSQL has been under continuous development for 30 years, and is known for its reliability, performance, and comprehensive feature set. Learn more about PostgreSQL, including an overview of the software, how to install PostgreSQL, and troubleshooting tips.
Install PostgreSQL on Windows Server 2016
PostgreSQL is an open source object-relational database system with over 15 years of active development and a reputation for reliability. This database management system supports the SQL92 and SQL99 standards and provides a number of own extensions. PostgreSQL is fully ACID-compliant and it includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP.
Solve the PostgreSQL Error "psql: FATAL: database "root" does not exist"
Learn how to solve the common PostgreSQL error psql: FATAL: database "root" does not exist." New PostgreSQL users often encounter this error when first logging in to PostgreSQL.
Troubleshoot a PostgreSQL "Could not connect to server" Error
Learn how to troubleshoot one of the most common PostgreSQL errors, "Could not connect to server." There are several different variations of this error.
Install and Use PostgreSQL
PostgreSQL is a powerful object-relational database system. It features robust functionality, and supports a large number of concurrent transactions, which makes it an excellent choice for large and/or high-demand database applications. This tutorial will cover how to install and run PosgreSQL, and an introduction to some of the basic commands.
How to Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 16.04
Learn how to use PostgreSQL with your Ruby on Rails application, instead of the default SQLite database. SQLite is an easy-to-configure, lightweight product which ships with Ruby on Rails by default. However, PostgreSQL is a more robust solution which provides more advanced features, scaling, and stability, which may make it more suitable for your Ruby on Rails project.