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
123 stars 56 forks source link

Create migration to restrict public_readonly run long queries #173

Closed telezhnaya closed 2 years ago

telezhnaya commented 3 years ago

I've accidentally found a way to run really long queries with public_readonly user.

I've already restricted in on Mainnet by

ALTER ROLE public_readonly SET statement_timeout = '30s';

Need to apply it to Testnet and create the migration files