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

[ffrllc]

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?

Sorry, I should of metnioned that I do not see this folder when I open the postgreSQl folder. I see psql to 'postgres', but I can't find psql to 'template1'.



I could send the most recent log files over, but I don't think these log files will show any problems now that I have learned what the problem is and when it comes into play.


Maybe this will help with the next suggestion on what to try.

My problem is not being able to start postgreSQL back up once I stop it.

Everything works fine when I install the new postgreSQL v8.3 at first. I'm able to start and stop the service without any problems.

The problem seems to come in only after I stop the PostgreSQL service so I can paste the old contents of the data folder (where I assume my previous DB's reside) into the newly created data folder within the newly created PostgreSQL folder in my program files. Once I do that, only then I try to start PostgreSQL back up and bingo, I run into the problem. It just won't start back up at that point and I receive the following error message:



Is there some other way to get my old database into the new postgreSQL then copy and paste the old contents of the data folder? This seems to be the method that causes the problem. Or maybe try and just copy the exact file where my DB resides instead of all the contents from the old data folder.

Does this help narrow down the problem?


PS:
The log files I can copy to send would either be the newly created log files as soon as I complete the installation which is when things work fine (prior to me replacing these data files with the old ones). Or I could send you the log files from my old data contents, but those log files are dated back before this entire problem came into play on 10/20. So I doubt those log files will show mcuh either as everything was working fine back then.

[WhiteRider]

I'll get Kraada to take another look at this..

[kraada]

Psql to 'postgres' would work fine for listing your databases as well.

One thing that might be going on is that the postgresql.conf resides in the data directory and if your old postgresql.conf has setting configurations that won't work with your new setup it could cause issues.

So, first, find out what the actual database is called (Psql to 'postgres', at the prompt '\l') so that we know for future reference.

Second, after installation, go into the new data directory, and copy out the postgresql.conf file. Copy your old database into place, then copy back in the new postgresql.conf and see if that works any better when you try to restart the server.

[ffrllc]

I'm not sure I understood what you suggested Kraada.

How do I find out what the actual databse is called? I open "psql to postgres" and then enter what exactly at the prompt?


Then after the installation you mentioned to delete the newly created postgresql.config and cop my old database into place. What file contains my old database (which file should I copy into place and where should I copy it?).


Thanks for the help.

[prajna]

Just FYI, I use Vista as well, and 8.3 was shaky at best for me. I reverted back to 8.2 instead and it runs fine for me. This might be the reason why your database doesn't start up for you and you are having general problems to begin with.

~ Thomas
[PokerTracker Support]

[WhiteRider]

I thought that 8.3.4 (which is now included in the PT3 with postgres) was OK on Vista..? (not from personal experience)

[ffrllc]

Thanks. I'll try 8.2 and see if that helps. What version of 8.2 should I use (the most recent v8.2.9?)?

[WhiteRider]

Yes, 8.2.9.

[ffrllc]

Ok, tried that. Still no luck, same connection issue. I'm very frustrated, but appreciate all the help.

Any ideas what to try next?

Thanks.

[WhiteRider]

If you go to the 'psql to postgres' thing again through the Start menu, does that open a DOS prompt?

Type

Code: Select all

\l

That should list your databases.
..although I guess it may not if you only just re-installed.