Hello, I'm trying to connect directly to the postgresql server rather than the DB itself but I get this error here:
Is it impossible to do that? It's mostly for convenience, and connecting to MySQL directly does work without specifying a specific table to manage. I use datagrip so it lets me have a single entry for MySQL where all of my databases and tables show up, rather than having one entry per database. asked 24 May '17, 18:33 heyoni |
Please provide more context, what is the exact command you are running (changing the auth info)? Pgsql does require you to log in as a given user/DB. answered 25 May '17, 01:48 johns Hey Johns, I'm not sure exactly what the commands being sent are, as I'm using a program called datagrip. I am trying to see if there's a console log to get it, but I think your statement about pgsql requiring a database answers my question. Basically with mysql, I declare the server and not the database, so it gives me a view of all the ones I have access to. I was hoping to do that with pgsql as well.
(25 May '17, 13:38)
heyoni
One other thing to check is the host information, psql is picky about host, try to use the server's main IP address or use the webXXX.webfaction.com host info.
(26 May '17, 02:44)
johns
|