Running PostgresSQL 11.4 on Windows 10
I made a DB cluster in
I registered that cluster to start on as a windows service on startup:
pg_ctl register -D C:\Users\WindowsUser\AppData\Roaming\postgresql\Db_1 -N PostgreSQLdb1 -U WindowsUser -P WindowsPassword -S a
And the Where to log In
C:\Users\WindowsUser\AppData\Roaming\postgresql\Db_1\postgresql.conf I changed the log parameter to a absolute location.:
# - Where to Log - log_destination = 'stderr' # Valid values are combinations of # stderr, csvlog, syslog, and eventlog, # depending on platform. csvlog # requires logging_collector to be on. # This is used when logging to stderr: logging_collector = on # Enable capturing of stderr and csvlog # into log files. Required to be on for # csvlogs. # (change requires restart) # These are only used if logging_collector is on: log_directory = 'C:\Users\WindowsUser\AppData\Roaming\postgresql\Db_1\log' # directory where log files are written, # can be absolute or relative to PGDATA log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern, # can include strftime() escapes
However, the cluster database does not write anything to log. The main PG database is located in a totally different directory, and that database does write to its log file.
Both databases works just fine, except the log part.
I have have even restarted my PC, but it still does not write to log.