Can't run queries against data source after initial session, re-creating the data source fixes it... (PostGRESQL)

I am connecting to a couple different Postgres servers and had no issues up until about 2 weeks ago.  Now all of a sudden, after my initial session if I try to run a query against the data source I receive an error that says: ERROR: No such database: xxxx.  By going to properties and clicking the `Test Connection` button I receive a "Successful" response.

If I re-create the data source it will work again for a single session, and then same issue.  From reading one of the other threads it seems like this might have to do with a timeout setting on the driver, but the answer didn't explain how to fix it, and just pointed at some Postgres documentation.

 

 

0
1 comment

@Mharris Hi,

  1. Could you specify DataGrip version you use?
  2. Could you attach a screenshot "Database Tools... => Manage Shown Schemas"?
  3. Do you have mentioned "xxxx" database on  your server?

Thank you.

P.S.: An example of "Manage Schemas":

0

Please sign in to leave a comment.