Re: [ADMIN] Issues with LC_COLLATE, across 8.3/8.4 on various platforms
Στις Tuesday 02 February 2010 17:37:05 ο/η Tom Lane έγραψε: Achilleas Mantzios ach...@matrix.gatewaynet.com writes: What is the shortest way to change the default locale on a production installation running PostgreSQL-8.3.9? Is there anything less painful than dump, initdb,restore? No :-( Thanx Tom, taking into account that the large and most important DB in our installation (over 100Gb as SQL dump) lives in a tablespace of its own, is there a way to cheat postgresql after initdb in order to see this tablespace and the database in it, avoiding the whole cycle? i think this is not a good idea, i just thought i could ask, just to make sure. regards, tom lane -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Issues with LC_COLLATE, across 8.3/8.4 on various platforms
On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote: It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD are two different stories, hence the seen results. The UTF-8 locales on FreeBSD and Mac OS X are pretty much broken. This is becoming a FAQ ... -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Issues with LC_COLLATE, across 8.3/8.4 on various platforms
Στις Wednesday 03 February 2010 16:53:20 ο/η Peter Eisentraut έγραψε: On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote: It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD are two different stories, hence the seen results. The UTF-8 locales on FreeBSD and Mac OS X are pretty much broken. This is becoming a FAQ ... This is a libc/locale combination issue. Care to elaborate? AFAICT for my case in FreeBSD, the greek UTF locale el_GR.UTF-8 behaves as expected without problems. -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Issues with LC_COLLATE, across 8.3/8.4 on various platforms
On ons, 2010-02-03 at 17:05 +0200, Achilleas Mantzios wrote: Στις Wednesday 03 February 2010 16:53:20 ο/η Peter Eisentraut έγραψε: On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote: It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD are two different stories, hence the seen results. The UTF-8 locales on FreeBSD and Mac OS X are pretty much broken. This is becoming a FAQ ... This is a libc/locale combination issue. Care to elaborate? AFAICT for my case in FreeBSD, the greek UTF locale el_GR.UTF-8 behaves as expected without problems. Well, while in all of PostgreSQL 8.3.3 on i686-pc-linux-gnu (lc_collate=C) PostgreSQL 8.3.7 (lc_collate=el_GR.UTF-8) on i386-unknown-freebsd6.3 PostgreSQL 8.4.1 on x86_64-unknown-freebsd8.0 (lc_collate=en_US.UTF-8), gives fooname - Cylinder Liner No1 Cylinder head No1 Cylinder head cover No1 is not a correct sorting result in my book, unless your measure of correctness is ASCII byte value order. And then it's left as an exercise to determine what the results would be for texts involving non-ASCII letters. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] How to clear log files
PostgreSql:8.4.1 Is there a way for me to tell postgres to clear the log file. Example: I have log files created with names corresponding to the days of the week. This way they overwrite each other every week. When I deploy software enhancements I would like to clear the log file for the day without having to stop postgres. This way anything I see I know was after the deployment of my enhancements. I tried to just delete the file with postgres running. I found that it did not recreate the log file so I was forced to restart postgres. Is there a command that might clear a log file or force it to rotate? Thanks, Lance Campbell Software Architect/DBA/Project Manager Web Services at Public Affairs 217-333-0382
Re: [ADMIN] How to clear log files
What platform? If in Unix/Linux, just: cat /dev/null postgres_logfile orpostgres_logfile Most running programs don't like it when you delete a file with an open file handle but you it doesn't mind if you clear it on the fly. Not sure how to do this in a Windows environment. From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Campbell, Lance Sent: Wednesday, February 03, 2010 3:13 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] How to clear log files PostgreSql:8.4.1 Is there a way for me to tell postgres to clear the log file. Example: I have log files created with names corresponding to the days of the week. This way they overwrite each other every week. When I deploy software enhancements I would like to clear the log file for the day without having to stop postgres. This way anything I see I know was after the deployment of my enhancements. I tried to just delete the file with postgres running. I found that it did not recreate the log file so I was forced to restart postgres. Is there a command that might clear a log file or force it to rotate? Thanks, Lance Campbell Software Architect/DBA/Project Manager Web Services at Public Affairs 217-333-0382
[ADMIN] pg_rotate_logfile function does not appear to work
PostgreSql:8.4 Select pg_rotate_logfile() does not rotate the log file. If I delete my log file through the file system and then execute the query it will create a new log file. But if there is content in the log file and I run the query it does not seem to do anything. I would have expected it to clear the log file. My log files have the days of the week as names. So they get overlaid each week. I was looking for a way to trigger the clearing of the current log file. Thanks, Lance Campbell Software Architect/DBA/Project Manager Web Services at Public Affairs 217-333-0382
Re: [ADMIN] How to clear log files
El mié, 03-02-2010 a las 15:12 -0600, Campbell, Lance escribió: PostgreSql:8.4.1 Is there a way for me to tell postgres to clear the log file. Example: I have log files created with names corresponding to the days of the week. This way they overwrite each other every week. When I deploy software enhancements I would like to clear the log file for the day without having to stop postgres. This way anything I see I know was after the deployment of my enhancements. I tried to just delete the file with postgres running. I found that it did not recreate the log file so I was forced to restart postgres. Actually, when you delete an opened file it isn't really deleted. Whatever program opened it can still read/write to it using the file descriptor. Is there a command that might clear a log file or force it to rotate? Truncating it like this should work: echo /path/to/logfile There's probably a better way though. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
