[bug fix] pg_ctl always uses the same event source

Поиск
Список
Период
Сортировка
Искать
От
MauMau
Тема
[bug fix] pg_ctl always uses the same event source
Дата
Msg-id
4F809752C9CC49AC95F48F6A8F24267B@maumau
Список
Дерево обсуждения
[bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Tom Lane <tgl@sss.pgh.pa.us>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Robert Haas <robertmhaas@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Tom Lane <tgl@sss.pgh.pa.us>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Tom Lane <tgl@sss.pgh.pa.us>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Robert Haas <robertmhaas@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Peter Eisentraut <peter_e@gmx.net>
Re: [bug fix] pg_ctl always uses the same event source Tom Lane <tgl@sss.pgh.pa.us>
Re: [bug fix] pg_ctl always uses the same event source Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [bug fix] pg_ctl always uses the same event source Tom Lane <tgl@sss.pgh.pa.us>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Tom Lane <tgl@sss.pgh.pa.us>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Tom Lane <tgl@sss.pgh.pa.us>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Tom Lane <tgl@sss.pgh.pa.us>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Tom Lane <tgl@sss.pgh.pa.us>
Re: [bug fix] pg_ctl always uses the same event source Robert Haas <robertmhaas@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Tom Lane <tgl@sss.pgh.pa.us>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Magnus Hagander <magnus@hagander.net>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Magnus Hagander <magnus@hagander.net>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Magnus Hagander <magnus@hagander.net>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Magnus Hagander <magnus@hagander.net>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Magnus Hagander <magnus@hagander.net>
Re: [bug fix] pg_ctl always uses the same event source Magnus Hagander <magnus@hagander.net>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Magnus Hagander <magnus@hagander.net>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Magnus Hagander <magnus@hagander.net>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Magnus Hagander <magnus@hagander.net>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source "MauMau" <maumau307@gmail.com>
Re: [bug fix] pg_ctl always uses the same event source Amit Kapila <amit.kapila16@gmail.com>
Hello,

I've removed a limitation regarding event log on Windows with the attached 
patch.  I hesitate to admit this is a bug fix and want to regard this an 
improvement, but maybe it's a bug fix from users' perspective.  Actually, I 
received problem reports from some users.


[Problem]
pg_ctl always uses event source "PostgreSQL" to output messages to the event 
log.  Some example messages are:

server starting
server started

This causes the problems below:

1. Cannot distinguish PostgreSQL instances because they use the same event 
source.

2. If you use multiple installations of PostgreSQL on the same machine, 
whether they are the same or different versions, Windows event viewer 
reports an error "event source not found" in the following sequence.  Other 
system administration software which deal with event log may show other 
anomalies.
2-1 Install the first PostgreSQL (e.g. 9.3) into , register 
\lib\pgevent.dll for event source "PostgreSQL", then creates 
.
2-2 Install the second PostgreSQL (e.g. 9.2) into  as part of some 
packaged application, register \lib\pgevent.dll for event source 
"PostgreSQL", then creates .  The application uses PostgreSQL as 
its internal data repository.  It sets event_source = 'appname_db' in 
's postgresql.conf.
2-3 At this point, there's no problem.
2-4 Uninstall the second PostgreSQL.   is deleted.  The packaged 
application installer may or may not unregister pgevent.dll with 
regsvr32.exe /u.  ANyway, \bin\pgevent.dll is deleted.
2-5  continues to run and output messages to event log.
2-6 When you view the messages with event viewer, it reports an error 
because the event source "PostgreSQL" and/or pgevent.dll was deleted in 2-4.



[Fix]
Make pg_ctl use event_source setting in postgresql.conf.  This eliminates 
the need for every instance to use the event source "PostgreSQL" for its 
pg_ctl.


Regards
MauMau

В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
От: Tom Lane
Дата:
FAQ