Re: [GENERAL] pg_log filling up with false logs

2013-11-11 Thread bricklen
On Mon, Nov 11, 2013 at 6:32 PM, Shree wrote: > Also pg_ctl command to stop, restart does not seem to have any effect. > Does anyone have any ideas? > I can't speak to what issued the shutdown command, but have you tried "pg_ctl restart -m fast" to expedite the restart (if that is indeed what y

[GENERAL] pg_log filling up with false logs

2013-11-11 Thread Shree
Postgres 8.4 on OEL 6.3 Linux is having issues that the DBs are not available at intervals. I bumped up the debug level to 4 and all I see in the /var/lib/pgsql/data/pg_log are logs that say.. FATAL:  the database system is shutting down FATAL:  the database system is shutting down FATAL:  the d

Re: [GENERAL] pg_log is 2 hours ahead ???

2012-05-23 Thread Steve Crawford
On 05/23/2012 04:11 PM, Andreas wrote: Hi, I'm running a PG 9.1.3 on OpenSuse 12.1. I found that pg_log is 2 hours ahead though date on the console shows the right date and time. I have the ntp daemon watching the system's time every 60 minutes so this shouldn't be an issue. The time in

[GENERAL] pg_log is 2 hours ahead ???

2012-05-23 Thread Andreas
Hi, I'm running a PG 9.1.3 on OpenSuse 12.1. I found that pg_log is 2 hours ahead though date on the console shows the right date and time. I have the ntp daemon watching the system's time every 60 minutes so this shouldn't be an issue. The time in PG's logfiles filenames as well as the t

Re: [GENERAL] pg_log missing

2006-12-07 Thread Tom Lane
Ashish Karalkar <[EMAIL PROTECTED]> writes: > I have build 8.2 version from source code on redhat linux 4.0 but i am > not able to figure out why directory pg_log is missing... It sounds like you are expecting the source distribution to have the same default logging setup that the RPMs use. T'ain

[GENERAL] pg_log missing

2006-12-07 Thread Ashish Karalkar
Hello all, I have build 8.2 version from source code on redhat linux 4.0 but i am not able to figure out why directory pg_log is missing... and as it is missing then where are the log file.' can anybody help.. Thanks & Regards Ashish Karalkar

Re: [GENERAL] pg_log

2001-01-16 Thread Tom Lane
"Oliver Elphick" <[EMAIL PROTECTED]> writes: > Developers: > I've seen this question several times; wouldn't it be better to rename > pg_log to pg_tuplestatus? Calling something ...log is asking for it > to be wiped. In 7.1 it'll have a numeric filename ($PGDATA/global/1269, actually) which shou

Re: [GENERAL] pg_log

2001-01-16 Thread Tom Lane
"Andrew W. Nosenko" <[EMAIL PROTECTED]> writes: > Question: what is logged in pg_log table and how I can cleanup it? Transaction commit-status bits, and don't even *think* of touching it. Easiest way to hose your database that I know of :-( If it gets big enough to be really annoying, you can du

Re: [GENERAL] pg_log

2001-01-16 Thread Oliver Elphick
"Andrew W. Nosenko" wrote: >Question: what is logged in pg_log table and how I can cleanup it? (And >is this possible at all?) Don't touch it !!! It records the status of all your tuples. If you wipe it, you destroy your data. Developers: I've seen this question several times; wouldn't it

[GENERAL] pg_log

2001-01-16 Thread Andrew W. Nosenko
Question: what is logged in pg_log table and how I can cleanup it? (And is this possible at all?) PostgreSQL version: 7.0.3 -- Andrew W. Nosenko([EMAIL PROTECTED])