I’m testing out render.com, and have been having success so far deploying a static site, api, and postgres db (all still in free tier while prototyping). I’m able to connect to the postgres db from my local instance of pgAdmin, but I tried using the render cli and keep getting the error “psql not found on path. Please ensure psql is installed and try again”.
I’m using render cli v2.1.4 for win x64 on win11. I renamed the executable to “render.exe” and added the containing folder to my path so I could exactly execute the command as displayed on render com, render psql <host>
I can’t find anything regarding this error when searching the internet, nor anything stating that I have to/how to install psql on the machine running my postgres instance. Then I thought maybe it was implying I needed psql on my local machine, which I had but not in the path, nor named “psql”. I created a copy of “C:\Program Files\PostgreSQL\16\scripts\runpsql.bat” and named it psql.bat, then added that dir to my path. Now when I run the command I get the normal psql login prompts, but that fails trying to decipher [public?] address from the host name:
PS C:\> render psql *****************************
Server [localhost]: *****************************
Database [postgres]: mydbname
Port [5432]:
Username [postgres]: mydbusername
psql: error: could not translate host name "***************************** to address: Name or service not known
Press any key to continue . . .
Seems like the cli is just a wrapper to instantiate my local psql and providing the hostname on the command line doesn’t do anything??? I don’t really need to use the render cli or psql to access the hosted db, since pgAdmin seems to work fine, but it might be nice to be able to use it for scripting maintenance tasks and such, so any help would be appreciated. Thanks!