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. ----- Original Message ----- From: "James Woods" <james.woods.n...@statefarm.com> To: pgadmin-support@postgresql.org Cc: "Phil Holverson" <phil.holverson.a...@statefarm.com>, "James Woods" <james.woods.n...@statefarm.com> Sent: Wednesday, April 10, 2013 7:28:47 AM Subject: Re: [pgadmin-support] Post Installation PostgreSQL Hello; I’m using the following installation guide: http://techguide.opr.statefarm.org/index.php/Workstation_Setup_Guide:_PostgreSQL_%26_pgAdmin One step in the section ‘Post Installation Verification (Windows)’ states: * Enter the postgres password A default password is not provided on the Wiki page. Nor is it cached as a property for localhost. What is the default password? Thank You James Woods Capacity Management Strategy and Enablement Lead C:309-846-9947
