![]() This will bring up a dialog where I can give the server a meaningful name. I'm now going to connect my pgAdmin tool to the PostgreSQL server and I do this by clicking on "Add new server". At this point, I have the PostgreSQL server running and I have the pgAdmin tool opened up. So that's exactly what I'm going to do here. Now if you set a master password on pgAdmin 4, this will allow you to access all of the databases et cetera on PostgreSQL with just a single password. Double click on "pgAdmin 4" so that you bring up the development platform that we are going to use. And now if you open up the application folder, you should find pgAdmin 4 there along with the PostgresSQL server. This should bring up a little window allowing you to drag pgAdmin 4 to your applications folder and this will actually install this on your mac local machine. Make sure you accept the terms and conditions and set this up. This will bring up a little wizard that you can use to install pgAdmin 4. Once the download has completed successfully, go ahead and open up this DMG file. I am of course working on macOS, so I click through and here on this page I find the DMG file that will allow me to get set up with pgAdmin for 6.18. You might find a newer version available when you record. I'm going to head over to /ftppgadminpg4 and get the latest release of the tool. Now with our server up and running, let's head over and install the pgAdmin development and administration tool for Postgres. If you click on server settings, you'll be able to see configuration details for this particular server version 15 and you can see the data directory config files, log files where exactly these are located on your machine. The loonycon database and the postgres database. Postgres has also set up a few databases for me to use. And once this is done in a few seconds, you find that PostgreSQL 15 is now running and available on port 5432. For this, I'm going to head over and click on the "Initialize" button that you should see in the top right corner. If you now notice the top left hand corner, I have the PostgreSQL server installed and it will run on port 5432. Let's double click on this and this will open up your PostgreSQL server. Once this is complete, you should be able to head over to the applications directory using your finder window and you should find Postgres right there. This will bring up a little window that will allow me to drag postgres into the applications folder and this will actually install postgres on my local mac machine. Once the download is complete, I'm going to open up this DMG file. I'm going to go ahead and download the DMG file onto my local machine. Right here on this page, I see the latest version of PostgreSQL at the time of this recording, PostgreSQL 15. Here you'll be able to access and download the installer for PostgreSQL. Now, the easiest way to get set up with PostgreSQL on a mac is to head over to /downloads.html. If you want to know how to get set up on Windows, I suggest you move on to the next movie in this chapter. In this movie, I'll show you how you can get set up with these for a mac machine. Now, in order to work with PostgreSQL, you need to install the PostgreSQL server and pgAdmin 4, the development and administration platform that allows you to connect to the server, run queries and perform a bunch of other operations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |