pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joel Fradkin <jfradkin@wazagua.com>
To: pgsql-admin@postgresql.org
Subject: issue doing backup / restore using pgadmin III
Date: Sat, 06 Aug 2005 11:56:12 -0400
Message-ID: <001301c59a9f$5ede4630$797ba8c0@jfradkin> (raw)

I am converting from SQLASCII to UNICODE and in the process I backed up my
data base using the latest pgadmin III (fresh download on new computer
win2003).

Unfortunately I deleted the ascii data base (wanted to use the same name for
the Unicode). I had already saved / restored it and did not notice there
were errors.

My guess is I am cooked, but thought I would ask. The bad restore file was
300k too small so I am guessing there is no longer the data anywhere.

Since I deleted the original ascii database and created one with the same
name and restored some data to it.

 

I have a good backup from the previous day but it means losing a whole day
of data (a huge disaster as we have many clients and I am sure this is going
to go down poorly).

 

Am I correct in assuming there is nothing I can do to salvage this (I have
restored the previous backup and am converting it at this time).

Just a note maybe the restore program shouldn't return code the same when
there are errors and when there are not. (I mean it was totally my fault for
not looking more closely at the detail, I am sure it must of mentioned an
error but it was not very obvious, I was doing it at like midnight to try
and get it done with the least amount of down time).

 

Anyone having any ideas that will help please email me at
jfradkin@tampabay.rr.com

 

Joel Fradkin

 

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.  941-753-7111 ext 305

 

jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
 This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information.  Any unauthorized review,
use, disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.

 


 

 

Message-ID: <001301c59a9f$5ede4630$797ba8c0@jfradkin>
Permalink:  ../001301c59a9f$5ede4630$797ba8c0@jfradkin/
Also on:    postgresql.org/message-id/001301c59a9f$5ede4630$797ba8c0@jfradkin

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jfradkin@wazagua.com
  Subject: Re: issue doing backup / restore using pgadmin III
  In-Reply-To: <001301c59a9f$5ede4630$797ba8c0@jfradkin>
  References: <001301c59a9f$5ede4630$797ba8c0@jfradkin>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox