Sorry about that. I completely forgot I had ran into an additional issue with the Postgresql configuration whereby the connection is allowed. These instructions will be somewhat generic as I do not know where exactly you will find the files that require editing.
Depending on your VM and the installation of postgres, I have seen the config in different places. The two files that you are looking for are:
On the VM I have available they were in the following locations:
I have also seen them in
1) login as root
2) locate the config files and change to that directory.
3) vi postgresql.conf
Change this line from
#listen_addresses = 'localhost'
listen_addresses=’*’ (notice it has been uncommented as well)
4) vi pg_hba.conf
then add the following line under: local all postgres peer
host all all 0.0.0.0/0 trust
5) /etc/init.d/postgresql restart (this name may be different mine is postgresql-9.4)
Now you should be able to connect with PGAdmin. Let me know if that gets you connected.
Posted: 3 years ago
Posted: 3 Jul 2018 11:25 EDT
Lee Pederson (pedel)
Global Tech Enablement, Principal Instructor - LSA