Upgrading Database version problem?

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

Upgrading Database version problem?

Postby cdndctx » Fri Jul 23, 2010 4:50 pm

I had 8.2 and I am trying to install the latest 8.3.x version.

I have followed the guide. I am at the initialize database cluster and I am stuck. I get the following:

The secondary logon service is not running. This service is required for the installer to initialize the database. Please start the service and try again.

I thought I would try the other way it states where you uncheck initialize the database cluster when I do that and try I get the following:

Initdb warning The specified data directory does not contain an existing database cluster. Install without initializing a database cluster in this case will produce an installation that will not start.

Please help me.

I created a backup like you said. When I uninstalled the old 8.2 i chose to follow step the step to preserve the database because i did not want to accidently delete the database i backed up.
cdndctx
 
Posts: 3
Joined: Fri Dec 19, 2008 7:26 pm

Re: Upgrading Database version problem?

Postby cdndctx » Fri Jul 23, 2010 6:29 pm

Okay so I figured how to turn on Secondary logon and got the 8.3.x installed but now when i try and start PT3 I get an error connecting to default database. I have read through the firewall guide but i am not running any fire wall other than the xp one and it has never been a problem before.

Please advise.
cdndctx
 
Posts: 3
Joined: Fri Dec 19, 2008 7:26 pm

Re: Upgrading Database version problem?

Postby cdndctx » Fri Jul 23, 2010 7:18 pm

Also on the error page in the top right hand corner it says Postgresql v0.0.0 but i have installed successfully 8.3.11 twice and can not get PT3 to work! :evil:
cdndctx
 
Posts: 3
Joined: Fri Dec 19, 2008 7:26 pm

Re: Upgrading Database version problem?

Postby WhiteRider » Sat Jul 24, 2010 6:57 am

cdndctx wrote:I created a backup like you said. When I uninstalled the old 8.2 i chose to follow step the step to preserve the database because i did not want to accidently delete the database i backed up.

You can't do this between different major versions (8.2 to 8.3). That is why you need a backup of your database - you need to do a complete fresh install of 8.3 and then restore your database using PT3. Try following the How to reinstall PostgreSQL guide to fully uninstall and re-install 8.3.
Once PT3 can connect to PostgreSQL then you can use File > Restore to recover your database.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests