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:
- Install only the base package
- Check the box for SSL Support
- 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.