Restore error - Process returned exit code 1

[DrewOnTilt]

I am using pgAdmin III to restore a database. The restore process runs for a bit but then errors out with the message "Process returned exit code 1." If I press the "OK" button then pgAdmin attempts to restore the database again, with the same results. If I press "Cancel" then the result appears to be a database with the same structure as the one that I attempted to restore, but with no data.

Help?

[zedjr]

i assume u are using pt3. Create a pt3 db in pt3. THen go to pg admin and restore db from that file. Make sure pt3 is closed and check ur processes to make sure it is closed as i have realized that sometiems after closing pt3 it still remains open in processes. I assume u installed postgresql correctly with uac off and pt3 is running in admin mode.

[keggler]

it's probably permissions as the other reply says - check the windows event logs and switch on logging in pgadmin and post the logs back...


susan

[DrewOnTilt]

i assume u are using pt3. Create a pt3 db in pt3. THen go to pg admin and restore db from that file. Make sure pt3 is closed and check ur processes to make sure it is closed as i have realized that sometiems after closing pt3 it still remains open in processes. I assume u installed postgresql correctly with uac off and pt3 is running in admin mode.

Actually no, this is a PT2 database (PT3 is not fully working for me yet). I had to format my hard drive the other day and just reinstalled PT in all of its incarnations. I can't access postresql via PT2 at the moment because I haven't yet been sent my new PT2 registration codes. When that happens I will try to restore from within PT2.

Strangely enough, I was able to restore some of my PT3 databases without incident by using pgAdmin III.

EDIT: just got my new PT2 codes. I will try to restore this database from within PT2 now.

[zedjr]

Strangely enough, I was able to restore some of my PT3 databases without incident by using pgAdmin III.

really what code did it restore it to. DOes it work fine within pt3 i wonder. teh stats and all.

[DrewOnTilt]

I was finally able to restore this PT2 DB using PT2's internal PostreSQL restore functions, and the rest of my PT3 databases using the method described by zedjr. The whole thing was very strange - I have deleted and restored these databases on several occasions via pgAdmin III without problem.

[tomits]

I am using pgAdmin III to restore a database. The restore process runs for a bit but then errors out with the message "Process returned exit code 1." If I press the "OK" button then pgAdmin attempts to restore the database again, with the same results. If I press "Cancel" then the result appears to be a database with the same structure as the one that I attempted to restore, but with no data.

Help?

I encountered the same problem yesterday when i updated my postgres 8.2 -> to 8.3.

I made backups with pgAdmin III before update. Apparently in pgAdmin you don't have option to restore a database that doesn't exist. (but from command promt u can do it).
So i created a empty database from PT3 and then restored my backups.

You get the exit code 1, because tables and indexes already exist in the database. It still restores everything fine. pgAdmin's interface is confusing because "ok" button actually does restore again (i made the same mistake pressing it).

Just press cancel and it's ok.