search

near / near-indexer-for-explorer

Watch NEAR network and store all the data from NEAR blockchain to PostgreSQL database
https://near-indexers.io/docs/projects/near-indexer-for-explorer
GNU General Public License v3.0
124 stars 56 forks source link

Cannot perform queries for public accessed db - mainnet2 #357

Closed kostapchuk closed 1 year ago

kostapchuk commented 1 year ago

I successfully connected using pgAdmin and IntelliJ Idea built-in DB viewer to public mainnet DB server. Afrer that I tried to execute a query on mainnet2 db and encountered the error: _ERROR: permission denied for table {tablename}.

How to solve this issue?

telezhnaya commented 1 year ago

Could you please try 

 psql postgres://public_readonly:nearprotocol@mainnet.db.explorer.indexer.near.dev/mainnet_explorer

From your terminal? It works fine to me

Screenshot 2023-02-27 at 12 07 59
kostapchuk commented 1 year ago

Thank you so much @telezhnaya for your help. I got where I was wrong. It works both in pgAdmin and Intellij Idea. No actions needed.