PostgreSQL

PostgresQL is a free and open-source object-relational database management system emphasizing extensibility and standards compliance.

PostgreSQL subscription active
You will receive email notifications for new publications on PostgreSQL.
70 Results
  • Tutorial

    How To Install and Use PostgreSQL on Ubuntu 18.04

    This tutorial provides instructions on how to install the PostgreSQL database software on an Ubuntu 18.04 server. It also includes instructions for basic database management.
    By Justin Ellingwood, Mark Drake PostgreSQL Databases Ubuntu Ubuntu 18.04
  • Tutorial

    SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems

    This article compares and contrasts three of the most widely implemented open-source RDBMSs: SQLite, MySQL, and PostgreSQL. Specifically, it explores the data types that each RDBMS uses, their advantages and disadvant...
    By ostezer, Mark Drake MySQL PostgreSQL Databases Conceptual
  • Tutorial

    How To Use Roles and Manage Grant Permissions in PostgreSQL on a VPS

    PostgreSQL is an open source database management system that stores and manipulates data produced by other applications. This guide will cover how to manage permissions and privileges within PostgreSQL by controlling...
    By Justin Ellingwood PostgreSQL Ubuntu
  • Tutorial

    How To Install and Use PostgreSQL on Ubuntu 16.04

    Relational database management systems are a key component of many web sites and applications. They provide a structured way to store, organize, and access information. PostgreSQL, or Postgres, is a relational databas...
    By Justin Ellingwood PostgreSQL Ubuntu Ubuntu 16.04
  • Tutorial

    How To Set Up Django with Postgres, Nginx, and Gunicorn on Ubuntu 16.04

    Django is a powerful web framework that can help you get your Python application or website off the ground. Django includes a simplified development server for testing your code locally, but for anything even slightly...
    By Justin Ellingwood PostgreSQL Django Nginx Python Frameworks Python Ubuntu Ubuntu 16.04
  • Tutorial

    How To Set Up Django with Postgres, Nginx, and Gunicorn on Ubuntu 18.04

    Django is a powerful web framework that can help you get your Python application or website off the ground. Django includes a simplified development server for testing your code locally, but for anything even slightly...
    By Justin Ellingwood Django Python Python Frameworks Databases PostgreSQL Nginx Ubuntu 18.04
  • Tutorial

    How To Install and Use PostgreSQL on Ubuntu 14.04

    PostgreSQL is one of the most powerful and popular relational database management systems available for open source platforms. In this guide, we'll talk about how to get it up and running on an Ubuntu 14.04 VPS insta...
    By Justin Ellingwood PostgreSQL Ubuntu
  • Tutorial

    How To Use PostgreSQL with your Django Application on Ubuntu 14.04

    Django is a flexible framework for quickly creating Python applications. By default, Django applications are configured to store data into a light weight SQLite database file. While this works well under some loads, a...
    By Justin Ellingwood PostgreSQL Django Python Python Frameworks Ubuntu
  • Tutorial

    How To Install and Use PostgreSQL on CentOS 7

    PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of bein...
    By Mitchell Anicas, Vadym Kalsin PostgreSQL CentOS Databases
  • Tutorial

    How To Set Up a Ruby on Rails Project with a React Frontend

    In this tutorial, you will create a Ruby on Rails application that stores your favorite recipes in a PostgreSQL database then displays them with a React frontend. When you are finished, you will be able to create, vie...
    By Chuks Opia Ruby Ruby on Rails React Development Applications PostgreSQL Programming Project
  • Tutorial

    How To Set Up Ruby on Rails with Postgres

    This tutorial helps with setting up Ruby on Rails with Postgres.
    By Alex Ghiculescu Ruby on Rails PostgreSQL Ruby
  • Tutorial

    How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 16.04

    Whether you’re adding more space, evaluating ways to optimize performance, or looking to take advantage of other storage features, this tutorial will guide you through relocating PostgreSQL’s data directory.
    By Melissa Anderson PostgreSQL Storage Block Storage Ubuntu Ubuntu 16.04
  • Tutorial

    How To Install and Configure pgAdmin 4 in Server Mode

    In this tutorial, we'll walk through the process of installing and configuring the latest version of pgAdmin onto an Ubuntu 18.04 server, accessing pgAdmin through a web browser, and connecting it to a PostgreSQL data...
    By Mark Drake PostgreSQL Apache Python Databases Ubuntu 18.04 Ubuntu
  • Containerizing a Ruby on Rails Application for Development with Docker Compose

    If you are actively developing an application, using Docker can simplify your workflow and the process of deploying your application to production. This tutorial will show you how to set up a development environment f...
    By Kathleen Juell Ruby on Rails Docker Redis PostgreSQL
  • Tutorial

    How To Install and Configure Django with Postgres, Nginx, and Gunicorn

    This tutorial runs through both installing and configuring Django with Postgres, Nginx, and Gunicorn on your VPS.
    By Stephen Tippets Django PostgreSQL Nginx Python
  • Tutorial

    How to Build a Django and Gunicorn Application with Docker

    Interested in Django but not sure where to start with Docker? This tutorial will walk you through first steps: modifying a sample Django application to work in a container-based environment, and building a container i...
    By Justin Ellingwood, Hanif Jetha Django Ubuntu 18.04 Applications Docker PostgreSQL Python Databases
  • Tutorial

    An Introduction to Queries in PostgreSQL

    In this guide, we will discuss the basic syntax of SQL queries as well as some of the more commonly-employed functions and operators. We will also practice making SQL queries using some sample data in a PostgreSQL dat...
    By Mark Drake PostgreSQL Databases Ubuntu 18.04 Ubuntu
  • Tutorial

    How To Set Up Master Slave Replication on PostgreSQL on an Ubuntu 12.04 VPS

    PostgreSQL, or postgres, is a popular database management system often used to manage the information from websites and applications. In this guide, we will configure a master server postgres replication set up, whic...
    By Justin Ellingwood PostgreSQL Load Balancing Backups Ubuntu
  • Tutorial

    How To Deploy a Rails App with Unicorn and Nginx on Ubuntu 14.04

    When you are ready to deploy your Ruby on Rails application, there are many valid setups to consider. This tutorial will help you deploy the production environment of your Ruby on Rails application, with PostgreSQL as...
    By Mitchell Anicas Ruby on Rails Deployment PostgreSQL Nginx Ubuntu
  • Tutorial

    How To Backup PostgreSQL Databases on an Ubuntu VPS

    PostgreSQL is a popular database management system that can be used to handle the data from your website or application. This article will discuss methods of backing up PostgreSQL databases to ensure that your inform...
    By Justin Ellingwood PostgreSQL Backups Ubuntu