cartoninjas.net | Logging in pgsql

kill pg connection | PostGIS to GeoJSON

Logging in pgsql

7. February 2017 mika Comments (0)

edit postgresql.conf and change the following:

log_statement = 'all'
log_min_duration_statement = 0
logging_collector = on
#log_directory = 'pg_log'

make sure pg_log is available relative to the data dir

restart pgsql service

Related posts

The Entity Framework provider type 'Npgsql.NpgsqlServices, EntityFramework6.Npgsql' registered in the application config file for the ADO.NET provider with invariant name 'Npgsql' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is available to the running applicationJust wasted way too much time for this: The Entity Framework provider type 'Npgsql.NpgsqlServices, ...Installing pgsql as a aservice on WindowsGet the latest pgsql from here and if you need postgis from here.Unpack the pgsql zip to a desired dAccess pgsql x64 from manifold x32/x64 - both installed on win 64Scenario:windows server x64manifold 8.x x64pgsql 9.x x64In order to allow manifold x64 to connect to

blog comments powered by Disqus