PostgreSQL is a feature rich database application that is on par with many enterprise level databases.  Before installing this database software, we recommend that you review the requirements of the application you wish to use with it to make sure that PostgreSQL is the right solution.

To install Postgres:

Log in to your VDS Manager by clicking the ‘Login to VDS Manager’ link from the Products page of the Customer Manager, which is located at https://my.opensourcehost.com.

Click on Install & Manage on the left side of the screen

Click on the Database folder at the top of the page

Click on PostgreSQL under the Available ValueApps section on the left

Agree to the license

Enter a password for use when connecting to Postgres. The username that you will use is the same as your VDS username (also used for FTP access).

Re-enter the password

Click the button

Now that the database server is installed and running, you’ll want to create a database and start using it. If your web software has the ability to automatically configure Postgres, please refer to its documentation. If you are creating a new application or would like to easily manage your Postgres data, we provide a web based interface for Postgres that you can install.

---

To install the graphical PhpPgAdmin interface:

Log in to your VDS Manager by clicking the ‘Login to VDS Manager’ link from the Products page of the Customer Manager, which is located at https://my.opensourcehost.com.

Click on Install & Manage on the left

Click on the Database folder at the top of the page

Click on phpPgAdmin under the Available ValueApps section on the left

Agree to the license

Click the button

You will now see a link labeled “Launch Application” next to PhpPgAdmin under Installed ValueApps that you can click to access your database information; you can also use this direct link to access PhpPgAdmin using your VDS Manager username and password:

http://yoursitedomain.com/phppgadmin/

Related Articles: