Installing Postgres SQL

Installing Postgres SQL

The following instructions describe how to install PostgresSQL.

You will need to complete the following two tasks

Install PostgresSQL

  1. Go to this link and run the installer for Postgres Sql:
    Community DL Page (enterprisedb.com)


  2. Click Next
  3. Click Next
  4. Click Next:
  5. Click Next:
  6. Enter a password of your choice and click next.
  7. Click Next.
  8. Click Next.
  9. Click Next
  10. Click Next.
  11. Uncheck "Launch..." and then click Finish.

Configure PgAdmin 4

In order to backup and restore databases using PgAdmin 4 you must ensure the Binary Path setting points to where several critical DLLs are saved on your hard drive.

 

Below is the path that is typically correct, but it may vary for your system.

  1. C:\Program Files\PostgreSQL\16\bin

The screenshot below shows one of the files.  Find the directory that contains the libz4.dll file.  Copy this path.

 

Launch PgAdmin 4 from your Windows start menu.

Click File>Preferences

On the left-hand navigation tree go to Paths>Binary paths

In the list near the bottom, set the default to the version of PostgreSQL you're running and paste the path in the Binary Path field.

Click Save


    • Related Articles

    • Installing Microsoft SQL Server

      This article will walk you through installing and configuring SQL Server for a migration workstation. Visit https://www.microsoft.com/en-us/sql-server/sql-server-downloads and scroll down just a bit until you see Developer and click the Download now ...

    • Installing SQL Server Management Studio (SSMS)

      This article will walk you through installing and configuring SQL Server Management Studio (SSMS). If you have not already installed SQL Server, you should do so prior to installing SSMS. Visit ...

    • Convert a Postgres database to MSSQL

      Full Convert by Spectral Core is a robust tool for converting databases from one format to another. The following instructions will walk you through using Full Convert to convert a Postgres database to MSSQL. Launch Full Convert Click New database ...

    • Create a POSTGRES Backup

      This article assumes that you know your Postgres credentials and PgAdmin is Installed. Connect into PgAdmin. Right-Click on the database and click Backup: On the General tab, enter a filename and choose TAR as the format: On the Data/Objects tab, ...

    • Installing pgAdmin

      Go to this link and download the latest version of PgAdmin: Download (pgadmin.org) Click Install for All Users Click Next. Accept the license agreement and click Next. Click Next. Click Next Click Install Click Finish. Run PgAdmin4 from your Windows ...