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
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
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
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
Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida34243
Tel. 941-753-7111 ext 305