Access nginx access log via PostgreSQL foreign table

2018-05-29 18:38:07+00

create server accessfileslr foreign data wrapper file_fdw; create foreign table accessloglr (arec varchar(2000)) server accessfileslr options ( filename '/var/log/nginx-accessjson_lr.log');

Tag: postgresql