can't see new databases for postresql

Lex's profile image Lex posted 2 years ago in General Permalink
  1. Win 10, PosgreSQL 13.7, HeidiSQL 12.1. Localhost with 'postgres' user and stored password. I create new session, create new database in root folder, but it can't be seen them in list at all! I can see those databases from other client. See screenshots.

  2. Can't flush privileges - syntax error after pushing button.

I can do working session with MySQL database with no such issues. What i am doing wrong?

3 attachment(s):
  • starting
  • session
  • flushing
ansgar's profile image ansgar posted 2 years ago Permalink

What does the "Database" dropdown in the session manager show when you open it?

Lex's profile image Lex posted 2 years ago Permalink

It contains my created databases and default 'postgres' database (if i remember right). Description

ansgar's profile image ansgar posted 2 years ago Permalink

Please also look at the "Hide database pattern" in the Advanced tab.

And what if you select one of the newly created databases in the dropdown?

Lex's profile image Lex posted 2 years ago Permalink

I tried to solve problem earlier and deleted those pattern. Description If i select any of my databases in dropdown list, nothing changes after save and open session...

Lex's profile image Lex posted 2 years ago Permalink

some access denied commented message after changing database to test1 Description By the way, i change language from russian to english and restarts but all service messages still on russian.

Lex's profile image Lex posted 2 years ago Permalink

No ideas?

ansgar's profile image ansgar posted 2 years ago Permalink

That is most likely a message from the server, not from HeidiSQL directly.

Lex's profile image Lex posted 2 years ago Permalink

i doubt it. Other clients functional normally with same Postgresql server. Issue is on HeidiSQL side.

tangqiu's profile image tangqiu posted 10 months ago Permalink

I also have the same problem, No matter how many tables HeidiSql creates, it will not be displayed.

Description

Please login to leave a reply, or register at first.