Meaning og Logs

Hi List,

I got the logs as below from log file of PGSQL 7.4.2 on Solaris-9. Can
any one please give the exact meaning of it. And I have not found the
file any where on the server "0000000400000072".

LOG: recycled transaction log file "0000000400000072"

And I found most of the logged file contains the following statements.

LOG: unexpected EOF on client connection

WARNING: there is no transaction in progress

WARNING: there is no transaction in progress

WARNING: there is no transaction in progress

WARNING: there is no transaction in progress

LOG: unexpected EOF on client connection

LOG: unexpected EOF on client connection

LOG: unexpected EOF on client connection

LOG: unexpected EOF on client connection

WARNING: there is no transaction in progress

WARNING: there is no transaction in progress

WARNING: there is no transaction in progress

WARNING: there is no transaction in progress

WARNING: there is already a transaction in progress

WARNING: there is already a transaction in progress

WARNING: there is no transaction in progress

Can I get the exact date and time of these logged statements. And what
is the meaning of these statements.

Regards,

G. V. Suresh Gupta

------------------------------------------------------------------------
---------------------------------------------------------

Innovative Technology Solutions(ITS), Zensar Technologies

Zensar Knowledge Park, Plot#5, MIDC IT Tower,

Kharadi, Off Nagar Road, Pune - 411014

Landline : +91-20-66453471 | +91-9890898688

Email : suresh(dot)g(at)zensar(dot)com | website: www.zensar.com
<http://www.zensar.com/>

________________________________

From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of libra dba
Sent: Wednesday, March 05, 2008 3:38 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [ADMIN] using warm standby with drbd???

Hi All!

I have configured the warm standby using WAL FILES and DRBD. The wal
files are generated as server A. I am using DRBD to replicate these wal
files between server A and server B. The DRBD service is running as
Primary on Server A and secondary on Server B. The wal_files are written
to the server B, but there is a drawback for DRBD. The filesystme needs
to be unmounted on the server B (where DRBD is running secondary role).

So recovery is not countinuous.(file systme is unmounted). To start the
recovery, i need to change the DRBD role to primary on server B. After
that i have to mount the filesystem. Once i mount the filesystem, the
recovery process starts.

Is there any way in which i need not switch secondary/primary role for
DRBD on server B?
Is there any way in which i can have the file system mounted on server
B, running DRBD secondary role?

How else can i replicate the wal_files? ( i don't want to user common
file system ,,, NFS,,, etc.)?

Another thing which i want to ask is that if we are generating archives
every 1 minute. then what happens to the data which was written to the
server A after 35 seconds after the last wal file generation.(server A
crashes).

Since this data has not been archived (it was supposed to archive after
1 minute), do i think that this is the loss of data in a server A crash
as this 35 second data has not been written to the archived logs and
neither has been transported to server B?

A quick reply is highly appreciated!

Thanks!

DISCLAIMER:
This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails.