PostgreSQL FAQ (6 Articles)

How to access phpPgAdmin directly from my domain?

In order to access phpPgAdmin directly via your domain name without having to access your cPanel first, you need to install phpPgAdmin on your hosting account. The installation is very easy and consists of 3 simple steps: 1. Download the latest version of phpPgAdmin. 2. Upload the package to your public_html folder. 3. Extract the […]

Is it possible to use a Postgre database for application installation?

It is possible to use a PostgreSQL database for all applications that support this database type. The installation is not in anyway different from installation using a MySQL database. You just need to specify the database type you are using. For example, in Drupal there is a radio button which you can use to specify […]

How to create a Postgre user?

In order to create a PostgreSQL user you should go to your cPanel -> PostgreSQL Databases interface. In the Add New User form enter the username and password. Note that the username will always include your cPanel username as a prefix. Then you can add the newly-created username to an existing database. For this purpose […]

How to create a Postgre database?

Creating a PostgreSQL database is a straight-forward process. All you need to do is log in to your cPanel -> PostgreSQL Databases. In the Database Name: field enter the desired database name and click the Create Database button. Note that the database will always include your cPanel username as a prefix for the chosen database […]

How to import an .sql file into a Postgre database?

Log in to your cPanel and open the phpPgAdmin tool. Then click on the PostgreSQL link at the left tree menu and log in to the Postgre server using your cPanel login details. Next, select the database you want to import data into and click on the SQL button. You have two options. You can […]

How to connect to PostgreSQL from PHP?

For connecting to a PostgreSQL database from PHP you can use the standard pg_Connect() function. cPanel is easy to work with when you have the right host to support you. If you need a reliable partner to help you manage your website with cPanel, check out our cPanel hosting services!