Re: Postgres database : Out of balance problem from the same table

From: Khangelani Gama <Khangelani(dot)Gama(at)ucs-software(dot)co(dot)za>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgres database : Out of balance problem from the same table
Date: 2010-11-23 06:48:37
Message-ID: D78A8169F9436B4DB978300336168F3B407DBE3B84@SWBREXCH00.ucs-software.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all

Can anyone please assist or give an advise on the issue stated below

From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Khangelani Gama
Sent: Monday, November 22, 2010 10:31 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Postgres database : Out of balance problem from the same table

Hi

We have a problem, we have a master database as dbmaster sitting in the certain server and a backup database sitting in another server called dbbackup

Using the latest transaction number(aud_id = 1669629) that got generated from a table called audmth we wanted to check if the sum of the transactions from this table called audmth is the same.

DBMASTER - Database:

dbmaster =# select to_char(sum(aud_id),9999999999999.99) from audmth where aud_id <1669629;
to_char
-------------------
2774814647.00
(1 row)

DBBACKUP - Database:

dbbackup =# select to_char(sum(aud_id),9999999999999.99) from audmth where aud_id <1669629;
to_char
-------------------
2773145126.00
(1 row)

Due to the above issue, we restored the database from dbbackup to masterdb and visa versa, but we are still getting difference from the two databases which is very strange.

Any idea what could be the problem?

Thanks in advance

Khangelani Gama

Confidentiality Notice:http://ucs.co.za/conf.html

________________________________
The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential information of UCS Group and/or its subsidiaries. Any review, use or dissemination thereof by anyone other than the intended addressee is prohibited. If you are not the intended addressee please notify the writer immediately and destroy the e-mail. UCS Group Limited and its subsidiaries distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.

________________________________
The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential information of UCS Group and/or its subsidiaries. Any review, use or dissemination thereof by anyone other than the intended addressee is prohibited. If you are not the intended addressee please notify the writer immediately and destroy the e-mail. UCS Group Limited and its subsidiaries distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2010-11-23 08:14:57 Re: FK disappeared in 8.3.3
Previous Message Tom Lane 2010-11-22 19:25:41 Re: binary logs: a location other than pg_xlog??