Thanks! Shoaib, that worked real good. Not sure why it stopped in the
first place.
Shoaib Mir wrote:
> I guess that might work:
>
> 1. Set the following in postgresql.conf file --> log_rotation_age = 1
> 2. rename the already present log file from dbserver logs folder
> 3. Now do --> pg_ctl relo
Please unsubscribe me! Thank you!
Also, it would be better to have a message foot saying how to unsubscribe.
Chan Michael wrote:
> Hi Jim,
>
> Thanks for your info.
>
> Then in PostgreSQL 7.3 how can I use the WAL log to recover?
WAL will recover itself on restart of a PostgreSQL server.
Sincerely,
Joshua D. Drake
>
> Michael
>
> "Jim C. Nasby" <[EMAIL PROTECTED]> 說： On Thu, Sep 28, 2006 at 10:
I guess that might work:1. Set the following in postgresql.conf file --> log_rotation_age = 12. rename the already present log file from dbserver logs folder3. Now do --> pg_ctl reload (so that log_rotation_age change you did comes in affect)
4. Check the log folder after a while (after 1 minutes)
I am trying to be unsubscribed member already many times and I am still
getting a lot of mail.
PLEASE!!!
Do cancel my subscription!!
Please send me a confirmation on cancelation.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Hi Andrew,
Thanks! for the reply, it is a small file. the file size on it is
735K that's pretty small. Not sure why it stopped writing to the log
file, is there any way to start logging without starting postgres ?
Pallav.
Andrew Sullivan wrote:
> On Mon, Oct 02, 2006 at 11:04:11AM -0400, P
On Mon, Oct 02, 2006 at 11:04:11AM -0400, Pallav Kalva wrote:
> Hi ,
>
> My production database stopped writting to the postgres log files
> all of a sudden, does anybody know why ?
How big is the file?
> log_rotation_age | 10080
> log_rotation_size | 0
You've s
Hi ,
My production database stopped writting to the postgres log files
all of a sudden, does anybody know why ?
Database seems to run fine.
Postgres version is 8.0.2
Here are my settings
log_connections| off
log_destination| stderr
log_directory
> Hi!
> I would like to install postgresql on a Linux system where as much
> as possible of the OS- and program specific directories will be
> turned read only after installation.
> My intent is to place all files that needs to be writable on a
> second, read/write partition.
>
> My question is:
>
Hi!
I would like to install postgresql on a Linux system where as much as
possible of the OS- and program specific directories will be turned read
only after installation.
My intent is to place all files that needs to be writable on a second,
read/write partition.
My question is:
Is there som
10 matches
Mail list logo
