*no more mesages please* Andrus escribió:
I have separate production server running "PostgreSQL 8.1.4 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.4.6 (Gentoo 3.4.6-r1, ssp-3.4.5-1.0, pie-8.7.9)" and want to upgrade this to something newer. I can allow some hours of downtime for upgrade at night. I have found Gentoo upgrade instructions here http://hasno.info/2008/7/31/upgrading-to-postgresql-8-3-on-gentoo I have no idea how PostgreSql is installed in this server, maybe it is compiled from source. So I'm afraid that using those instructions may corrupt the server so it will no longer come up in morning and I'm not able to fix it due to lack of allowed downtime and knowledge. So I'm planning the following strategy: 1. Create backup copy in this 8.1.4 2. Stop postmaster 3. Install latest version of PostgreSql to separate directory 4. Restore to it from backup 5. If something fails, stop new and re-start old 8.1.4 postmaster. The difficult point for me is (3). How to install latest version in gentoo side-by side so that old version is not touched? In windows it is easy: I can select other directory from installer. How to do same thing in this Gentoo ? I need also adminpack to read log files from pgAdmin. Andrus.
Aviso Legal Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia, distribucion o uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los correos electonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran afectar al mensaje original.
begin:vcard fn:Adriana Alfonzo n:Alfonzo;Adriana org;quoted-printable:Gcia. Sistemas y Organizaci=C3=B3n;Proy. Software Libre adr;quoted-printable:;;;Pto. Ordaz;Bol=C3=ADvar;;Venezuela email;internet:adriana.alfonzo@xxxxxxxxxxxxxx title:Analista Ext. 5694 tel;work:5694 version:2.1 end:vcard
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general