TubeSock

Programming

Databases – Practical PostgreSQL – The pg_hba.conf file

Databases – Practical PostgreSQL – The pg_hba.conf file

Source: Databases – Practical PostgreSQL – The pg_hba.conf file

I recently had a job to do in which I was required to connect to a Postgresql server and run some queries to find some critical data for the team. I wasn’t provided with a logon or any other information about the tables or schema.

Well thank goodness for my old friend google or I wouldn’t have stood a chance against this problem.

What I learned is that without some modifications to a conf file, you will never, ever connect to a database remotely. You may have success connecting from the command line and might be wondering why you can login to the postgres console, but the exact same creds are failing constantly when trying to connect any other way.

Turns out remote connections require the connection mode to be set to ident or trust to either identify or allow the connection based on the user connection manner and credentials used. Without this knowledge you can easily spend a lot of time troubleshooting something that is actually very straight forward.

I didn’t completely understand the issue until I actually setup and installed Postgresql for myself on my vmware homelab.

These two sources were indispensable in my training:

Digital Ocean:

https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-centos-7

https://www.digitalocean.com/community/tutorials/how-to-use-roles-and-manage-grant-permissions-in-postgresql-on-a-vps–2

Godaddy

https://www.godaddy.com/garage/tech/config/how-to-install-postgresql-on-centos-7/

Once I actually set everything up for myself the first it all made a lot more sense. I was able to try all the different scenarios without the fear of breaking production. All in all this was a great learning experience.

These articles are for setting up Postgresql on Centos 7 but there are many other articles out there with similar information for debian or earlier releases.

So get up in them guts and have a poke. I hope you go mildly insane with your new found sql query power.

Categories: Computers, Management, Personal Development, Programming, Security, Technology

Blow my mind

html5 javascript, learn html css, learn html5 online – Microsoft Virtual Academy

Learn HTML5 online with our free course, which also teaches JavaScript and CSS3. Deepen your knowledge with training led by experts in the industry.

Source: html5 javascript, learn html css, learn html5 online – Microsoft Virtual Academy

I can’t believe how good this introduction course on Web development was. (html, css, javascript) The best part about it was the price, FREE!

I had recently completed the javascript and jquery courses in codeacademy and thought I would try to find some intermediate exercises to take it to the next level. That’s when I came across the Microsoft 70-480 exam and popped open the link to the self-guided training for the course. I didn’t expect much out of free videos from Microsoft but in honesty it felt like I was attending an expensive workshop.

The modules are pretty short. Usually around 20 minutes and nothing over 30. The presenters are some of the best in the field and are celebrities if you follow certain circles.

I had no idea that all apps built for the Microsoft Store will use these simple languages. I’m not necessarily a big MS fanboy, but you can see why they are so successfully in their strategy. They empower the workforce to use their tools and win market dominance because of it.

I had fun.

Microsoft also offers a complete beginner’s course here:

https://mva.microsoft.com/en-us/training-courses/html5-css3-fundamentals-development-for-absolute-beginners-14207?l=Y4COscFfB_7500115888

https://mva.microsoft.com/en-us/training-courses/javascript-fundamentals-for-absolute-beginners-14194?l=DmF3TY1eB_9500115888

And an advanced app store course here:

https://mva.microsoft.com/en-US/training-courses/advanced-windows-store-app-development-with-html5-jump-start-14249?l=dXXzxyRfB_4800115888

Categories: Computers, Linguistics, Personal Development, Programming, Technology, Web

Blow my mind