How to INSTALL PostgreSQL for learning and practicing SQL (works w/ any OS: Mac, Windows or Ubuntu)

[@srsr6099]

Awesome, much needed, much awaited. Thanks

[@datatomi]

Thanks!!

[@pjr_racing]

Great video. Thank you for sharing

[@datatomi]

Thank you! 🫡

[@cyprian1234]

I did everything what you did Tomi and when I try to connect to the server there comes an error "Connection to XXX.XX.XXX.XX:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections."

[@datatomi]

Hey, no worries! This is not an unprecedented issue! And there is a fix for it. This error means that you forgot to run on of these lines from the tutorial (or, you ran them but made a typo): - echo "listen_addresses = '*'" >> /etc/postgresql/*/main/postgresql.conf OR - echo 'host all all 0.0.0.0/0 md5' >> /etc/postgresql/*/main/pg_hba.conf FIX: STEP #1 Let's figure out what's wrong! First, go back to root user. Type this: sudo -i -u root And now type: history This prints all the commands you typed in so far as the root user… You'll see your command history. Again, you are looking for these two commands: echo "listen_addresses = '*'" >> /etc/postgresql/*/main/postgresql.conf AND/OR echo 'host all all 0.0.0.0/0 md5' >> /etc/postgresql/*/main/pg_hba.conf STEP #2 If either one is missing, just rerun it! If both are missing, rerun both! If you see them and you found that you made a typo in one (or both) of them, then... well, first of all, don't worry, this is one of the most typical mistakes; other participants made it too. Secondly, unfortunately, it's kind of difficult to fix it yourself (it's possible via editing the config files -- you can do that, I've just seen that beginners are not comfortable with that which is totally understandable), so you can really do one thing right now... It's something that students usually don't like -- regardless, I encourage you to go with this one because from a learning perspective that's the most useful for you. This is: destroy your current server and try to set up a new one from scratch. If you choose this option, put an extra emphasis on making sure that you avoid any typos and that you follow the tutorial very thoroughly. Remember, a single mistyped character can cause an issue. But if you type in everything accurately, the server will work. Cheers!

[@cyprian1234]

@@datatomi thank you very much! It works just fine now. 👌

[@datatomi]

@@cyprian1234 Awesome!

[@leeonallen1940]

On SQL WORKBENCH my passwd does not work get error FATAL password authentication failed for user how do you reset passwd I only create one passwd same as Digital Ocean

[@jameslarson8640]

a year late but ran into the same issues realized my caps lock was on when I created the password originally. for anyone else following this I would check that

[@mohammadmujtaba7491]

It's charging 13.3 dollars for signup , isn't that free?

[@denisvenancekatonkola3777]

Nice tutorial Mr. Tomi but would you help me I want to know how to Reset Root Password(Superuser) of Postgres Advanced server 10 on CentOs? I forgot it but I was set it during the Installation process.

[@datatomi]

Thanks Dennice -- I'm happy to help with the setup, I show in this video -- but unfortunately I don't know too much about CentOs. ¯\_(ツ)_/¯ Should be pretty simple if you use DO, though. Bug again, I've never worked with that environement. Sorry... :-/