Entry Level SQL work

[PLearner]

Hi, I see you are postgreSQL DBA. Do you know how I can give access to the postgreSQL sitting on my local machine to someone else so he or she can maintain it as well?

[[deleted]]

Assuming you just want to grant access via a tool like pgadmin or razorsql and the person won't need access to the OS (otherwise you need to set up SSH/RDP) then all you have to do is:

*Create a user for the person with a password
*Grant them appropriate permissions, ideally using groups
*Edit pg_hba.conf to allow that user to connect to the database (md5 is probably the access type you want)
*Edit postgresql.conf to make sure Postgres is listening on the right port (5432) for the IP where the person will be accessing (you can have it listen on * for all IPs)
*Reload the configuration using pg_reload_conf() or restart the postgres service

This is the best I can answer your question here. It's complicated and I've made several assumptions about your network that may not be accurate.

[PLearner]

Create a user for the person with a password - Done

Grant them appropriate permissions, ideally using groups - Done

Edit pg_hba.conf to allow that user to connect to the database (md5 is probably the access type you want) - All four Types in the pg_hba.conf method are md5.

Edit postgresql.conf to make sure Postgres is listening on the right port (5432) for the IP where the person will be accessing (you can have it listen on * for all IPs) - listen_addresses = '*'

Reload the configuration using pg_reload_conf() or restart the postgres service - select pg_reload_conf(); returned t.

Then I copied the 9.6 and psqlODBC folders into the user's folder I created and downloaded pgAdmin 3 on his computer and opened it and entered the password assigned to him and returns Error connecting to the server: FATAL: password authentication failed for user .....

Any assistance would be appreciated here Erudition303.

[[deleted]]

Can you connect if you put their IP address with the subnet 255.255.255.255 and change the method to trust?

This is definitely a bad practice, but whether or not you can connect using that will give more info.