How to install PostgreSQL on Mac OS | Install and Uninstall PostgreSQL Database
Вставка
- Опубліковано 14 лис 2020
- This video is about how to install PostgreSQL database, doing the initial setup of the PostgreSQL
and then also explains how to uninstall PostgreSQL database on macOS Big Sur.
This video also covers how to install pgAdmin and how to uninstall pgAdmin from macOS Big Sur.
In this video, I cover PostgreSQL installation using the Interactive installer by EDB and also by Postgres.app
Also cover the uninstallation of PostgreSQL database using both the Interactive installer by EDB and also by Postgres.app
We go step by step from scratch to complete installation, setup and uninstallation of PostgreSQL.
We also create a sample database and table using pgAdmin and then insert data to this table in pgAdmin.
We look at the error's caused in Postgres 13.1 version when trying to install through the Interactive installer by EDB method.
This video covers the following:
1) Install PostgreSQL using the Interactive installer by EDB method.
2) Setup pgAdmin which is installed as part of the EDB installer.
3) Create sample database and table to test pgAdmin.
4) Uninstall PostgreSQL using the uninstaller package provided by the EDB installer.
5) Install PostgreSQL using Postgres.app method.
6) Initialise database and setup command line path for PostgreSQL database.
7) Install pgAdmin.
8) Uninstall PostgreSQL database using uninstallation steps provided by Postgres.app
Mentioned below are the links mentioned in video:
PostgreSQL:
www.postgresql.org/
pgAdmin:
www.pgadmin.org/
Learn What is Database & Different types of Database (for beginners):
• Learn What is Database...
I hope the video was useful. Please like, subscribe and comment any queries or issues you may have faced during your PostgreSQL installation.
Thank you and stay tuned for more SQL, Database and other tech video's on this channel.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
✅ Git and GitHub Tutorial:
• Git and GitHub
✅ Data Analytics Projects:
• Data Analytics Projects
THANK YOU,
Thoufiq
You're a lifesaver!!!!
Thank you ever sooo much
Thank you so much for your kind words..
So glad it helped🙂
If you can not install it on your own by reading the docs I'd recommend you change the careers.
Being a naive, yet very easy to understand. You make a great tutor. Keep up your good work.
Thank you ☺️
This video just gave me real peace since my mac kept failing to open PostgreSQL after upgrading to Big Sur. I finally open it and it works fine.
Awesome... glad the video helped..
Thanks for your comment..
Very informative and helpful. Would love to see more such videos. 👌🏻
Thank you Rafiya... 😀
Never used PostgreSQL DB. But really loved the video & enjoyed learning something new👍🏻 Kuddos👏🏻 Keep up the good work brother🙌🏻
Thank you Shahil..
It’s one of the most widely used RDBMS today and is gaining more popularity everyday so no harm in learning this 😀
Thank you for liking it..
Thanks a lot for such a detailed explanation, its very useful. Thanks once again.
Your welcome Neha :)
Thanks much! It is really helpful for me (beginner in PostgreSQL).
Your welcome Yee Win ,
Glad this helped
I needed this so much! thank you !!
Your welcome 🙏🏼
Glad this helped ..
Your video was really helpful. Thanks!
Thank you 🙏🏼
So glad it helped you 🙂
Fantastic guide, thank you!
Thank you for the feedback ☺️
Much appreciated
your explantion is awesome...its worth..
hey firstly, thanks a lot i want to ask that i m learning from stratch is these 18 videos playlist is enough to learn basic sql?
Nicely explained 👌👌 perfect
Thank you Sheeba 😀
Thank you TFQ, can you provide the database in order to follow you?
hello I tried everything but the only buttons showing on my poster sql interface is sql and property only
Hi! Thanks for the video)
Your welcome 🙏🏼
Nice video, enjoyed it. Please keep them coming. I forgot my PostgreSQL user password, please share if you know the best way to reset it. Thank you!
I am trying to uninstall my postgresql but I think while moving the folder, I lost the postgresql uninstaller. Now when I trying to delete the bin and data directories, its given me an error that these files are in use in some program.
Kindly help me to uninstall it completely.
After installing and opening I cannot see any database when I click on the server. How to fix it?
Great help sir
you are awesome thank you for saving my time :)
Your welcome 🙏🏼 i am glad this helped
Hi , iam new learner to the SQL and i started few days ago but in my postgresql query was successfully executed but nothing was displayed in the data output I mean as shown above after successful execution the output in the format table filled with the stedends data so please could you help me out from this issue
Cool . Informative
Thank you 😊
could please tell me how to import the SQL file to postgre
Thank you ever so much :)
Your welcome 🙏🏼
Any Windows version or only MacOS guide?
trying to install in windows...i am not getting option to create password while installation..but after installation i am resetting the password..tere its is asking one more password....server connection also lost....how to create server connection if we reset master password? how to create password for server?
Sir why enter current date in value insertion?
Is it same for windows also ?
Text is not there in the database where I have to find that
Excellent
Thank you Thoufiq for this tutorial 👍 🙌 15:18 Can you explain how to change Owner database for default "postgres" please ? 🙏
FIND IT 😅 : I created the postgres Superuser : CREATE USER postgres SUPERUSER; then : CREATE DATABASE postgres WITH OWNER postgres; With command \du you can see all users. I quit my terminal and come back with : psql -U postgres VOILA 🥳
Awesome chenda 👌
Glad you found the solution
Hi , Thank u for the video .. i have one question ... how to re-attach panel actually in my system i was trying fetch sql query and accidentally panel got detach but there is no option to attclach it back to editor. When i try to run its showing “stay or leave on the page” . Not able to execute my query. Please answer this ASAP.
Hi.. your welcome..
I believe you want your pg admin layout to be as it was in the beginning right?
If so go to File -> Reset Layout
This should do it..
Also after the reset you can click File -> Lock layout -> prevent Docking to avoid such issues in future..
@@techTFQ Thank you very much.
So apparently the error has something to do with te processor of the mac, if you open the finder and search for the app, in the option Get Info you just activate the "run with rosetta", it will eliminate the error opening PgAdmin.
its not working
How to set a password postgresql and pgadmin in macos please help
After installing ..it is still asking to install again and again. Can u help me out please.
God bless, you saved me
Thank you for the feedback...
So glad it helped 🙂...
First thanks for making this video sir ! very informative, in my laptop query executed but in data out nothing was displayed it's blank plz help me out of this issue sir
very helpfull.
Thank you Anurag 🙏🏼
Can someone copy paste the Table script he used? I'm getting a syntax error and I want to see where my mistake is
sir why is postgre SQL is better than other SQL IDE,
Toufic sir make a PostgreSQL tutorial on the command line because if you make a command line tutorial for Postgresql it lot's of help for a beginner how we can use Postgres use into command line
please make a video about how to use psql using terminal command line tools
Hi, haven’t planned this for now but will surely consider making a video abt it in near future
Have you create how to install postgreSQL on windows sir ?
Hi. I installed Postgresql as per the instructions in your video. but when i try to open the PG admin4, its showing fatal error indicating the server could not be contacted. kindly help me in this
i had the same problem how did rou resolve?
The current_date in the Dob column isn't working
Hey man can you also make a video of removing and resetting the password?
i have an error while installing postgreSQL on my laptop,it windows
Thank you...
Followed the process to uninstall but can still see the user: PostgreSQL at the login. So it's not a complete uninstallation. I deleted it by going to Mac Settings>users. Not sure if this is enough.
Please make a video to access PostgreSQL from Python. Thank you!
Thank you for the feedback..
Yes generally any database uninstallation involves some steps to delete files manually.. I believe I covered all of these steps in the video..
You can also refer to the uninstallation instruction given by PostgreSQL (link in description)
Hopefully it should clarify any of you doubts
Thank you Thoufiq Mohammed
Your welcome Dileep 🙂😃.. I hope it was helpful..
Helpful
Thank you 😊
Please add link for query
I just installed PostgreSQL but it says "A non-fatal error occur whilst creating menu shortcuts.". What should I do?
And it says "Problem running post-install step. Installation may not complete correctly. Failed to start the database server.".
hi u make great videos but have just 1 request, can u plz zoom in your commands and screen in query tool so its easier for us to read. thnks from germany...
i had the same mistake with the (13.1 version)
Are you also using Mac OS Big Sur?
I imagined the issue to be due to Mac OS Big Sur and not with Postrges..
Pg admin fatal error why??
I am on Apple Silicon M1 and I get the following error.
A non-fatal error occur whilst creating menu shortcuts.
problem running post-install step. installation may not complete correctly the database cluster.
I tried installing different versions of Postgre but getting the same error.
Can you help ?
Hi,
Which type of installation have you chosen?
Is it the interactive installer by EDB or Postgres.app or Homebrew?
I think EDB might give some issues sometime for some version and generally the Postgres.app sure work fine.
Can you try Postgres.app
@@techTFQ I tried EDB first, it failed. Then I tried postgres.app, it succeded. But after installing pgadmin 4, the server doesn't show up
Have you initialized the server as mentioned in the website?
@@techTFQ yes, as you showed on the video. Server was initialized correctly. I can see 3 server names including postgres
Ok, I had faced something like this long back and I remember I just uninstalled Postgres and PgAdmin and then re installed it again and it worked fine..
Can you try that
Thank yyyyoooouuu!!!! So helpful..
i used the first method but when i login to pg admin it show me this error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "postgres"
why? How to solve it?
Your welcome 🙏🏼
I think the error is due to incorrect password.. password should be the same which you entered during installation..
@@techTFQ am sure it correct and i try to reset new password but it still this error appears. can you help me? :(
Hi,
I think you installed using the EDB method but I’ve seen some issue in it faced by some other people as well so can you uninstall this and then try to re-install using the Postgres.app method .. I think this will work
@@techTFQ thank you a looooooot
my mistake was ther chick box i didnt check it when they want me enter the password :)
Ok 👍 glad it finally worked 😊
Your Video is awesome. Could you please share me the query. Notebook as well. thanks!
I just started learning SQL Today ( from a non tech finance background ). Started with your SQL Playlist. This is the second video. Having too much difficulty understanding . All the commands etc , only someone who already knows SQL can understand. What command,how did you arrive at . No explanation of the whole PGADMIN app. Straight deepdive into complex SQL Commands which went above my head. Too hard to understand. Is there extended version of SQL basic explanation video ?
help ):
connection to server at 'localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "postgres"
i get this error when i try to open the server ?
were you able to solve this problem? i'm in the same situation right now(
anyone know how to solve this problem
Hello sir, Do you handle any Online, Live
/ offline classes?
I might start something next month. It will be announced on LinkedIn
pgadmin is not responding,it giving a fatal error
getting error -> ERROR: syntax error at or near "Varchar"
LINE 4: First Name Varchar (100) Not Null,
Nice
Thank you 😊
good video
Glad you enjoyed
Easily Explained.
Thank you
Pg admin is not asking password when opened what to do?
Im also facing the same did u get it
username and password is what
top
Thanks:)
kindly provide practices set
What practice set