Search Postgresql Archives

Meaning og Logs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.g@xxxxxxxxxx    | website:  www.zensar.com

 

 

 

 

 


From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of libra dba
Sent: Wednesday, March 05, 2008 3:38 AM
To: pgsql-general@xxxxxxxxxxxxxx
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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux