David Ghedini

Linux, Java, Oracle, and PostgreSQL


David Ghedini

Tuesday Jul 11, 2017

GeoHelm

If you are looking to turn up a full, Open Source GIS stack with the latest versions of all software, check out GeoHelm.

GeoHelm installs the latest, stable releases of

Apache Tomcat
Java
PostgreSQL
PostGIS
PgRouting
GeoServer

It takes only 10 minutes to install

It also provides a UI within Webmin for managing all aspects of the stack (see screenshot below)

Best of all, it doesn't get tangled-up in the software, the module can be completely deleted with no impact on the stack.

Bookmark and Share



Saturday Jan 30, 2016

PostgreSQL 9.5 Script for Debian Jessie (8.3)

Adding on to the CentOS PostgreSQL 9.5 scripts below, I've added a version for Debian Jessie (8.3).

Please read the README and use only on a clean install!

https://github.com/intoGres/postgresql-9.5-script-debian-8.3x64

As with the CentOS scripts, it adds some basic security steps:

  • Creates a minimally privilaged user (pgadmin - change to whatever you like)
  • Disables root log in
  • Sets the SSH port to 3838 (change to whatever you like).
  • Sets root, postgres, admin, and ssl pass to 32 chars
  • Installs IP tables (if you want to use firwalld, comment the appropriate lines as noted).
  • Configures Webmin for managing PostgreSQL
  • Installs a self-signed SSL for PostgreSQL
  • Updates pga_hba.conf to MD5 and SSL
  • Updates postgresql.conf for SSL and remote connections.


Once completed, it will display the new passwords for pgadmin, root, postgres, and ssl as well as write them to an auth.txt file

: Example Output at End of Script
Passwords saved in /root/auth.txt
pg pass: DqVnavTlCXcSKfHprgUtjF-20rpfsKui
ssl pass: yxaQJCXgudTw19XEOMPdZzNd5n6rwVOG
pgadmin pass: A0RUHtPfSFC82mHeDP_ixrRavk7itgkE
root pass: RvZDHkZv-AeQS-ce0Mcnif7GxmmJ-zxN

Bookmark and Share



Wednesday Dec 23, 2015

PostgreSQL 9.5 Scripts for CentOS 6 and CentOS 7

I'm always pleasantly surprised to see that my "Install PostgreSQL 9 on CentOS" from back in 2011 is still coming up on Google searches and that I still get the occasional new comments for it.

I thought I might be useful to add some scripts for PostgreSQL 9.5 (and 9.4) for Both CentOS 6 and CentOS 7 that may be time savers.

Please read the README and use only on a clean install!

https://github.com/DavidGhedini/postgresql-9.5-script-centos-7x64

https://github.com/DavidGhedini/postgresql-9.4-script-centos-7x64

https://github.com/DavidGhedini/postgresql-9.5-script-centos-6x64

https://github.com/DavidGhedini/postgresql-9.4-script-centos-6x64

The CentOS scripts lists all of the packages individually so you can easily edit the script to add or remove packages.

The scripts adds some basic security steps:

  • Creates a minimally privilaged user (pgadmin - change to whatever you like)
  • Disables root log in
  • Sets the SSH port to 3838 (change to whatever you like).
  • Sets root, postgres, admin, and ssl pass to 32 chars
  • Installs IP tables (if you want to use firwalld, comment the appropriate lines as noted).
  • Configures Webmin for managing PostgreSQL
  • Installs a self-signed SSL for PostgreSQL
  • Updates pga_hba.conf to MD5 and SSL
  • Updates postgresql.conf for SSL and remote connections.


Once completed, it will display the new passwords for pgadmin, root, postgres, and ssl as well as write them to an auth.txt file

: Example Output at End of Script
Passwords saved in /root/auth.txt
pg pass: DqVnavTlCXcSKfHprgUtjF-20rpfsKui
ssl pass: yxaQJCXgudTw19XEOMPdZzNd5n6rwVOG
pgadmin pass: A0RUHtPfSFC82mHeDP_ixrRavk7itgkE
root pass: RvZDHkZv-AeQS-ce0Mcnif7GxmmJ-zxN

Bookmark and Share




Main Menu

Built With

Pages

LinkedIn

Tag Cloud

Hosted by:

Navigation

Visitors

Sponsors

petiole Cloud

Feeds