How to Install PostgreSql in Mac M1/M2 | Configure and Install 2023
HTML-код
- Опубликовано: 2 окт 2024
- In this Video, We're going to see How We Can Download & install PostgreSQL 15 on MAC OS M1/M2 Machines.
Postgresql Website - www.postgresql...
To Download the PostgreSQL Installer URL - postgresapp.co...
After Downloading and Copying the PostgreSQL.app in Applications Folder.
MySQL Commands -
First We Need to Open the Terminal and Write PostgreSQL Config Command - sudo mkdir -p /etc/paths.d &&
echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee /etc/paths.d/postgresapp
Now Close the Terminal. And Open Again
Command to Check Databases - \list
PostgreSQL Command to Create Database - create database database_name;
Use Specific Database - \c database_name;
#postgresql #pgadmin #sql
This was very helpfel! I was struggling a lot before following your tutorial. Very clear instructions, thank you very much!
After 6 hours of agony, I found your video. Thank you!
Welcome 👍🏻
😂😂😂😂same here
Thanks a lot man. Was stuck for hours. After having used EDB installer and brew and what not.
Much Help Thanks a ton
thank you for making this video, very helpful
Your video is very helpful! thank you so much.
Thank you very much!
I was having hard dificulties to install postgres, I tried milion videos, all were bs. you have the best one thanks man
Amazing
Thank you !
While installation it did not create my user database as i can see only 2 database as postgres and template1 and while connecting its giving me error role " " doesn’t exist. can anyone help with this?
what is the difference of this postgres app vs the other downloading method installer??!
Hey I am new to PostGRESQL, Is this better than installing with Homebrew ?
You can also go ahead with Homebrew Installation
@@prashantrana546 I ended up using the app, there are some issues with version 15 as it’s keg only, I thought it might be easier, I just hope it’s easier to administer because if using the app is more limited then I can do brew
Thank you so much though 🙏
how do you connect it with pgAdmin 4 ?
I've directly ran it though mac terminal, pgAdmin I'll create 1 separate video, Stay tuned!
terminal isn't opening for me
This is great. Couldn't be easier. I had no idea this project existed. I was able to get up and running to us PG for Davinci Resolve (my main reason for installing it). I'm gonna try PgAdmin now. Thanks.
What is the default password when first installing Postgres on MacOS Ventura?
And if it has a default password, how do you change it?
In order to use it in the Backend
For most systems, the default Postgres user is postgres and a password is not required for authentication.
unfortunately, PyCharm Pro on my M1 can't talk to Postgres!
Thank you very much for such a straightforward explanation. Very much appreciated!
I did your guide but after running psql it gives me path denied error how to fix that
Can you check is your postman running on port 5432. Using Command -> netstat -an | grep 5432 will tell you if it is listening.
LIFE SAVER. You are brilliant, sir! Thank you.
Thank you so much!!!
Hi, when I select 'Initialize' I am receiving this popup and I am not able to do anything. "Port 5432 is already in use. Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports." Could you please respond to this?
I got this error because of the previously installed postgres using homebrew. In my case, I previously installed version 15 of postgresql. so use this to resolve the error, "brew services stop postgresql@15". It worked!
They changed the command or what !!! 🤣🤣🤣
man, I love you.. seriously I do
Was waiting for your video.
Hope you enjoyed it!
thank you very much, but I have a problem. I copied the code in step 3 and paste it into the terminal, then I closed the terminal just like you showed in your video, but when I want to type "psql" to open the databank , the response is command not found. Can you may help me please .
Can you try using psql -U postures, and make sure your postgresql has been started
Hi Prashant Rana,
I am getting a 'your profile can not be used because it is from a newer version of nw.js' and not able to see the databases as you mentioned in the video. Could you please help me on this?
After Installing and Starting the SQL, rather than doing with existing databases, Could you try creating with a new DB
Hey @@prashantrana546 , Thanks for your reply.
I am only able to create or register servers. I am working with the Databases for the first time, not sure how to make this work.
I have provided commands in the video desc, where you can see commands to create database and further tables in postrgresql
thank you!
very helpful , thank u sir
spasibo
What is the password for my user? I tried with macbook login password. It doesnot work
Bydefault no password is required in postgres while logging into system. If it's prompting can you check, have you earlier installed any versions of postgres. If not then this could be due to the reason that you installed postgres previously from other sources and then tried uninstalling. It did leave postgres user account on your system. Go to user & accounts from system preferences. From there, remove the postgres user account. Now restart and then try installing with brew. This should work.
Thanks for this, Appreciate it
perfect thx!
Thank you, it turned out pretty simple.
SIR WHERE TO WRITE THE SQL COMMAND
On Terminal
So simple. Thanks.
Thanks
thanks mate
I can't connect sql until now
Reason? Any error/exception