Make sure connections to database are read-only

systemapic / pile

PostGIS tile server

0 stars 2 forks source link

Closed strk closed 8 years ago

strk commented 8 years ago

the tiler shouldn't need read-write access to the database. Read-only can be accomplished with SET TRANSACTION: http://www.postgresql.org/docs/9.4/static/sql-set-transaction.html

strk commented 8 years ago

As of the mapnik being currently used (3.0.9) the transaction is already set as read-only:

LOG:  statement: SET DEFAULT_TRANSACTION_READ_ONLY = TRUE; SET CLIENT_MIN_MESSAGES = WARNING;