Tag: PostgreSQL
How To Install Discourse
What is Discourse?
Discourse is modern forum software that can be easily installed on your Ubuntu-based Liquid Web VPS or Dedicated server to create a vibrant community-driven discussion board. Some of the more popular companies using Discourse to power their communities are New Relic, Cloudflare, and Docker.
Installing SQLAlchemy With Pip
The SQLAlchemy Toolkit and Object Relational Mapper is an extensive set of utilities for working with Python and databases. This toolkit provides a package full of popular persistence patterns, designed for economical and robust database accessibility. SQLAlchemy allows a developer to use simple SQL statements (unlike other Object Relational Mapping tools) which provide a helpful method to connect database tables with user-defined Python classes. The SQLAlchemy Object Relational Mapping tool is primarily centered on using the SQL Expression language.
How To Remove PostgreSQL
Sometimes during a software install, things can go sideways and you realize that not all the program downloaded or the installation was interrupted for some reason leaving you with incomplete files and empty directories. Honestly, this is a rare occurrence but it can happen from time to time. This then begs the question; So how do I completely uninstall recently installed software? In this tutorial, we’ll be safely removing PostgreSQL from our Liquid Web Ubuntu VPS server.
Common Postgres Tasks on CentOS 7
This guide walks you through some common tasks surrounding a Postgres server. In this tutorial, we’ll cover installing Postgres, creating new databases and users, backing up databases, and more! Let’s dig in!
How to Work With PostgreSQL Databases
Table of Contents
Listing databases
Dump a database
Dumping all databases
Dump Grants
Delete or Drop a Database
Delete a Grant
Restore a Database
Restore Grant
Listing and Switching Databases in PostgreSQL
PostgreSQL (pronounced "post-gress-Q-L") is a household name for open source relational database management systems. Its object-relational meaning that you’ll be able to use objects, classes in database schemas and the query language. As part of our PostgreSQL series, we’ll show you how to list and switch between databases quickly.
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.