Install PostgreSQL

In order to use Artisan, you’ll need to download PostgreSQL. This program allows CerTek to perform routine maintenance on Artisan. 

Head to postgresql.org and click on “Download.”

Click on your operating system (for this example, we’re using a Windows computer, so we’ll click on the Windows icon). 

Click on “Download the installer.”

Navigate to the column in the table that has your operating system–in this example, it is Windows x86-64. If you’re not sure how to find your operating system, click here. Click the download icon for the most recent version. If your Windows computer has a 32-bit operating system, for instance, download version 10.20.

 

The PostgreSQL installer will start downloading.

A pop-up window will ask if you want the program to make changes to your computer. Select “yes.”

Click “Next” on the PostgreSQL Setup Wizard.

PostgreSQL already created an installation folder for you in your Program Files section, so in most cases, you won’t have to change where PostgreSQL will be installed on your computer. If you want to change where PostgreSQL will be installed, click on the folder button and select a new location. 

 

Otherwise, click “Next.

Leave the components checked, except for the Stack Builder. Hit “Next.”

Now, you’ll need to select where your data will be stored. PostgreSQL automatically created a data folder for you, but if you want to change where that data will be stored, click on the folder button. Otherwise, click “Next.”

Create a password to use to sign into PostgreSQL. Keep this password somewhere secure. Once you’re finished, click “Next.”

 

The installation wizard will automatically select what is known as a “port number.” The server “listens” to this port number. The default port number is normally 5432. You can change this number if necessary. Click “Next” when finished.

Leave the locale set to default, then click “Next.”

The installation wizard will show you a pre-installation summary. Click “Next.”

PostgreSQL is now ready to be installed. Click “Next.”

PostgreSQL will begin installing.

Next, you’ll need to configure some more settings. Type “Services” into your Windows Search bar and click on the search result.

Scroll down to “postgresql.”

Right-click and select “Properties.”

Click on the “Recovery” tab.

Make sure these first few fields are set to “Restart the Service” instead of “Take No Action.”

Click “Apply” and “OK.