Please configure the postgresql binary path in the preferences dialog как исправить
I created a database called dvdrental but when I click on restore I receive the error message below.
Is this .exe file missing in the zip file or am I doing something wrong?
Вложения
Go to File -> Preferences -> Paths -> Binary paths and the PostgreSQL Binary Path to you PG installation bin path, which I suppose should be C:\\Program Files\\PostgreSQL\\13\\bin.
On Wed, Apr 14, 2021 at 6:50 PM Amedeo Lietti < > wrote:
I created a database called dvdrental but when I click on restore I receive the error message below.
Is this .exe file missing in the zip file or am I doing something wrong?
Вложения
Please wait for v5.4 which is scheduled to be released on the 17th. There are changes related to binary paths.
As of 14/06/21 this solve does not work!
i tried it and got the following message:
C:\Program Files\PostgreSQL\13\pgAdmin 4\bin\"C:\Program
Files\PostgreSQL\13\bin\"\psql.exe' file not found. Please correct the
Binary Path in the Preferences dialog
before i changed the path in the binary paths dialog window, it said
something like $\Dir\..\ i dont remember exactly.
Пожалуйста, настройте двоичный путь PostgreSQL в диалоге настроек.
Это просто путь к папке PostgreSQL? Я не могу найти документацию по этому вопросу на сайте PostgreSQL. Все, что я могу найти, это:
Используйте поля в узле двоичных путей, чтобы указать пути к двоичным утилитам PostgreSQL и двоичным утилитам EnterpriseDB Postgres Advanced Server.
Есть ли более простой способ восстановить базу данных, кроме как через pgAdmin?
Binary path in the pgAdmin preferences
I installed PostgreSQL because I need to restore a large .backup file I received for upload to another platform (it's 38 million rows which was apparently too large for the person to export any other way). When I try to "restore" in pgAdmin 4 I get the message:
Please configure the PostgreSQL Binary Path in the Preferences dialog.
Is this just the path to the PostgreSQL folder? I can't find documentation on this on the PostgreSQL site. All I can find is:
Use the fields in the Binary paths node to specify paths to the PostgreSQL binary utilities and EnterpriseDB Postgres Advanced Server binary utilities.
Is there an easier way to restore the database other than through pgAdmin?
Binary path in the pgAdmin preferences
I installed PostgreSQL because I need to restore a large .backup file I received for upload to another platform (it's 38 million rows which was apparently too large for the person to export any other way). When I try to "restore" in pgAdmin 4 I get the message:
Please configure the PostgreSQL Binary Path in the Preferences dialog.
Is this just the path to the PostgreSQL folder? I can't find documentation on this on the PostgreSQL site. All I can find is:
Use the fields in the Binary paths node to specify paths to the PostgreSQL binary utilities and EnterpriseDB Postgres Advanced Server binary utilities.
Is there an easier way to restore the database other than through pgAdmin?
Читайте также: