https://help.superhosting.bg/en/phppgadmin-postgresql.html
  • bg
  • en

Hosting, Domains, Cloud, Virtual Private Servers (VPS), Managed VPS, SSL Certificates

How to Install and Configure phpPgAdmin

PostgreSQL
pgadmin, phppgadmin, postgresql, psql

phpPgAdmin is an application that enables you to set up and manage PostgreSQL databases directly through a web browser.

phpPgAdmin in cPanel

phpPgAdmin, available in cPanel The web tool phpPgAdmin that enables you to manage PostgreSQL databases is available in your cPanel. However, it won't be possible to perform all kinds of actions with the database because it uses the cPanel user.

You can login only by using the cPanel user. To access a certain database with its assigned user you will need to install an additional phpPgAdmin in your hosting account

Installing phpPgAdmin

We recommend using an additionally installed phpPgAdmin to set up and manage PostrgeSQL databases.

Access to additionally installed phpPgAdminInstalling the tool is easy as it is practically placing the system files into your hosting account. After you download the installation package from the official website, upload the archive file into your hosting account in a directory of your choice and extract its contents.

Open the directory with the extracted files in a web browser.

Click PostgreSQL (1) and enter a database username and a password in the login form (2).

You should create a user in advance and assign it to the database by accessing cPanel -> PostgreSQL Databases.

info-iconNote: It is a good idea to restrict the web access to phpPgAdmin by using a username and password. You can do this in cPanel -> Password Protected Directories.

Configuring phpPgAdmin

After logging into the database with your username, you can create and configure schemes or tables, change permissions, etc.

A list of schemes in the database

Each new PostgreSQL database contains a schema named "public" (1).

We recommend that you create your own schema (2) that is different from public.

Thus your database user will be the owner (!) of the new schema and you will have full access to change any settings.

Schema Аctions:

Drop: You can remove the schema. Select the CASCADE option so that all dependent objects such as tables, functions, etc. are deleted.
Privileges: You can grant or revoke access rights.
Alter: You can modify the schema name or its comment.

If you wish to specify that a certain schema, other than public, is to be used in a CMS, go to the prefix tables settings. There first enter the schema name, then a dot and the prefix. For example:  define('TABLE_PREFIX', 'myschema.tblprefix_');.

If a database is used by multiple applications, the schemas are very convenient and logical way to keep their data separate. You can generate a separate schema for each application. As shown in the example above, the wolf schema will be used by Wolf CMS.

500px270px
SuperHosting.BG
    PostgreSQL
  • How to Import and Export Databases Using phpPgAdmin
    To manage the PostgreSQL databases in your hosting account you should use additionally installed phpPgAdmin. Exporting Data into .sql File With phpPgAdmin you can export the entire database or a single schema. Depending on... »
  • Connecting to PostgreSQL Databases with pgAdmin III
    pgAdmin III is an open source application for remote administration and management of PostgreSQL databases. Unlike phpPgAdmin which is accessed through a browser, pgAdmin is installed locally on your PC. pgAdmin is... »
  • Creating a PostgreSQL Database in cPanel
    You can create a PostgreSQL database in cPanel -> PostgreSQL Databases. PostgreSQL is supported by SuperHosting.BG. You can set up a PostgreSQL database in cPanel. If you want to use this database, but... »
  • PostgreSQL - Features and Support
    PostgreSQL is an open-source object-relational database (ORDBMS). It is supported by all major operating systems such as Linux, Unix and Windows. PostgreSQL is also supported by SuperHosting.BG. You can create a PostgreSQL... »
All rights reserved © 2005-2017 , www.superhosting.bg