Page 1 of 3

Installed new postgres v8.3 and lost my DB????

PostPosted: Thu Oct 23, 2008 2:39 pm
by ffrllc
I had the connection issue similar to others where PT3 would no longer connect to my postgres DB. I searched this forum and came up with the solution to:

1.) Save your "data" folder. You can find it in C:\Program Files\PostgreSQL\8.3.
2.) Uninstall postgresql completely and delete everything under C:\Program Files\PostgreSQL\8.3. EXCEPT the data folder.
3.) Install PostgreSQL again, but untick "Initialize Database cluster".
4.) click on "connect" again and it should work


I did that, but now PT3 is unable to connect to my DB as it says it does not exist. The connection issue with postgres seems to be resolved, but my previous PT3 DB's seem to be missing. How can I get all my data back into my DB?

Re: Installed new postgres v8.3 and lost my DB????

PostPosted: Thu Oct 23, 2008 3:26 pm
by WhiteRider
In PT3 go to DAtabase -> Database Management and click New, then check the 'this database exists' option and browse to find your old database.

Re: Installed new postgres v8.3 and lost my DB????

PostPosted: Thu Oct 23, 2008 3:53 pm
by ffrllc
It says no PT3 databases found when I search.

Re: Installed new postgres v8.3 and lost my DB????

PostPosted: Thu Oct 23, 2008 4:16 pm
by WhiteRider
I'll get someone who knows more about postgres to take a look.

Re: Installed new postgres v8.3 and lost my DB????

PostPosted: Thu Oct 23, 2008 4:19 pm
by kraada
Click Start --> Programs --> PostgreSQL --> Psql to 'template1'

At the command prompt type:
Code: Select all
\l
and hit enter. Do you see your PT3 db there?

Re: Installed new postgres v8.3 and lost my DB????

PostPosted: Thu Oct 23, 2008 5:15 pm
by ffrllc
Hmmm, I must have installed "Postgresql Plus" and not just the basic Postgresql. I unistalled/deleted postgresql plus and have been trying to re-install just the basic postgresql v8.3 and can't seem to connect to the download page on www.postgresql.org

I also haven't been able to find another mirror site to download from.


While trying to download from www.postgresql.org, I can get to the download page for win32 file of postgresql-8.3.4-1.zip, but when I click on that to download I get an error message as I can't connect to that download page/file.


Is there another site I can download this from? Each one I have found links me back to that same page on the www.postgresql.org site.

Re: Installed new postgres v8.3 and lost my DB????

PostPosted: Thu Oct 23, 2008 5:41 pm
by WhiteRider
Hmm, no I can't get it to download at the moment either. I'm not sure where else to get it from, so try again later - if you still can't get it to download, bump this thread and I'll see if anyone else knows.

Re: Installed new postgres v8.3 and lost my DB????

PostPosted: Thu Oct 23, 2008 6:47 pm
by ffrllc
Ok, I was able to get the standard postgresql v8.3 installed. After installing this I'm still unable to brows for my old databases. When I try I get the following error:


Image



It seems the server is closing the connection for some reason???

Re: Installed new postgres v8.3 and lost my DB????

PostPosted: Fri Oct 24, 2008 12:28 am
by ffrllc
Any idea what I should try next?

Thanks.

Re: Installed new postgres v8.3 and lost my DB????

PostPosted: Fri Oct 24, 2008 4:21 am
by WhiteRider
Please select the last few files in C:\Program Files\PostgreSQL\8.3\data\pg_log (they're dated so just pick the recent ones), right-click and choose 'Send To Compressed/zipped Folder', then attach the zip file to a ticket on the Support system, and link to this thread in the reference field of the ticket so that we can investigate.

highfalutin