X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5EBE7529B8 for ; Sat, 6 Aug 2005 12:54:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05480-02 for ; Sat, 6 Aug 2005 15:54:36 +0000 (GMT) Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by svr1.postgresql.org (Postfix) with ESMTP id 0271752990 for ; Sat, 6 Aug 2005 12:54:31 -0300 (ADT) Received: from jfradkin ([66.15.127.235]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IKT00GWM5IT2F81@vms048.mailsrvcs.net> for pgsql-admin@postgresql.org; Sat, 06 Aug 2005 10:54:30 -0500 (CDT) Date: Sat, 06 Aug 2005 11:56:12 -0400 From: "Joel Fradkin" Subject: issue doing backup / restore using pgadmin III To: Message-id: <001301c59a9f$5ede4630$797ba8c0@jfradkin> MIME-version: 1.0 Content-type: multipart/alternative; boundary="----=_NextPart_000_0014_01C59A7D.D7CCA630" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.887 tagged_above=0 required=5 tests=AWL, HTML_60_70, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: ** X-Archive-Number: 200508/78 X-Sequence-Number: 18397 This is a multi-part message in MIME format. ------=_NextPart_000_0014_01C59A7D.D7CCA630 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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. =20 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). =20 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). =20 Anyone having any ideas that will help please email me at jfradkin@tampabay.rr.com =20 Joel Fradkin =20 Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 =20 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. =20 =20 =20 ------=_NextPart_000_0014_01C59A7D.D7CCA630 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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.
© 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.

 


 

 

------=_NextPart_000_0014_01C59A7D.D7CCA630--