CODEWITHSUNDEEP
databasepostgresqlpgadmin
Lukas Halim
Lukas Halim

Reputation: 1545

pgadmin error when restoring database from tar file

I'm trying load a tar file using pgAdmin, but it's failing and all I get is exit code 3221225781. This code seems to indicate a missing dll What is exit code 3221225781 on windows? but I'm not sure why this would be or what dll to look for.

error message

Upvotes: 28

Views: 42770

Answers (4)

rsharma
rsharma

Reputation: 642

Even when the Binary paths are correctly set in the Preferences, you can sometimes still get this error. To find the root-cause of this error, you can click on the validate button next to the path and it will show you the actual problem. enter image description here

As you can see, the path is correct however the actual issue is displayed when the validate button is pressed.

enter image description here

In my case though, the pg_dump and pg_restore are actually present at the path however, I seem to be missing a library which is causing this (Getting this error when manually executing it).

enter image description here

Re-installing or installing a newer version fixed this for me.

Upvotes: 0

maneesh
maneesh

Reputation: 1157

For Me, I have installed several postgress versions:10,13 and 14. And I've been using version 10 for learning purpose.

enter image description here So I have copied the bin folder path from 'C:\Program Files\PostgreSQL\10\bin'

Then set this path as the default enter image description here

BEFORE UPDATE :

enter image description here

AFTER UPDATE PATH :

enter image description here

Upvotes: 5

Lukas Halim
Lukas Halim

Reputation: 1545

Updating the path in pgAdmin fixed this.

Steps: Select Databases > File > Preferences > Paths > Binary paths. Then edit to C:\Program Files\PostgreSQL\15\bin.

You'll need to use a different path if you're on a different version of PostgreSQL.

Updating the path

Upvotes: 73

JUAN CARLOS HA
JUAN CARLOS HA

Reputation: 111

You need to change the path in pgadmin. In my case, I have PostgreSQL 16.

Go to File/Preferences/Paths/Binary_paths

Choose your PostgreSQL version and change to the binary path as:

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

Upvotes: 11

Related Questions