Ray Stell <[EMAIL PROTECTED]> writes:
> I toggle log_duration:
> wiki=# \!date
> Mon Feb 19 11:14:35 EST 2007
> wiki=# set log_duration=off;
> SET
SET only affects your own session, not anyone else's ...
regards, tom lane
---(end of broadcast)---
On Mon, Feb 19, 2007 at 03:06:32PM -0500, Ray Stell wrote:
> in the pg share dir:
>
> $ /usr/sbin/zdump -v EST5EDT | grep 2007
On many platforms, regardless of what directory you're in, the above
command will read timezone files from a standard directory like
/usr/share/zoneinfo, not from the cur
Is your database ready for the Daylight Savings Times change of 2007?
http://people.planetpostgresql.org/greg/index.php?/archives/96-Is-your-database-ready-for-the-Daylight-Savings-Times-change-of-2007.html
in the pg share dir:
$ /usr/sbin/zdump -v EST5EDT | grep 2007
EST5EDT Sun Mar 11 06:59:59
Dear colleagues,
What is the preferred grant model in multi-developers environment?
I'm currently thinking of two groups, one is 'admin' and other is 'user', where
real developers are members of the first group, with 'set role to admin' in
pg_authid; report create user (used in web frontend, e.
Ray Stell wrote:
I toggle log_duration:
wiki=# \!date
Mon Feb 19 11:14:35 EST 2007
wiki=# set log_duration=off;
SET
wiki=# SELECT current_setting('log_duration');
current_setting
-
off
(1 row)
yet duration continues to be logged:
wiki,13190,wiki,2007-02-19 11:16:00.926 EST,4
I toggle log_duration:
wiki=# \!date
Mon Feb 19 11:14:35 EST 2007
wiki=# set log_duration=off;
SET
wiki=# SELECT current_setting('log_duration');
current_setting
-
off
(1 row)
yet duration continues to be logged:
wiki,13190,wiki,2007-02-19 11:16:00.926 EST,45d94f9e.3386,36108
Kris Kiger wrote:
> Greetings! I've been doing some research into log rotation software and
> ran into this, while looking through the postgres site:
>
> "There is a built-in log rotation program, which you can use by setting
> the configuration parameter redirect_stderr to true in postgresql.c
Greetings! I've been doing some research into log rotation software and
ran into this, while looking through the postgres site:
"There is a built-in log rotation program, which you can use by setting
the configuration parameter redirect_stderr to true in postgresql.conf."
http://www.postgresq
