PostgreSQL: Main Page

Manager

 

AcuGIS Enterprise Suite provides a browser-based interface for managing all aspects of PostgreSQL.

These featues include:

  • Repository Manager
  • Package Installation Manager
  • Database Snapshot
  • Clone Database
  • Restore Database

 

Repository Manager

 

The repository also provides PostGIS, PgRouting, and various libraries.

So in selecting the latest version you will also be getting the latest versions of above.

 

Installed Packages Manager

Once you have installed the repository, you will see a list of available packages, as shown below.

On the initial installation, we recommend:

  1. Install only the base package
  2. Check the box for SSL Support
  3. Do not enable Remote Access unless you are sure what you are doing.

The above recommendations will make installation faster and more secure.

 

 

 

If you encounter any issues with installing PgRouting, or do not see PgRouting listed above, you can install using below:

On CentOS systems:

yum install pgrouting_96*

On Debian systems:

apt-get install postgresql-9.6-pgrouting

 

To create databases, users, run SQL, etc.. see the PostgreSQL Webmin Module page.

 

 

Next Up: PostgreSQL Webmin Module

PostgreSQL Webmin Module