If You Install pgAdmin and PostgreSQL in a Non-Default Location
I'm trying to keep my new Windows 11 installation as clean as I can, and for me that means installing as much software as I can on a separate D drive. But many apps expect to be installed in default Windows locations, so sometimes they get cranky if you put them elsewhere.
That's what happened yesterday when I installed both PostgreSQL and pgAdmin on my D drive. I couldn't restore a database because pgAdmin was confused about binary paths.
To fix that problem:
- In pgAdmin, go to
File > Preferences. - Under "Paths", select
Binary paths. - Under "PostgreSQL Binary Path", select the version of PostgreSQL you have installed to make it the default, and then enter the path of your PostgreSQL installation's
binfolder. For example,D:\PostgreSQL\16\bin. - Select
Save.