Στις 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
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
Στις 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
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,
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
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
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
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