Configure PgAdmin 4

Configure PgAdmin 4

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\17\bin
  1. The screenshot below shows one of the files.
    Find the directory that contains the libz4.dll file.  Copy this path. 
  2. Launch PgAdmin 4 from your Windows start menu.
  3. Click File>Preferences
  4. On the left-hand navigation tree scroll down to Paths>Binary paths
    In the list near the bottom, set the default to the version of PostgreSQL by pasting in the path you copied on step 1, from the libz4.dll file
    Click Save

    • Related Articles

    • 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.

    • Installing Postgres SQL

      The following instructions describe how to install PostgresSQL. You will need to complete the following two tasks Install PostgresSql Configure PgAdmin 4 Install PostgresSQL Go to this link and download the most recent version at the top of the list: ...

    • How to Configure SQL Server RAM Limits

      This article will guide you through setting up RAM limits for Microsoft SQL Server to ensure optimal performance while leaving sufficient resources for the operating system and other applications. Launch SQL Server Management Studio (SSMS) Click Open ...

    • Configure Stripe for Payment Processing

      You should have a good payment processor that enables your team to quickly and easily charge and bill customers that you are migrating. We highly recommend Stripe.com. Create a Stripe Account Create an account with Stripe and verify your business. ...

    • 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 Click on the folder icon to choose a location for your backup When you reach the location to ...