Q: postgres-xpg.log in wiki service huge filled with repeating messages
Hi all,
Firstly, I don't the wiki service at all, I do not even have it on. I've noted that my postgres-xpg.log is filled with the same messages over and over (see below).
How can I make this just STOP?
2015-12-05 16:46:43 XPG.65023: Spawning postgres now.
2015-12-05 16:46:43 XPG.65023: Waiting for socket to appear in socket directory: /Library/Server/Wiki/PostgresSocket
2015-12-05 16:46:44 ESTLOG: redirecting log output to logging collector process
2015-12-05 16:46:44 ESTHINT: Future log output will appear in directory "/Library/Server/Wiki/Logs".
2015-12-05 16:46:44 XPG.65023: Socket available; starting should now be complete.
2015-12-05 16:46:45 XPG.65023: log receiver: pg_receivexlog: starting log streaming at E2/DA000000 (timeline 1)
2015-12-05 16:46:45 XPG.65023: Starting backup heartbeat.
2015-12-05 16:52:49 XPG.65023: Decremented reference count. Count is now: 0
2015-12-05 16:52:49 XPG.65023: Reference count reached zero. Shutting down.
2015-12-05 16:52:49 XPG.65023: Killing idle connections...
2015-12-05 16:52:49 XPG.65023: Spawning... ('/Applications/Server.app/Contents/ServerRoot/usr/bin/psql', '-q', '-h', '/Library/Server/Wiki/PostgresSocket', '-d', 'postgres', '-c', "SELECT pid, (SELECT pg_terminate_backend(pid)) as killed from pg_stat_activity WHERE state LIKE 'idle';")
pid | killed
-------+--------
65073 | t
(1 row)
2015-12-05 16:52:50 XPG.65023: log receiver: pg_receivexlog: finished segment at E2/DB000000 (timeline 1)
2015-12-05 16:52:52 XPG.65023: Postgres exited.
2015-12-05 16:52:52 XPG.65023: pg_receivexlog still running; terminating.
2015-12-05 16:52:52 XPG.65023: log receiver: pg_receivexlog: not renaming "00000001000000E2000000DB.partial", segment is not complete
pg_receivexlog: received interrupt signal, exiting
2015-12-05 16:56:50 XPG.68314: Executing pg_ctl ['/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_ctl', '-p', '/Applications/Server.app/Contents/ServerRoot/usr/bin/xpostgres', 'start', '-w', '-t', '86400', '-D', '/Library/Server/Wiki/Database.xpg/Cluster.pg', '-l', '/Library/Server/Wiki/Logs/postgres-xpg.log', '-o', ' -c log_connections=on -c log_min_error_statement=WARNING -c listen_addresses= -c max_connections=500 -c unix_socket_group=_teamsserver -c log_statement=ddl -c log_line_prefix=%t -c log_lock_waits=on -c unix_socket_permissions=0770 -c log_rotation_age=1440 -c unix_socket_directories=/Library/Server/Wiki/PostgresSocket -c log_min_messages=WARNING -c logging_collector=on -c log_filename=postgres-%a.log -c log_truncate_on_rotation=on -c log_directory=/Library/Server/Wiki/Logs']
2015-12-05 16:56:50 XPG.68314: Spawning... ['/Applications/Server.app/Contents/ServerRoot/usr/bin/pg_ctl', '-p', '/Applications/Server.app/Contents/ServerRoot/usr/bin/xpostgres', 'start', '-w', '-t', '86400', '-D', '/Library/Server/Wiki/Database.xpg/Cluster.pg', '-l', '/Library/Server/Wiki/Logs/postgres-xpg.log', '-o', ' -c log_connections=on -c log_min_error_statement=WARNING -c listen_addresses= -c max_connections=500 -c unix_socket_group=_teamsserver -c log_statement=ddl -c log_line_prefix=%t -c log_lock_waits=on -c unix_socket_permissions=0770 -c log_rotation_age=1440 -c unix_socket_directories=/Library/Server/Wiki/PostgresSocket -c log_min_messages=WARNING -c logging_collector=on -c log_filename=postgres-%a.log -c log_truncate_on_rotation=on -c log_directory=/Library/Server/Wiki/Logs']
waiting for server to start...... done
server started
G.68318: Process parent is PID 1
2015-12-05 16:56:51 XPG.68318: Excluding data directory.
2015-12-05 16:56:51 XPG.68318: Turning on archive logging.
2015-12-05 16:56:52 XPG.68318: Cleaning up any existing postmaster.pid file
2015-12-05 16:56:52 XPG.68318: Cleaning up any existing socket lock file
2015-12-05 16:56:52 XPG.68318: Starting postgres.
2015-12-05 16:56:52 XPG.68318: Waiting for data directory: /Library/Server/Wiki/Database.xpg/Cluster.pg
2015-12-05 16:56:52 XPG.68318: Data directory exists.
Posted on Dec 5, 2015 2:09 PM