Arch Linux

red_over_blue

Member

Registered: 2003-07-19

Posts: 152

postgresql 7.4-1 WARNING

Well, I've stared at the possible upgrade from postgresql 7.3.4-1 to 7.4-1 and kept thinking "if it ain't broke, don't fix it."  However, as many of you know, I like to play on the bleeding edge side of the fence.  However, this upgrade was a mistake.

Postgresql 7.4-1 will not start, and the logs give the following. 

LOG:  database system is shut down
FATAL:  database files are incompatible with server
DETAIL:  The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.

---

Don't forget to post your PKGBUILD in your thread when you announce a new package in incoming.
see HERE for details

sarah31

Member

From: Middle of Canada

Registered: 2002-08-20

Posts: 2,975

Website

Re: postgresql 7.4-1 WARNING

hum i remember reading something here at arch about this and the solution. did you dio a search or talk to dorphell. it seem to remember the solutionwas easy.

---

AKA uknowme

I am not your friend

red_over_blue

Member

Registered: 2003-07-19

Posts: 152

Re: postgresql 7.4-1 WARNING

sarah31,

I can't seem to find anything here (bbs) on this topic.  I haven't had a chance to google about this or talk to dorphell.  I just wanted to warn others who might be using postgresql in a mission critical way that they could run into problems.

If I find the solution, or someone lets me know, I'll be sure to post it here.

---

Don't forget to post your PKGBUILD in your thread when you announce a new package in incoming.
see HERE for details

sarah31

Member

From: Middle of Canada

Registered: 2002-08-20

Posts: 2,975

Website

Re: postgresql 7.4-1 WARNING

if you have any irc logs from #archlinux i am pretty sure it was mentioned earlier this week now that i think of it.

---

AKA uknowme

I am not your friend

nelson

Member

From: Argentina

Registered: 2003-10-08

Posts: 10

Re: postgresql 7.4-1 WARNING

The only solution I found time ago, was reinstall 7.1 make a backup,  install 7.2 and make a restore..... may be this is the path to this version too.... Generaly in the release docs say when change the directory structure and need a backup/restore to upgrade

Maybe pacman could handle some option in the install script to alert the user about this kind situation and ask about continue or cancel.....

:: Nelson ::

hApy

Member

From: Victoria, BC

Registered: 2003-04-13

Posts: 194

Website

Re: postgresql 7.4-1 WARNING

probably just a post-install script that just prints some instructions would work, without requiring any special (new) functionality from pacman.

Hapy.