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:UsersWindowsUserAppDataRoamingpostgresqlDb_1 -N PostgreSQLdb1 -U WindowsUser -P WindowsPassword -S a
And the Where to log In
C:UsersWindowsUserAppDataRoamingpostgresqlDb_1postgresql.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:UsersWindowsUserAppDataRoamingpostgresqlDb_1log' # 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.
Ten-tools.com may not be responsible for the answers or solutions given to any question asked by the users. All Answers or responses are user generated answers and we do not have proof of its validity or correctness. Please vote for the answer that helped you in order to help others find out which is the most helpful answer. Questions labeled as solved may be solved or may not be solved depending on the type of question and the date posted for some posts may be scheduled to be deleted periodically. Do not hesitate to share your response here to help other visitors like you. Thank you, Ten-tools.