Creating a PostgreSQL User & Adding them to a database

In this tutorial: Create a User Add User to a Database In this tutorial we will show you how to create a PostgreSQL User, and then add them to a database. After getting PostgreSQL on your VPS or Dedicated server, you can create PostgreSQL users, and databases in cPanel. You must create a PostgreSQL database Read More >

Creating a PostgreSQL Database

After installing PostgreSQL and phpPgAdmin on your server, you can begin to work with postgreSQL databases. In this tutorial we will show you how to Create a PostgreSQL database in cPanel. How to Create a PostgreSQL Database Login to cPanel. Click the PostgreSQL Databases button in the Databases section. In the Create New Database section, Read More >

How to Import a PostgreSQL database using phpPgAdmin

Now that you’ve installed PostgreSQL and phpPgAdmin on your server, you can begin to create and manage databases. In this tutorial, we’ll show you how to import a PostgreSQL database using phpPgAdmin in cPanel. You must create a PostgreSQL database before you can complete this guide. Importing a Database with phpPgAdmin Login to cPanel. Click Read More >

Exporting a PostgreSQL database with phpPgAdmin

After installing PostgreSQL and phpPgAdmin on your server, you can begin to work with PostgreSQL databases. In this tutorial we will show you how to export your PostgreSQL database using phpPgadmin. Exporting your database allows you to save a backup of it, or import it into another account. How to Export a Database using phpPgAdmin Read More >

How to get PostgreSQL on a VPS / Dedicated Server

In this tutorial: Installing PostgreSQL Configure Postgres In this guide we will show you how to install PostgreSQL on a VPS or Dedicated server. PostgreSQL is a free open-source database management system, and one of the most popular alternatives to MySQL. After it is installed, we will show you how to configure Postgres; which will Read More >

How to import a database through shell

When you are importing a database over 50MB, you will run into the limitation in your PhpMyAdmin that prevents you from importing a database over 50MB. On shared servers you can try installing your own PhpMyAdmin to import it or you will need to contact tech support to import it for you. This article will Read More >

How to Access MySQL via Command Line

MySQL is the actual database system that uses the Structured Query Language to process data. MySQL is currently the most popular open source database and is frequently utilized with PHP to create dynamic websites. That said, MySQL also works well with Python, Ruby and Perl. This article will guide you on how to access the Read More >