Cant recover postgres database

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Cant recover postgres database

Postby Hasuwisp » Fri Nov 28, 2008 10:08 pm

Several days ago my postgres died, and all i have is the data directory of my postgres database.
I used both methods of recovery i found here:
1:

I"f you don't have any recent backups then this is what you will need to do to try to recover the databases...
1. Create a new folder on your C drive called PostgreSQL_Data.
2. Go to the c:\program files\postgresql\8.2 folder. Right-click on the "data" folder and select "Copy" from the popup menu.
3. Go to the newly created c:\PostgreSQL_Data folder and right-click and select "Paste" from the popup menu.
4. Now, go to the Start menu and select Settings > Control Panel > Add or Remove Programs and then remove PostgreSQL 8.2 from the list.
5. From the Start menu again select Run. On the window that opens type "COMMAND" and hit OK. This will open a DOS window. Type the following next to the prompt...
net user postgres /delete
and hit ENTER to run it. Then type EXIT to close the DOS window.
6. Now, download and reinstall PostgreSQL as directed here:
http://www.pokertracker.com/products/PT ... nstallSQL2
WITH THE EXCEPTION THAT on the second window where it asks you where you want to install PostgreSQL click on the "Data Directory" button and navigate to the c:\PostgreSQL_Data\data folder and select that. This will force it to try to reuse your old data.
CONTINUE until you get to the window that has the "Initialize Database Cluster" box at the top left corner. UNCHECK THIS BOX and click the Next button and then just continue installing from there.
7. Once the install is done, RESTART YOUR COMPUTER and then try to open PT again."

Couldnt start postgres: cant connect to server make sure port: 5234 is open long message (direct through pgadmin) or the service started and was disabled cause it not active/used(administrative tools\services) .

and 2:

by moderator kraada here viewtopic.php?f=17&t=12017&p=56124*hilit=recover
logger shutting down after i type second command in guide, after i type 3rd command: "psql" i get coudnt connect ot server.

Would like to know can someone from support can try and copy my data directory .rar(300mb) file and try to restore db in and backup it in tracker after. Ill pay 100$ if hell suceed.
Hasuwisp
 
Posts: 54
Joined: Fri Nov 28, 2008 9:41 pm

Re: Cant recover postgres database

Postby WhiteRider » Sat Nov 29, 2008 5:23 am

Which step do you get stuck at? Do you get any errors?
If your database is in postgres 8.2 then you will need to be installing postgres 8.2 (not the latest 8.3 version).
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Cant recover postgres database

Postby Hasuwisp » Sat Nov 29, 2008 6:47 pm

tnx to ptrack pat , problem was solved i missed directory in data!
Hasuwisp
 
Posts: 54
Joined: Fri Nov 28, 2008 9:41 pm


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 26 guests

cron
highfalutin