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 package . By default the package will be extracted in a folder called phpPgAdmin-<version> where <version> corresponds to the phpPgAdmin version you downloaded. You can rename the folder to anything you want and then you will be able to access it directly via your domain name (e.g. www.yourdomain.com/phppgadmin ). To log in and manage a Postgre database, you first need to create the database and add a user to it. You can do this from your cPanel > PostgreSQL Databases. With the user(s) you create you will be able to log in to your newly-installed phpPgAdmin.…

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 which database type you want to use - mysql or pgsql. From this point on you need to use the previously created PostgreSQL database and the username added to it for the script installation.…

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 use the Add User to DB form. All you need to do is select the corresponding database and user and then click the Submit button. If you have any PostgreSQL problems, ask your host for assistance. SiteGround offers the best Postgre hosting and we'll assist you with any Postgre-related questions/problems you may have.…

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 name. If you have any PostgreSQL problems, ask your host for assistance. SiteGround offers the best Postgre hosting and we'll assist you with any Postgre-related questions/problems you may have.…

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 either paste the SQL queries in the provided field or you can upload a local file to be executed. In order to execute a local Postgre SQL script, press the " Browse " button and locate the .sql file on your local computer. Once you have done that, click on the " Run " button and the queries from your file will be uploaded and executed on your database.…