Re: COPY-able csv log outputs
От | Greg Smith |
---|---|
Тема | Re: COPY-able csv log outputs |
Дата | |
Msg-id | Pine.GSO.4.64.0706020140160.24183@westnet.com обсуждение исходный текст |
Ответ на | Re: COPY-able csv log outputs (Andrew Dunstan <andrew@dunslane.net>) |
Список | pgsql-patches |
On Fri, 1 Jun 2007, Andrew Dunstan wrote: > Greg Smith wrote: >> Since the rotation size feature causes other issues anyway >> that make importing more complicated, documenting the issue seemed >> sufficient. > > What are the other issues? I'm not happy about producing files with split > lines. Just that it's fairly simple and predictable to know what your log files are going to be named and when they'll rollover if you use something like a date-based naming convention--but when you add size-based rotation into the mix figuring out what files you need to import and when you should import them gets more complicated. Clearly fixing this issue altogether would be better, and I gather the problem may extend to any time there is a switch to a new log file; my "workaround" doesn't appear good enough anyway. I'm very glad I caught and mentioned this now. Because of the extra naming/import complexity, it still might be worthwhile to suggest people not combine size-based rotation and the csvlog though. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
В списке pgsql-patches по дате отправления: