Trying to restore a DB, but getting "exit code" loop?

[domino66]

So I'm trying to restore a PT3 DB that I previously backed up, and I used the PT3 DB-Management window to first CREATE the new DB, then I closed down PT3, and opened PGADMIN III, double-clicked the postgres 8.2 server, highlighted the DB I'd just created, then right-clicked and selected RESTORE. Then I browsed to the place on my hard drive where I'd created the backup, and selected it.

Here's the problem -- after about 12 hours of restoring it, the pgadmin window finally stopped "thinking" and generated a line of text that said:

Process returned exit code 1.

No big deal, i thought >> there were buttons I could select saying either OK or Cancel. I clicked OK, and immediately, the window "hourglass" came up, and it showed a line of text that says:

C:\Program Files\PostgreSQL\8.2\bin\pg_restore.exe -i -h localhost -p 5433 -U postgres -d "PT3-OneTT-8.2" -v "C:\Documents and the hourglass icon came up again and it started "thinking" etc.

Then a couple mins later, it again generated the line of text:

Process returned exit code 1.

I clicked OK and again this process continued over and over and over until i finally got sick of it and clicked CANCEL instead of OK. The strangest part, I guess, is that my HD now has 25 gigs less space on it, so it SEEMS like the DB should have been restored properly...why, then, do I get this never-ending loops of "exit codes"?

[WhiteRider]

I assume this line:

C:\Program Files\PostgreSQL\8.2\bin\pg_restore.exe -i -h localhost -p 5433 -U postgres -d "PT3-OneTT-8.2" -v "C:\Documents

..actually included the correct full path at the end?

Have you tried running PT3 again? Does the database show correctly?

I'll get someone who knows more about postgres to take a look at this thread later.

[domino66]

Yes, that's correct, it included the full path, I don' t know why that didn't show up in my post, i must have pasted it wrong.

One thing I didn't mention was that just before it generated the "exit code 1" line of text, it did generate a few dozen lines of text, the last of which was always something like: "WARNING: errors found upon restore: 113". I never really thought much of this line (esp b/c it *seems* like the DB is OK in PT3, although I really only use your program for Table-Tracker, but all the same, I like getting to the bottom of things. FWIW, I tried restoring this DB on 2 dif machines, and the 100% exact same thing (re: the error msg / exit code) happened on each one.

[WhiteRider]

I guess if it is working in PT3 then the DB must have restored OK.
As I said, I'll try to get someone to have a look in.