亚洲同性男网站毛片

<noframes id="zvbdj"><strike id="zvbdj"><video id="zvbdj"></video></strike>

<em id="zvbdj"><video id="zvbdj"><output id="zvbdj"></output></video></em>

<track id="zvbdj"><i id="zvbdj"></i></track>
<meter id="zvbdj"></meter>
    <track id="zvbdj"></track>

    <progress id="zvbdj"></progress>
    <video id="zvbdj"></video>

        <rp id="zvbdj"></rp>
        <progress id="zvbdj"></progress>

        How to get PostgreSQL on a VPS / Dedicated Server

        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 add phpPgAdmin to cPanel. By using phpPgAdmin, you can easily access and modify the tables in your PostgreSQL database.

        You must have root access to your server to complete this guide! PostgreSQL, and phpPgAdmin are already installed on all shared servers.

        Installing PostgreSQL via SSH

        1. SSH into your server as root.
        2. Run the following command:
          /scripts/installpostgresYou will then see a message stating “This script will install PostgreSQL 7.4.x or later If you have an older version installed you will need to Dump your databases to a file and then restore them after the install as 7.4.x is not backwards compatible. If you do not have any databases, you can just run:
          mv /var/lib/pgsql /var/lib/pgsql.old
          /sbin/service postgresql stop
          /sbin/service postgresql start
          to force creating a 7.4.x style setup. Do not do this if you have databases that you wish to keep!

          Are you sure you wish to proceed?

        3. Type y then hit enter, to kick off the installation.
          How to get PostgreSQL on a VPS / Dedicated Server

          The process is finished when you are able to type in the command prompt again.

        Submit a Ticket Request

        If you need assistance installing PostgreSQL, or want to install a different version of PostgreSQL, please contact our Managed Hosting team.

        Configuring Postgres

        We will now show you how to configure Postgres, you will then be able to access phpPgAdmin in cPanel. This is a 2-step process.

        Step 1: Get phpPgAdmin

        1. Login to WHM as root.
        2. Click the Configure Postgres link in the SQL Services section.
          How to get PostgreSQL on a VPS / Dedicated Server

        3. Click the Install Config button in the Postgres Config Install section.
          How to get PostgreSQL on a VPS / Dedicated Server

          A box will pop-up and ask “Are you SURE you want to overwrite your current config file?” Click the OK button.
          How to get PostgreSQL on a VPS / Dedicated Server

          It is finished when you see a message stating “ALTER ROLE Configuration successfully updated

        Step 2: Creating Postgres Users

        In this second step you will now create the Postgres Users in WHM. This and all steps in this tutorial are required to allow you to use PostgreSQL in your cPanel.

        1. Login to WHM as root.
        2. Click the Configure Postgres link in the SQL Services section.
          How to get PostgreSQL on a VPS / Dedicated Server

        3. Click the Create Users button in the Create Postgres Users section.
          How to get PostgreSQL on a VPS / Dedicated Server

          You are finished when you see a message stating “PostgreSQL users created

        Congratulations, now you know how to install, and configure PostgreSQL on your VPS or Dedicated server! Learn more about PostgreSQL Hosting

        JB
        John-Paul Briones

        John-Paul is an Electronics Engineer that spent most of his career in IT. He has been a Technical Writer for InMotion since 2013.

        More Articles by John-Paul

        Was this article helpful? Let us know!

        亚洲同性男网站毛片
        <noframes id="zvbdj"><strike id="zvbdj"><video id="zvbdj"></video></strike>

        <em id="zvbdj"><video id="zvbdj"><output id="zvbdj"></output></video></em>

        <track id="zvbdj"><i id="zvbdj"></i></track>
        <meter id="zvbdj"></meter>
          <track id="zvbdj"></track>

          <progress id="zvbdj"></progress>
          <video id="zvbdj"></video>

              <rp id="zvbdj"></rp>
              <progress id="zvbdj"></progress>