I am reading up on this tutorial: PostgreSQL: https://dba.stackexchange.com/questions/149169/binary-path-in-the-pgadmin-preferences
To setup PostgreSQL Binary path, I looked at my Preferences on PgAdmin and I see all versions of PostgreSQL to update Binary path except for PostgreSQL 14 which i am actually using.
Please where exactly should I update the Binary path to?
I have added a screenshot
Anyone who is googling this problem out of frustration. Don't worry. The problem is pgAdmin does not fully support postgresql version 14 as of now (Nov 16). It happened to me as well when I tried to import/export into database.
Go to File > Preferences > Paths > Binary Paths > PostgreSQL Binary Path
You won't see PostgreSQL 14. It is ok. Just browse and set your postres 14's bin folder path to PostgreSQL 13's Binary Path. Lastly, make it default by clicking on the radio button on the left. Save it and run it again.
Your problem will go away.
Looking at the original screenshot, it looks like a Mac interface. So if you're on Mac, you could set PostgreSQL 13 as default, and use the path /Library/Applications/PostgreSQL/14/bin/.
