Обсуждение: Re: 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
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.
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.
From: "James Woods" <james.woods.no0i@statefarm.com>
To: pgadmin-support@postgresql.org
Cc: "Phil Holverson" <phil.holverson.a21g@statefarm.com>, "James Woods" <james.woods.no0i@statefarm.com>
Sent: Wednesday, April 10, 2013 7:28:47 AM
Subject: Re: [pgadmin-support] Post Installation PostgreSQL
To: pgadmin-support@postgresql.org
Cc: "Phil Holverson" <phil.holverson.a21g@statefarm.com>, "James Woods" <james.woods.no0i@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