"[Errno 2] There is no such file or directory" when trying to backup the database in pgAdmin4

Finally, I managed to bypass the control to manually set the "PostgreSQL binary path" in the settings (why did the user need to do this when it was not necessary in pgAdmin3?).

Although, frankly, I have no idea what I mean with the second field of the path called "Binary path of the extended EDB server." But I don’t get any more error messages due to this, so I assume it is ok to leave it empty.

Now I'm stuck in the next step.

When trying to backup the database, I need to enter the file name. No matter what I do here, I keep getting this error:

[Errno 2] No such file or directory

Well, it can't be that I have to create a file before pgAdmin is created, right?

What can i do wrong?

Alex


update: the answer to @ n33rma is the print screens:

setting the path with the corrected path backup setup backup failed

+4
source share
6 answers

I just upgraded to pgAdmin v4.1 and this solved the problem :-) Thank you all for your help!

+3
source

I solved the problem through the command line.

If we use the previous format, it has the same answer as yours:

$ pg_restore -d <DBNAME> --username=postgres g=<FILENAME> 
pg_restore: [archiver] could not open input file "g=<FILENAME>": No such file or directory

If we change the last parameter, it works correctly:

$ pg_restore -d <DBNAME> --username=postgres <FILENAME>

I assume the GUI command has changed in v4, but the pg_restore console is not working.

+2
source

, , pgadmin , , ~/.pgadmin/storage/(user).

0

, PostgreSQL pgAdmin4.

pgAdmin4 - -, pgAdmin3 - , pgAdmin4 , , pg_dump pg_restore, .

pgAdmin4 : File > Preferences > Paths > Binary paths > PostgreSQL Binary Path

Windows, , C:\Program Files\PostgreSQL\9.6\bin

Linux, , /opt/PostgreSQL/9.5/bin

user@mint:/opt/PostgreSQL/9.5/bin$ lsh pg_du* pg_res*
-rwxr-xr-x 1 xxx xxx 150K Sep  2  2015 pg_restore
-rwxr-xr-x 1 xxx xxx  49K Sep  2  2015 pg_resetxlog
-rwxr-xr-x 1 xxx xxx  83K Sep  2  2015 pg_dumpall
-rwxr-xr-x 1 xxx xxx 364K Sep  2  2015 pg_dump
0

sql , .

:/test/test.sql

Linux

/u01/test.sql

0

MacOS 10.11 postgres.app :

enter image description here

-1

Source: https://habr.com/ru/post/1656393/


All Articles