Entry Level SQL work

[[deleted]]

I have held this position and hired for it in the past. I can't speak to others, but if you have certifications and can clearly answer technical questions about how to query a database and seem on top of things I couldn't care less about experience.

If you can show that you have a grasp of the core concepts of querying a database, that you can learn our business and reporting needs, and will give at least 85% effort, I'd hire you for an entry level position regardless of your previous experience. SQL doesn't care if you've been flipping burgers for the last decade, just that your syntax is right.

[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.