![]() ![]() PGDIR – this is the base directory for the PostgreSQL setup.PATH – this is our Windows path and we need the correct version of PostgreSQL to be first in the path.As long as these are set properly, it will start up fine: Background – what we needīefore we run PostgreSQL (any version), we need to set a few environment variables that the executable requires. Good – we now need to prepare some more things so that we can launch PostgreSQL. I prefer to just cut and move all the files up one level so that the folders (bin, doc, include, etc.) are directly under d:\stack\pg-12.5 and then I delete the now empty pgsql folder. You can now extract the files from the archive that you downloaded into the pg-12.5 – when you do that, you will probably get another folder called pgsql and that will actually hold the rest of the folders (bin, doc, include, etc.). PostgreSQL 12.5 folder: d:\stack\pg-12.5 (avoid spaces in these directory names if you can).Let’s assume that we now have something like: Before you proceed, I would like to recommend that you set the folder to compress contents to save disk space as explained in ‘Before we get started’ on this other post since it can save you quite a bit of space over time. In my case then the base folder becomes d:\stack and I add things there. For such usage, I created a folder called stack where I store different parts of the stacks that I want to play with. Next, we need to create a place where we will unzip and store the binary files. Let’s assume that it’s in your downloads folder. Grab the version of the PostgreSQL database that you want – I picked version 12.5 since I want to try something on that. However, we don’t want the bbinary – so, we head on to the page that hosts the ZIP archive instead. The main page for downloads sends you off to the page for Windows downloads which points you to the installer from EDB. ![]() Download the packageįirst, we need to download PostgreSQL. You should treat this only as a personal development server and not for sharing or deployment, etc. On the other hand, if you’re someone who uses PostgreSQL only some times and do not want it running all the time, or if you want to use different versions and want to have them switched on from time to time, or if you just want a portable setup that you can copy to any computer and get it running, then this post is for you. It will also set up services and other things that you might need. It’s easy and will do all the necessary things that you need for it. The normal method for using PostgreSQL on your Windows machine is to download the installer and then set it up. on | PostgreSQL | Programming | Windows 10 | Remember | Portable setup for PostgreSQL on Windows.The next post in the series will be how to install and use PostGIS with Postgres via pgAdmin 4.Ĭlick here for more tutorials related to PostgreSQL. Using pgAdmin 4, you can now explore your PostgreSQL server that hosts your database.For Windows computers, you will need to create a password for this default user (remember to keep the password). For PostgreSQL servers, there are always a default user called “postgres”. It will named something like PostgreSQL 9.6. On the left hand Browser, click the + next to Servers, and it will show the server. There will be a default PostgreSQL server on your system.pgAdmin 4 may take some time to launch, and when it does, it will look something like:.When it’s done installing, you can select Launch pgAdmin 4 and Finish.I keep it in the default/suggested folder. It will then ask where you want to save your program files for pgAdmin 4.The wizard will then ask you to read over the license agreement.Part 2: How to Install pgAdmin 4 for Windows 10 You can read more about it at the pgAdmin website. It is an alternative to the terminal or pSQL console. PgAdmin 4 is graphical interface for interacting with PostgreSQL databases. This tutorial leaves off from Part 1: How to Install PostgreSQL on Windows 10. This is the second in the series, and this is on how to install pgAdmin 4 for Windows 10. Note: I also use Windows 10 and hosted my Postgres database on Digital Ocean, so I will be covering all the tricky parts I ran into! ![]() For one of my apps, I was responsible for the database, and there were some tricky things with Postgres! This post is part of a tutorial series on how to use Postgres! ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |