Re: Post Installation PostgreSQL

You will need to modify the pg_hba.conf
find the line
local    all   postgres   peer

change the peer (access mode) to trust

Save the pg_hba.conf and restart the postgresql server

From a sql shell window type

ALTER ROLE postgres with password 'enter new password'  --don't forget the single tics

If you want to modify the access again
Just modify the pg_hba,conf file again, this time change the access mode from trust to say md5
this file is well documented within itself.

Keep in mind if you want this server to accessible to other users, you have to modify
both the pg_hba.conf and postgresql.conf configuration files

Proceed as follows:
Edit the postgresql.conf - uncomment the line listen_address ="localhost" , change localhost to "*" save file
Edit the pg_hb.conf - modify /add a line as follows
     
          host        all     all     192.168.1.0/24    md5

Change the IP_Addres (the first three octat) to whatever your network sub-net layout just keep the .0/24

Now, restart the postgresql server, if done right it should work

Use pgAdmin to configure groups and users

Good day
S.

---