PgAdmin Utility File Not Found PostgreSQL: 3 Confirmed Fixes

Computer errors can cause various problems, and one error that many users reported is the Utility file not found, please correct the binary path in the preferences dialog.

This error can cause all sorts of problems, such as SQL Server error 18456, and in today’s guide, we’re going to show you the best methods you can use to fix it.

What causes the Utility file not found in PostgreSQL?

There are two reasons for this error message:

• Improper configuration – If the application isn’t configured properly, you won’t be able to use it at all. You might even encounter errors such as SQL Server query execution failed.
• Missing files – In some instances, the necessary files might not be located in the proper location, thus causing issues to appear. If you’re working with databases, you should consider SQL backup software to prevent any file loss.

How can I fix the Utility file not found, please correct the binary path in the preferences dialog error?

1. Restore the database

1. Open pgAdmin. Click on File and select Preferences.
    
2. Next, choose Binary path and set ProgresSQL Binary path to C:\Program Files\PosgresSQL\13\bin
   
   
3. Lastly, select your database from the menu on the left, right-click it and choose Restore.
   

Once you perform these steps, the pgAdmin 4 utility file not found, please correct the binary path in the preferences dialog should be gone.

2. Edit the config_distro file

NOTE

This method will achieve the same results as the previous one, but instead of using the graphical interface, you’ll directly edit the settings.

1. Navigate to C:\Program Files\PostgreSQL\13\pgAdmin 4\web
2. Open the config_distro in your code editor.
    
3. Now change the pg value so it matches the location of the ProgresSQL bin directory.
   
4. Save changes.

As you can see, this is a simple solution that will help you fix Please configure the PostgreSQL binary path in the preferences dialog in PostgreSQL 14 error.

3. Copy the necessary files

1. Look for the pg_restore.exe file. It should be located in C:\Program Files\PostgreSQL\13\bin
2. Navigate to the following path: C:\Program Files\PostgreSQL\13\pgAdmin 4\
3. Navigate to the runtime directory. If it’s not available, right-click the empty space and expand the New menu and then select Folder. Name it runtime and navigate to it.
   
4. Now paste all the files from the bin directory inside the runtime folder.

As you can see, the Utility file not found, please correct the binary path in the preferences dialog is a minor error that can be easily fixed in a matter of minutes.

Fixing this error is important, and speaking of database errors, be sure to check our guide on how to repair a corrupted database in SQL Server.

Did you find a different solution for this problem? If so, let us know in the comments section below.