Re: [gentoo-user] postgresql weird incompatibility problem
-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- -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] postgresql weird incompatibility problem
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? -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] postgresql weird incompatibility problem
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 [EMAIL PROTECTED]: 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? -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] postgresql weird incompatibility problem
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 -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] postgresql weird incompatibility problem
-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- -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] postgresql weird incompatibility problem
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 -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] postgresql weird incompatibility problem
That worked perfectly, thanks for all your help people. 2007/10/16, Albert Hopkins [EMAIL PROTECTED]: 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 -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] postgresql weird incompatibility problem
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 signature.asc Description: This is a digitally signed message part.
