Set up a local PostgreSQL Database on macOS
Vložit
- čas přidán 6. 09. 2024
- In this video we look at how easy it is to get a PostgreSQL server running locally on macOS. We step through installing the Postgres App, initializing a user database and connecting to it using the `psql` command.
Download the Postgres Mac App: postgresapp.com/
Find written instruction for setting up a local PostgreSQL Database in Prisma's Data Guide: www.prisma.io/...
Additional Prisma's Data Guide articles for PostgreSQL: www.prisma.io/...
Make interfacing with your data super simple with Prisma's PostgreSQL connector: www.prisma.io/...
Learn more about Prisma:
◭ Website: www.prisma.io
◭ Docs: www.prisma.io/...
◭ Quickstart: www.prisma.io/...
dude 5 hours goes back everyone else's videos more confusing than helping and you help me in 5 min. Thank You!!
I wandered around homebrew installation and error fixes and finally ended up youtube googling and made it in 2 minutes using this video! Thank you very much!
same!
@@jakeorbach1018 I recommend using homebrew this garbage will drastically slow down and even crash your macos at the time.
Same
same here lol
same
You are a godsend. I'm learning this for the first time and this is like learning Chinese as a second language
Immensely helpful, and much more simpler to set up than the homebrew version!
Thanks for this, I've just spent a painful day trying to install postgres using brew. It's a real nightmare on a mac, I've installed it a few times on Linux with no issue, but on a mac on commandline is proper torture. This way is by far the easiest
Life saver. I love this guy, as well as his Supabase videos.
Thank you :) Nice and quick tutorial.Used postgres for the first time and managed to establish a server for my confluence web app from the first try.
Thank you for saving me from some insane frustration (I'm an absolute PostgreSQL newbie)
Lifesaver - I have been getting so many issues with Postgres today
Thank you very much for this video, i have suffaring for a week, but you safed myself. thanks and so many thanks. may Lord bless you!
This is the best video so far! Keep it up my guy! subscribed
Thank you for this tutorial and your concise explaination ;)
so i botched this a bit with a homebrew install n, have tried 'starting over' (uninstalling efforts) n installing it this way and it works, except instead of initialize i just get a start/stop (server) n therefore, provides no default databases. I think its still aligning itself with my mac userprofile rather than its default of empty strings (user and password). any suggestions! :(
Me too the same happened with me, homebrew PostgreSQL installation sucks!
Thanks so much for your nice and clear explanation
how are you getting the suggestions in terminal , can you tell us please
how can i create a new db? is there any way to that using this app?
Thank you man I was getting mad at this stuff ❤
nossa, eu tava quase desistindo da vida! obrigado
Thank you whole heartedly, brother. live long, grow more
Thank you too
Thanks for the tutorial. But I'm facing an issue, my server is running but from pgAdmin I cannot see nay server. How can I resolve it.
I can't see the icons "jon", "postgres" and "template 1" when I open the app. what could be the problem?
Hey! thanks for the video. When I put the sudo on the terminal of my computer, I then get to put my password but it appears a locker symbol and I'm unable to write my password. Do you know how to fix it? thanks in advance
i know its late, but try typing the password and press enter, normally for passwords on terminal, you can't see what you have typed, but it does take an input
Goodnight! How to allow port 5432 for MAC to work as a server?
hi, I'm getting an access denial message while accessing other directory from home, how to resolve this?
I don't understand which password we should type in Terminal?
same here!!!!
Use your user login password, the one you type in the welcome screen :)
your pc password
Thank you so much! This is so helpful
Hey Prima, just a question i run postgress as you well described in your video but in my mac i see 3 different db> 1) postgress, 2)myname 3)template1. How can i see what there is inside template 1?
I dont really know but don't worry about it! And do not delete them either!
what terminal do you use? I'm curious about the autocomplete 🤔
same here
Thank you!
What terminal were you using for autocomplete and syntax highlighting?
dont you need to put something in DATABASE_URL=""
thanks
nice tutorial buddy thank!
zsh: command not found: psql, why can u help me, please?
great video! thank you
Many thanks!
thank you so much
How can we connect postgres app to pgadmin?
I've spent too long try to install mysql on my mac. Postgres took me less than 3 mins.
Hi
How do I reboot the terminal?
Amazing. Thanks so much!!!
thank you !!! top quality content
thank you! it is top-quality content!
how mack your terminal autocomplete patch?????????????????????
How to reload terminal?
close it, and reopen it
greate and simple
Thanks that helped
can we use it with pgadmin?
thank you
thanks!
Are you from Boston?
Why aren't anyone showing how to download with first option? That's easiest and no need to do anything on configuring etc
As far as I know, it's harder to manage updates etc.
pls what password are we typing on the terminal ??
is the password of your OS User
Thank you
You're welcome 😊
On point bby. luv
Postgresql documentation to set up DB is pathetic and seriously needs to be upgraded its a mess!
спасибо за русские субтитры хорошему человеку and thanks for the video
whats the password
how to delete the database
Hello there! You can find more information on how to create and delete databases and tables in PostgreSQL in our Prisma Data Guide - see here:
www.prisma.io/dataguide/postgresql/create-and-delete-databases-and-tables
horosh
Thank you!
You're welcome!
thank you
Thank you!!
Thank a lot!