Postgresql--使用pgadmin4 on windows restore db Postgresql on linux/Please configure the PostgreSQL Binary Path in the Preferences dialog

Posted by: bart30508 | in Postgresql | 11 months, 1 week ago |

Postgresql--使用pgadmin4 on windows restore db Postgresql on linux/Please configure the PostgreSQL Binary Path in the Preferences dialog

由於我將pgadmin安裝在windows, 而postgresql安裝在linux.

但是pgadmin要使用介面還原時, 竟然是去抓local的pg_restore套件.

所以他會跳出 Please configure the PostgreSQL Binary Path in the Preferences dialog.

如果你是pgadmin與Postgresql安裝在同個Server, 你做以下設定有用:

1,查找地址

终端输入:which psql

结果:/usr/bin/psql

2.

3,修改為/user/bin

如果不是就只能裝個ftp, 把db備份檔, 丟進Linux去, 自己用pg_restore進行還原了.

參考來源: https://blog.csdn.net/zgahxxwht/article/details/90608075

tags: Postgresql
Currently unrated
 or 

Subscribe

* indicates required

Recent Posts

Archive

2022
2021

Categories

Apache 1

Data Science 2

Dbfit 1

Design Pattern 1

Devops 3

DigitalOcean 1

Django 1

English 3

Excel 5

Flask 3

Git 1

HackMD 1

Heroku 1

Html/Css 1

Linux 4

Machine Learning 2

Manufacture 1

Mezzanine 18

Oracle 1

Postgresql 7

PowerBI 4

Powershell 4

Python 21

SEO 2

SQL Server 51

SQLite 1

Windows 1

database 8

work-experience 1

其他 1

自我成長 1

資料工程 1

Tags

SEO(1) Github(2) Title Tag(2) ML(1) 李宏毅(1) SQL Server(18) Tempdb(1) SSMS(1) Windows(1) 自我成長(2) Excel(1) python Flask(1) python(5) Flask(2)

Authors

bart30508 (146)

Feeds

RSS / Atom

Postgresql--使用pgadmin4 on windows restore db Postgresql on linux/Please configure the PostgreSQL Binary Path in the Preferences dialog

© COPYRIGHT 2011-2022. Max的文藝復興. ALL RIGHT RESERVED.