PostgreSQL database not available via Navicat

I'm new to Postgres, not SQL. I usually use Navicat to connect to my databases, so I set up a remote Postgres DB connection just like I normally would. I can:

  • Connect successfully
  • Database list

However, when I click on the database with my tables, it expands the database but shows nothing. There are no tables.

I saw another question here where the user was trying to get into "template0" and "template1": Some PostgreSQL databases are not visible through clients like Navicat or pgAdmin

I am not trying to penetrate them, but a special database full of tables. I have verified that both my web app and phpPgAdmin can access all tables and data, so the problem seems to be Navicat related.

I read a few instructions on how these tables can be "system items" and went into Navicat settings and checked the "Show system items (PostgreSQL, SQL Server)" checkbox to no avail.

One thing I have also tried, since I am using Navicat Premium, is to install the Navicat PostgreSQL version. This also gives exactly the same results, I can see my database, but none of the tables.

What's going on here?

EDIT

With a lot of help from Vao Tsun, we have determined that this is PostgreSQL 7.2.4 and that it is not supported by Navicat.

+3


source to share


1 answer


https://www.navicat.com/products/navicat-for-postgresql :

Navicat for PostgreSQL connects you to any local / remote PostgreSQL database servers from version 7.3 or higher.



It doesn't work with PostgreSQL 7.2.4

+1


source







All Articles