Set up a local PostgreSQL Database on macOS

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/...

[@kookookachooifcate]

dude 5 hours goes back everyone else's videos more confusing than helping and you help me in 5 min. Thank You!!

[@usufdev]

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!

[@jakeorbach1018]

same!

[@yoshiinatuki]

@@jakeorbach1018 I recommend using homebrew this garbage will drastically slow down and even crash your macos at the time.

[@letcodeitnow]

Same

[@radhotorn05]

same here lol

[@user-lo9ob3lf9s]

same

[@adalbertpayan811]

You are a godsend. I'm learning this for the first time and this is like learning Chinese as a second language

[@_Ani_]

Immensely helpful, and much more simpler to set up than the homebrew version!

[@iFunktion]

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

[@dexvt1862]

Life saver. I love this guy, as well as his Supabase videos.

[@MsSWAGboss]

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.

[@ozzyfromspace]

Thank you for saving me from some insane frustration (I'm an absolute PostgreSQL newbie)

[@PeaceChiillax]

Lifesaver - I have been getting so many issues with Postgres today

[@rogerionhamahango3536]

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!

[@steec3100]

This is the best video so far! Keep it up my guy! subscribed

[@m_a_d_h_u_r_a]

Thank you for this tutorial and your concise explaination ;)

[@greenie62]

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! :(

[@usufdev]

Me too the same happened with me, homebrew PostgreSQL installation sucks!

[@saman6199]

Thanks so much for your nice and clear explanation

[@user-pk5pw5pz6v]

how are you getting the suggestions in terminal , can you tell us please

[@RayanA-gl7ox]

how can i create a new db? is there any way to that using this app?

[@Eazy._E]

Thank you man I was getting mad at this stuff ❤

[@maxwellgomess]

nossa, eu tava quase desistindo da vida! obrigado

[@sachinkakade8735]

Thank you whole heartedly, brother. live long, grow more

[@PrismaData]

Thank you too

[@nahidparvez7346]

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.

[@pearsonrangani2691]

I can't see the icons "jon", "postgres" and "template 1" when I open the app. what could be the problem?

[@lr4187]

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

[@ruchimankar4336]

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

[@julianobandeiradefreitas5672]

Goodnight! How to allow port 5432 for MAC to work as a server?

[@rajeevgupta4058]

hi, I'm getting an access denial message while accessing other directory from home, how to resolve this?

[@alinachurikova7491]

I don't understand which password we should type in Terminal?

[@ikechukwuemechebe9578]

same here!!!!

[@samtakahashi5602]

Use your user login password, the one you type in the welcome screen :)

[@jahanzebawan1396]

your pc password

[@mpcrockett]

Thank you so much! This is so helpful

[@apocalypseb7x]

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?

[@adrianmin713]

I dont really know but don't worry about it! And do not delete them either!

[@estebanperez4755]

what terminal do you use? I'm curious about the autocomplete 🤔

[@johncarlojoyo3847]

same here

[@faruzzy]

Thank you!

[@huskyzinFPS]

What terminal were you using for autocomplete and syntax highlighting?

[@netanelkaye3014]

dont you need to put something in DATABASE_URL=""

[@matinaminsabouri]

thanks

[@emrekaplan742]

nice tutorial buddy thank!

[@nfsgh4665]

zsh: command not found: psql, why can u help me, please?

[@timothykoar6265]

great video! thank you

[@SileLence]

Many thanks!

[@geminicoding]

thank you so much

[@omgmaw]

How can we connect postgres app to pgadmin?

[@nuitech2190]

I've spent too long try to install mysql on my mac. Postgres took me less than 3 mins.

[@johnefezokhaeakaswagger1676]

Hi
How do I reboot the terminal?

[@user-nm2ho1vn7w]

Amazing. Thanks so much!!!

[@kischamp]

thank you !!! top quality content

[@apayrus]

thank you! it is top-quality content!

[@haydermajli804]

how mack your terminal autocomplete patch?????????????????????

[@rezakhalafi528]

How to reload terminal?

[@alekseirutkovskii2570]

close it, and reopen it

[@nooruldeenqader6061]

greate and simple

[@kamil_supabase_enjoyer]

[@boldschool6308]

Thanks that helped

[@AmeerHamza-cy6km]

can we use it with pgadmin?

[@codigosimple1989]

thank you

[@monixmmm]

thanks!

[@alexbritoofficial1608]

Are you from Boston?

[@girizh11]

Why aren't anyone showing how to download with first option? That's easiest and no need to do anything on configuring etc

[@lavgup]

As far as I know, it's harder to manage updates etc.

[@ikechukwuemechebe9578]

pls what password are we typing on the terminal ??

[@camilinbajista]

is the password of your OS User

[@natikgr3262]

Thank you

[@PrismaData]

You're welcome 😊

[@thoseoldcolors]

On point bby. luv

[@shansiddiqui4741]

Postgresql documentation to set up DB is pathetic and seriously needs to be upgraded its a mess!

[@inuhu5547]

спасибо за русские субтитры хорошему человеку and thanks for the video

[@ankitakakade2192]

whats the password

[@alihusham1560]

how to delete the database

[@PrismaData]

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

[@shyngyssatkan9188]

horosh

[@frosty_alpaca8491]

Thank you!

[@PrismaData]

You're welcome!

[@tharseinoo]

thank you

[@nishasreedharan4965]

Thank you!!

[@jaimeviloriogreen]

Thank a lot!