[gentoo-user] postgresql weird incompatibility problem

[gentoo-user] postgresql weird incompatibility problem

[Rafael Barrera Oro]

[-- Attachment #1: Type: text/plain, Size: 496 bytes --]

I unmerged postgresql 8.0.3 in order to emerge 8.2.x, now when i try to do
anything i get the following message:

psql: FATAL:  database files are incompatible with server
DETAIL:  The data directory was initialized by PostgreSQL version 8.2, which
is not compatible with this version 8.0.13.

i deleted previous /var/lib/postgresql in order to be able to emerge the new
version, so i am clueless...

does this ring a bell for anyone?

as usual, thanks in advance to all

sincerely yours

Rafael

[-- Attachment #2: Type: text/html, Size: 551 bytes --]

Re: [gentoo-user] postgresql weird incompatibility problem

[Albert Hopkins]

On Tue, 2007-10-16 at 11:53 -0300, Rafael Barrera Oro wrote:
> I unmerged postgresql 8.0.3 in order to emerge 8.2.x, now when i try
> to do anything i get the following message:
> 
> psql: FATAL:  database files are incompatible with server
> DETAIL:  The data directory was initialized by PostgreSQL version 8.2,
> which is not compatible with this version 8.0.13.
> 
> i deleted previous /var/lib/postgresql in order to be able to emerge
> the new version, so i am clueless...
> 
> does this ring a bell for anyone?

Did you stop postgres *before* uninstalling it and
removing /var/lib/postgresql?  Also did you "emerge --config
postgresql-..." *after* installing the new postgres?

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] postgresql weird incompatibility problem

[Arturo 'Buanzo' Busleiman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Rafael Barrera Oro wrote:
> i deleted previous /var/lib/postgresql in order to be able to emerge the
> new version, so i am clueless...

So, you deleted your databases?? Please tell us you have a copy!

- --
Arturo "Buanzo" Busleiman - Consultor Independiente en Seguridad Informatica
Servicios Ofrecidos: http://www.buanzo.com.ar/pro/
Unase a los Foros GNU/Buanzo - La palabra Comunidad en su maxima expresion.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHFNJfAlpOsGhXcE0RCgAvAJ0R3DqD6pvutyyjYLrXNlom1jJ3wgCfQjn1
BgBsIuMvzqmg4To2TEm1jFY=
=ZTQG
-----END PGP SIGNATURE-----
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] postgresql weird incompatibility problem

[Albert Hopkins]

On Tue, 2007-10-16 at 12:01 -0300, Arturo 'Buanzo' Busleiman wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA512
> 
> Rafael Barrera Oro wrote:
> > i deleted previous /var/lib/postgresql in order to be able to emerge the
> > new version, so i am clueless...
> 
> So, you deleted your databases?? Please tell us you have a copy!

I'm guessing he deleted them because he no longer needed them(?).

-a

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] postgresql weird incompatibility problem

[Rafael Barrera Oro]

[-- Attachment #1: Type: text/plain, Size: 1027 bytes --]

I just installed it so i did not have any useful data. I must admit though,
i did not stop the database before unmerging and emerging, however i did run
emerge --config afterwards.

Thanks for the replies :D

2007/10/16, Albert Hopkins <marduk@letterboxes.org>:
>
>
> On Tue, 2007-10-16 at 11:53 -0300, Rafael Barrera Oro wrote:
> > I unmerged postgresql 8.0.3 in order to emerge 8.2.x, now when i try
> > to do anything i get the following message:
> >
> > psql: FATAL:  database files are incompatible with server
> > DETAIL:  The data directory was initialized by PostgreSQL version 8.2,
> > which is not compatible with this version 8.0.13.
> >
> > i deleted previous /var/lib/postgresql in order to be able to emerge
> > the new version, so i am clueless...
> >
> > does this ring a bell for anyone?
>
> Did you stop postgres *before* uninstalling it and
> removing /var/lib/postgresql?  Also did you "emerge --config
> postgresql-..." *after* installing the new postgres?
>
> --
> gentoo-user@gentoo.org mailing list
>
>

[-- Attachment #2: Type: text/html, Size: 1422 bytes --]

Re: [gentoo-user] postgresql weird incompatibility problem

[Albert Hopkins]

On Tue, 2007-10-16 at 12:10 -0300, Rafael Barrera Oro wrote:
> I just installed it so i did not have any useful data. I must admit
> though, i did not stop the database before unmerging and emerging,
> however i did run emerge --config afterwards.
> 

You should have stopped the database before you remove the database
files... Did you ever stop the database?  If not, you're still running
8.0 while your emerge installed 8.2 files and then the database
naturally got confused.  The --config probably tried to connect to the
running 8.0 service and told it do do something with the installed 8.2
files.

It doesn't really matter *what* happened exactly.  The point is you
should just start over.

      * Stop postgres. kill all postgres processes.
      * unmerge postgress
      * remove /var/lib/postgresql
      * re-install posgress




-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] postgresql weird incompatibility problem

[Arturo 'Buanzo' Busleiman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Albert Hopkins wrote:
> I'm guessing he deleted them because he no longer needed them(?).

Luckily, he just mentioned that it was a fresh 8.0 install, so the databases were useless anyway :)

- --
Arturo "Buanzo" Busleiman - Consultor Independiente en Seguridad Informatica
Servicios Ofrecidos: http://www.buanzo.com.ar/pro/
Unase a los Foros GNU/Buanzo - La palabra Comunidad en su maxima expresion.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHFNeHAlpOsGhXcE0RCtbnAJ9xHEmnuZZlDy5rxXZpoTRwtOti8wCfZlzL
9rtD5Mnnvpi3bDSqKFINuaY=
=O5Dv
-----END PGP SIGNATURE-----
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] postgresql weird incompatibility problem

[Rafael Barrera Oro]

[-- Attachment #1: Type: text/plain, Size: 1045 bytes --]

That worked perfectly, thanks for all your help people.


2007/10/16, Albert Hopkins <marduk@letterboxes.org>:
>
>
> On Tue, 2007-10-16 at 12:10 -0300, Rafael Barrera Oro wrote:
> > I just installed it so i did not have any useful data. I must admit
> > though, i did not stop the database before unmerging and emerging,
> > however i did run emerge --config afterwards.
> >
>
> You should have stopped the database before you remove the database
> files... Did you ever stop the database?  If not, you're still running
> 8.0 while your emerge installed 8.2 files and then the database
> naturally got confused.  The --config probably tried to connect to the
> running 8.0 service and told it do do something with the installed 8.2
> files.
>
> It doesn't really matter *what* happened exactly.  The point is you
> should just start over.
>
>       * Stop postgres. kill all postgres processes.
>       * unmerge postgress
>       * remove /var/lib/postgresql
>       * re-install posgress
>
>
>
>
> --
> gentoo-user@gentoo.org mailing list
>
>

[-- Attachment #2: Type: text/html, Size: 1546 bytes --]

Re: [gentoo-user] postgresql weird incompatibility problem

[Dirk Heinrichs]

[-- Attachment #1: Type: text/plain, Size: 451 bytes --]

Am Dienstag, 16. Oktober 2007 schrieb Rafael Barrera Oro:

> I unmerged postgresql 8.0.3 in order to emerge 8.2.x

Please be aware that in the future, once you have real data in your databases, 
you would need to dump all the databases (pg_dump_all) prior to a major 
update, ((8.x -> 8.y), then, after update, re-initialize the database and 
import the dumps.

And that update is coming soon, 8.3 has entered beta phase.

Bye...

	Dirk

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 189 bytes --]