[BUGS] BUG #3660: unused empty file is created with csvlog
The following bug has been logged online: Bug reference: 3660 Logged by: Thomas Reiss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 beta 1 Operating system: Linux Description:unused empty file is created with csvlog Details: Hello, I just tried the csvlog logging method. I set the following : log_destination = 'csvlog' logging_collector = on log_filename = 'postgresql-%u' At server start, PostgreSQL creates a file called "postgresql-2" (for today) and a file "postgresql-2.csv". File "postgresql-2" is empty and never used again, whereas "postgresql-2.csv" contains the logs. If log_filename is set to 'postgresql-%u.csv', PostgreSQL creates two files too: postgresql-2.csv and postgresql-2.csv.csv and uses the second one. Regards, Thomas ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
[BUGS] BUG #1974: UTF-8 french postmaster messages corrupted
The following bug has been logged online: Bug reference: 1974 Logged by: Thomas Reiss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: Linux Fedora Core 1 Description:UTF-8 french postmaster messages corrupted Details: Hello, The french messages lost their accents in the latest stable release. When in 8.0.4 with $LANG=fr_FR.UTF-8, I get: [EMAIL PROTECTED] postgres]$ echo $LANG fr_FR.UTF-8 [EMAIL PROTECTED] postgres]$ pg_ctl stop en attente de l'arrêt du postmasterTRACE: arrêt en cours des traces fait postmaster arrêté When in 8.0.2, on the same server, with $LANG=fr_FR.UTF-8, I get the following, which is correct: [EMAIL PROTECTED] postgres]$ echo $LANG fr_FR.UTF-8 [EMAIL PROTECTED] postgres]$ pg_ctl stop en attente de l'arrêt du postmaster fait postmaster arrêté I did this tests in the same session, I just switch from an environnement to another by resetting the $PATH and $PGDATA environnement variables. Thanks in advance. Thomas ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[BUGS] BUG #2432: PID file not created if $PGDATA is different from Datadir
The following bug has been logged online: Bug reference: 2432 Logged by: Thomas Reiss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Linux Debian sarge Description:PID file not created if $PGDATA is different from Datadir Details: Hello, I'm experiencing the data_directory parameter in order to differenciate the config files from the data files. I did the following: - use an existing PG cluster - moved the *.conf to a specific config directory - changed my $PGDATA to the config directory - changed the data_directory parameter to point to the appropriate directory (the old PGDATA in fact) - started PostgreSQL, everything is fine When I tried to shutdown PG with a simple pg_ctl stop, the tool claimed about a missing postmaster.pid file. pg_ctl status didn't worked either. When looking into the $PGDATA dir, I only had my 3 config file and no postmaster.pid. I then shut down PG by sending a kill signal by hand. I then tried the external_pid_file parameter and pointed it to $PGDATA/postmaster.pid (I gave the real pathname in the config file of course). PG started well. Now, pg_ctl stop don't complain anymore about the pid file, but goes in an infinite loop, probably waiting the postmaster.pid file to be deleted. Thanks in advance for providing an advice. Thomas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
