Re: [PATCHES] log_filename_prefix -- log_filename + strftime()

2004-08-29 Thread Andreas Pflug
Tom Lane wrote: Andreas Pflug [EMAIL PROTECTED] writes: Tom Lane wrote: I can see the value of not needing any cron daemon to remove old logs. No other logs on your system to purge? The DBA isn't necessarily also root. Interesting this argument comes from you.. :-) Tasks like purging old log

Re: [PATCHES] log_filename_prefix -- log_filename + strftime()

2004-08-29 Thread Andreas Pflug
Bruce Momjian wrote: Are we going to change this before beta2? I have not seen a final patch yet. Can we have pg_logdir_ls in the backend first so any related changes to the log filename are reflected in both places? Otherwise displaying the logfile on the client continues to be a moving

[PATCHES] dbsize contrib

2004-08-29 Thread Andreas Pflug
The current implementation of dbsize doesn't handle tables in tablespaces correctly, and is quite restricted on objects covered (only tables and databases, but not tablespaces and indexes). The attached patch contributes: - database_size(name) - relation_size(text) These are the well-known

Re: [PATCHES] cygwin 8.0.0beta1 postmaster/syslogger.c, port/dirmod.c,

2004-08-29 Thread Reini Urban
Bruce Momjian schrieb: Your patch highlighted several bugs in our code. First, I wasn't testing for CYGWIN in the backend pgport_palloc code. Second, I added an #undef to prevent compiler warnings. Third I added your Cygwin includes with an #ifdef. These will appear in beta2. On the timezone

Re: [PATCHES] log_filename_prefix -- log_filename + strftime()

2004-08-29 Thread Jan Wieck
On 8/29/2004 5:12 AM, Andreas Pflug wrote: Tom Lane wrote: Andreas Pflug [EMAIL PROTECTED] writes: Tom Lane wrote: I can see the value of not needing any cron daemon to remove old logs. No other logs on your system to purge? The DBA isn't necessarily also root. Interesting this argument comes

Re: [PATCHES] Win32 bug fix

2004-08-29 Thread Maksim Likharev
I'll compile and test this in a morning. Thanks. -Original Message- From: Claudio Natoli [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 9:20 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: Win32 bug fix Could someone please eyeball the attached patch

Re: [PATCHES] Win32 bug fix

2004-08-29 Thread Maksim Likharev
Compiled and tried, seems much better, no more WAIT_FAIL errors. but I have some questions: 1. Is there a any possibility to assign server log file ( option -l,--log ) when PG runs as a service, I wasn't able to do that, dump everything into stderror or eventlog just not convenient. 2. What

[PATCHES] New Language Translation

2004-08-29 Thread eetemadi
First, thanks for the localization support in the POSTGRESQL. I want to add my language messages in postgresql.(LC_MESSAGES) It's Name is Farsi(Persian) and called fa_IR in translation files. First, It's the pg_controldata translation file attached. the path in the source is

Re: [PATCHES] New Language Translation

2004-08-29 Thread Peter Eisentraut
[EMAIL PROTECTED] wrote: First, thanks for the localization support in the POSTGRESQL. I want to add my language messages in postgresql.(LC_MESSAGES) It's Name is Farsi(Persian) and called fa_IR in translation files. Is there any use of fa outside of IR? Else I would just call the

Re: [PATCHES] Win32 bug fix

2004-08-29 Thread Andreas Pflug
Maksim Likharev wrote: Compiled and tried, seems much better, no more WAIT_FAIL errors. but I have some questions: 1. Is there a any possibility to assign server log file ( option -l,--log ) when PG runs as a service, I wasn't able to do that, dump everything into stderror or eventlog just not

Re: [PATCHES] log_filename_prefix -- log_filename + strftime()

2004-08-29 Thread Andreas Pflug
Jan Wieck wrote: but allows to setup a configuration that automatically overwrites files in a rotating manner, if the DBA so desires. ... which can't work because it will overwrite the logfile on server start, and thus will overwrite the very latest logfile when performing multiple restarts.

Re: [PATCHES] log_filename_prefix -- log_filename + strftime()

2004-08-29 Thread Tom Lane
Andreas Pflug [EMAIL PROTECTED] writes: Jan Wieck wrote: but allows to setup a configuration that automatically overwrites files in a rotating manner, if the DBA so desires. ... which can't work because it will overwrite the logfile on server start, and thus will overwrite the very

Re: [PATCHES] log_filename_prefix -- log_filename + strftime()

2004-08-29 Thread Jan Wieck
On 8/29/2004 2:06 PM, Tom Lane wrote: Andreas Pflug [EMAIL PROTECTED] writes: Jan Wieck wrote: but allows to setup a configuration that automatically overwrites files in a rotating manner, if the DBA so desires. ... which can't work because it will overwrite the logfile on server start, and

Re: [PATCHES] log_filename_prefix -- log_filename + strftime()

2004-08-29 Thread Andreas Pflug
Tom Lane wrote: at logger startup or size-based rotation, the rule would be to append. which then has a problem when you startup the postmaster after 10 hours of downtime ... hmmm. Doesn't seem like a big problem --- at worst that logfile will get to be double the size it normally would. ...

Re: [PATCHES] Autovbacuum Win32 service patch

2004-08-29 Thread Bruce Momjian
Patch applied. Thanks. I had not applied it earlier because I was not sure how the discussion had ended with Matthew. --- Dave Page wrote: Hi Bruce, Sorry, I just realised I only sent this patch to -hackers which

Re: [PATCHES] cygwin 8.0.0beta1 postmaster/syslogger.c, port/dirmod.c,

2004-08-29 Thread Bruce Momjian
Should I apply this change? #define TIMEZONE_GLOBAL ((int)_timezone) --- Reini Urban wrote: Bruce Momjian schrieb: Your patch highlighted several bugs in our code. First, I wasn't testing for CYGWIN in the