Re: Re: database restoration problem- data became incorrect caused by incorrect date in the server

From: Khangelani Gama <Khangelani(dot)Gama(at)ucs-software(dot)co(dot)za>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Re: database restoration problem- data became incorrect caused by incorrect date in the server
Date: 2010-04-09 17:43:40
Message-ID: D78A8169F9436B4DB978300336168F3B3359A3AB7C@SWBREXCH00.ucs-software.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

I really mean it....the backups we have uses pg_dump command. The automatic backup dumps file happen daily and gets saved in a certain directory

But the issue now is that we don't have any backup file for us to restore the database but exclude every data that got create when the date in server was incorrect.

Thanks

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Kevin Grittner
Sent: Friday, April 09, 2010 4:14 PM
To: pgsql-admin(at)postgresql(dot)org; Khangelani Gama
Subject: [ADMIN] Re: database restoration problem- data became incorrect caused by incorrect date in the server

Khangelani Gama <Khangelani(dot)Gama(at)ucs-software(dot)co(dot)za> wrote:

> We are still using 7.3.4 PostgreSQL

Do you really mean that, or is that a typo?

What sort of backups do you have? (pg_dump, file system copy, etc.)

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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 Kevin Grittner 2010-04-09 18:03:03 Re: Re: database restoration problem- data became incorrect caused by incorrect date in the server
Previous Message Kevin Grittner 2010-04-09 15:06:35 Re: Admin x DBA