You are not logged in.
- Topics: Active | Unanswered
#1 2011-11-04 08:41:51
- ManuP
- Member
- Registered: 2009-10-18
- Posts: 15
[solved]Postgresql 9.1.1 upgrade issue
Hi, I've got a problem with postgresql since i upgraded it to 9.1.1.
Error massages are:
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 9.0, which is not compatible with this version 9.1.1.
I tried pg_upgrade but I just get error messages.
Since there its only a testing environment I would simply like to delete the database but I got no idea which files to delete.
Thanks for any help.
Last edited by ManuP (2011-11-04 11:30:31)
Offline
#2 2011-11-04 08:46:57
- wonder
- Developer
- From: Bucharest, Romania
- Registered: 2006-07-05
- Posts: 5,941
- Website
Re: [solved]Postgresql 9.1.1 upgrade issue
look at postgresql optional dependencies.
Optional Deps : python2: for PL/Python support
perl: for PL/Perl support
postgresql-old-upgrade: upgrade from previous major version using pg_upgrade
Give what you have. To someone, it may be better than you dare to think.
Offline
#3 2011-11-04 09:25:15
- ManuP
- Member
- Registered: 2009-10-18
- Posts: 15
Re: [solved]Postgresql 9.1.1 upgrade issue
I tried that but the wiki is outdated at that point. The directories are wrong.
Offline
#4 2011-11-04 09:26:41
- wonder
- Developer
- From: Bucharest, Romania
- Registered: 2006-07-05
- Posts: 5,941
- Website
Re: [solved]Postgresql 9.1.1 upgrade issue
you don't really have to copy blindly the commands. you need to adapt to the current situation
Give what you have. To someone, it may be better than you dare to think.
Offline
#5 2011-11-04 09:58:57
- ManuP
- Member
- Registered: 2009-10-18
- Posts: 15
Re: [solved]Postgresql 9.1.1 upgrade issue
I know that...
What i dont know is the command to do it right.
I am not that familiar with the directories postgres stores its data in.
Thanks anyway.
Offline
#6 2011-11-04 10:26:17
- teekay
- Member
- Registered: 2011-10-26
- Posts: 271
Re: [solved]Postgresql 9.1.1 upgrade issue
The data is stored in /var/lib/postgres/ by default (the wiki indeed is wrong here, maybe on purpose)
1. shutdown the database
2. rename /var/lib/postgres/data to /var/lib/postgres/olddata
3. start database (will run initdb which creates 9.1 /var/lib/postgres/data )
4. stop it again
5. run pg_upgrade, or start old version and use pg_dumpall as described
Offline
#7 2011-11-04 11:29:48
- ManuP
- Member
- Registered: 2009-10-18
- Posts: 15
Re: [solved]Postgresql 9.1.1 upgrade issue
Thanks you are seriously my hero for today. 
Offline
#8 2011-11-04 11:34:40
- wonder
- Developer
- From: Bucharest, Romania
- Registered: 2006-07-05
- Posts: 5,941
- Website
Re: [solved]Postgresql 9.1.1 upgrade issue
anyone want to fix the wiki?
Give what you have. To someone, it may be better than you dare to think.
Offline
#9 2011-11-10 21:54:41
- teekay
- Member
- Registered: 2011-10-26
- Posts: 271
Re: [solved]Postgresql 9.1.1 upgrade issue
anyone want to fix the wiki?
Done.
Offline