postgresql

LARAGON – Add PostgreSQL

1. Introduction

By default Laragon, comes with MySQL installed. But adding PostgreSQL is easy.

Use Laragons build-in Quick Add option to install PostgreSQL.

2. Notice

Be sure your Windows 10 (64 bit) OS has the latest Visual C++ Redistributable for Visual Studio 2015-2019 installed.

3. What about the data?

This procedure will install PostgreSQL into your Laragon installation.
A new folder \LARAGON\data\postgresql-13\ wil be created.
It will not touch the existing MySQL or MariaDB databases.

Because MySQL/MariaDB uses port 3306 and PostgreSQL uses port 5432, both database systems can coexist at the same time.

This means you can export and import your data to migrate between database systems.

4. Laragon - Add PostgreSQL

  • In the Tools section, select Quick Add → Configuration. This will open the file \LARAGON\usr\packages.conf for editing.
  • Change the line postgresql-11=https://get.enterprisedb.com/postgresql/postgresql-11.0-1-windows-x64-binaries.zip into postgresql-13=https://get.enterprisedb.com/postgresql/postgresql-13.2-2-windows-x64-binaries.zip
  • Save and close the file.
  • In the Tools section, select Quick Add → postgresql-13.
  • Wait for the installer to finish.
  • Laragon has now placed PostgreSQL in the folder \LARAGON\bin\postgresql\
  • Laragon has added PostgreSQL to its menu.
  • In the Laragon Button Menu, click on the Start All button.
  • Laragon has now created a new data folder \LARAGON\data\postgresql-13\

5. Laragon - Configure pgAdmin 4

  • In the PostgreSQL section, select pgAdmin 4.
  • The first time you start pgAdmin 4, it will ask you to set a password.
  • Click the Add New Server button.
    • On the General tab, give the server connection a name, for instance laragon.
    • On the Connection tab, specify the host as localhost or 127.0.0.1.
    • Click the Save button.
  • You are now ready to start using PostgreSQL.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.