[Evergreen-general] Cannot find PosrgeSQL relations

Dashamir Hoxha dashohoxha at gmail.com
Sat Nov 9 02:50:04 EST 2024


Hi,

When I try to view the tables of the evergreen database, from the postgres
shell (`su - postgres psql`), I get the message "Did not find any
relations.". Yet, when I try some query, it works. For example:

--------------------
postgres=# \c evergreen
You are now connected to database "evergreen" as user "postgres".
evergreen=# \dt
Did not find any relations.
evergreen=# select max(id) from biblio.record_entry;
 max
-----
 264
(1 row)
--------------------

So, the database is there, but I cannot see its tables. I blame my lack of
experience with PostgreSQL, but this is the first time that it happens to
me. If someone knows the reason and how to fix it, I would be grateful if
you explain it.

However it is not so important, as long as the application works.

Thanks,
Dashamir
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20241109/b2352748/attachment.htm>


More information about the Evergreen-general mailing list