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 dep
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
What platform? If in Unix/Linux, just:
cat /dev/null > postgres_logfile
or > postgres_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 enviro
On Wed, Feb 3, 2010 at 4:12 PM, Campbell, Lance wrote:
> 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 soft
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
wi
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 st
Στις 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
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 pgsq
Στις Tuesday 02 February 2010 17:37:05 ο/η Tom Lane έγραψε:
> Achilleas Mantzios 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,
ta
