{"id":6485,"date":"2021-09-27T15:08:24","date_gmt":"2021-09-27T19:08:24","guid":{"rendered":"https:\/\/certek.com\/kb4\/?p=6485"},"modified":"2025-03-03T16:22:22","modified_gmt":"2025-03-03T21:22:22","slug":"install-postgresql","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/install-postgresql\/","title":{"rendered":"Install PostgreSQL"},"content":{"rendered":"\n

In order to use Artisan POS, you’ll need to download and install a program called PostgreSQL, which holds the data for Artisan. Normally, a support technician from CerTek or your dealer will do this for you.<\/p>\n

PostgreSQL only needs to be installed on one computer in your network, which we’ll call “the server” or “the main”. Often this will be your main “register” (sales computer). It doesn’t need to have a server operating system.<\/p>\n

Head to postgresql.org<\/strong><\/a> and click on “Download<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Click on your operating system (for this example, we’re using a Windows computer, so we’ll click on the Windows icon).\u00a0<\/p>\n

\"\"<\/a><\/p>\n

Click on “Download the installer<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Navigate to the column in the table that has your operating system–in this example, it’s Windows x86-64. If you’re not sure how to find your operating system, click here.<\/a><\/strong><\/p>\n

We currently recommend PostgreSQL version 16.<\/strong> [Last updated Mar 3, 2025.]<\/p>\n

NOTE: If you’ll be using Remote Operation, every site and remote laptop must use the\u00a0same<\/strong><\/em> version<\/em> of PostgreSQL.<\/p>\n

The examples below all show version 15, but apply to other versions as well.<\/em><\/strong><\/p>\n

Click the download icon for the desired version number and operating system.\u00a0<\/strong><\/p>\n

\"\"<\/a><\/p>\n

\u00a0<\/p>\n

The PostgreSQL installer will start downloading.<\/p>\n

A pop-up window will ask if you want the program to make changes to your computer. Select “yes<\/strong>.”<\/p>\n

Click “Next<\/strong>” on the PostgreSQL Setup Wizard.<\/p>\n

\"\"<\/a><\/p>\n

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.\u00a0<\/p>\n

\"\"<\/a><\/p>\n

\u00a0<\/p>\n

Otherwise, click “Next.<\/strong>“<\/p>\n

\"\"<\/a><\/p>\n

The installer will ask you to select the components to install. Select only<\/strong> PostgreSQL Server and Command Line Tools. Hit “Next<\/strong>.”<\/p>\n

[TODO: Update picture to un-check pgAdmin.]<\/p>\n

\"\"<\/a><\/p>\n

Now, you’ll need to select where your data will be stored. PostgreSQL will automatically create 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<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Create a password to use to sign into PostgreSQL. Keep this password somewhere secure.<\/strong> Once you’re finished, click “Next<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

\u00a0<\/p>\n

The installation wizard will automatically select what is known as a “port number<\/strong>.” The server “listens<\/strong>” to this port number. The default will be 5432, but change it<\/strong> to whatever port number you want to use. Our convention is to use port number = PostgreSQL version + 5420<\/strong> (the “major” part of the version number only). Click “Next<\/strong>” when finished.<\/p>\n

\"\"<\/a><\/p>\n

Leave the locale set to default, then click “Next<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

The installation wizard will show you a pre-installation summary. Click “Next<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

PostgreSQL is now ready to be installed. Click “Next<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

PostgreSQL will begin installing.<\/p>\n

\"\"<\/a><\/p>\n

Once you have PostgreSQL installed, you will need to allow it to accept incoming connections through your firewall. On Windows, this will be in the settings for Windows Defender Firewall or whatever third-party firewall software you’re using.<\/p>\n

There are a number of ways to get to the Allowed apps screen for Windows Defender Firewall. An easy way is to click in the Windows Search Box and type “Allow” as shown in the image.<\/p>\n

\"\"<\/a><\/p>\n

Choose the program from your results list.<\/p>\n

\"\"<\/a><\/p>\n

In the Allowed apps screen, if you don’t see PostgreSQL listed, click on Change Settings and then Allow another app…<\/p>\n

\"\"<\/a><\/p>\n

Click on Browse and navigate to the C: Drive and then “Program Files”, “PostgreSQL”, the version number, and finally, “bin”. Scroll down and select the postgres.exe file and click on Open.<\/p>\n

\"\"<\/a><\/p>\n

Click on Network types… and choose both public and private and then OK and then click Add.<\/p>\n

\"\"<\/a><\/p>\n

If you are going to use Artisan from other computers, you must also configure PostgreSQL to allow incoming connections. Conveniently, we have just the file for most situations. You will need to click on this link and save the download file pg_hba.conf<\/a><\/p>\n

Once you have this file in your downloads for example, then copy the file to this location:
C:\\Program Files\\PostgreSQL\\16\\data (or whichever version number you’re using). Make sure you put the file into the data folder and it should ask you to confirm the file replacement. Yes to replace the file.<\/p>\n

NOTE: On macOS, you can’t just replace the file. Contact support for help updating pg_hba.conf on macOS.<\/p>\n

Next, on Windows, you’ll need to configure some more settings. Type “Services<\/strong>” into your Windows Search bar and click on the search result.<\/p>\n

\"\"<\/a><\/p>\n

Scroll down to “PostgreSQL<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Click on the Restart<\/strong> the service.\"\"<\/a><\/p>\n

Now, Right-click and select “Properties<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Click on the “Recovery<\/strong>” tab.<\/p>\n

\"\"<\/a><\/p>\n

Make sure these first few fields are set to “Restart the Service<\/strong>” instead of “Take No Action<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Click “Apply<\/strong>” and “OK.<\/strong>“<\/p>\n","protected":false},"excerpt":{"rendered":"

In order to use Artisan POS, you’ll need to download and install a program called PostgreSQL, which holds the data for Artisan. Normally, a support technician from CerTek or your dealer will do this for you. PostgreSQL only needs to be installed on one computer in your network, which we’ll…<\/p>\n","protected":false},"author":17,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":"","_monsterinsights_skip_tracking":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"ht-kb-category":[387,301],"ht-kb-tag":[],"class_list":["post-6485","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-postgresql","ht_kb_category-install"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/6485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/comments?post=6485"}],"version-history":[{"count":31,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/6485\/revisions"}],"predecessor-version":[{"id":22507,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/6485\/revisions\/22507"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=6485"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=6485"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=6485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}