Re: Error while upgrading from 8.4 to 9.3
От | Claudio Biasatti |
---|---|
Тема | Re: Error while upgrading from 8.4 to 9.3 |
Дата | |
Msg-id | 81E8541BCEE54775BC387BD8555AB2F6@medicalit01 обсуждение исходный текст |
Ответ на | Re: Error while upgrading from 8.4 to 9.3 (Adrian Klaver <adrian.klaver@aklaver.com>) |
Список | pgsql-general |
with check /usr/lib/postgresql/9.3/bin/pg_upgrade --check -b /usr/lib/postgresql/8.4/bin/ -B /usr/lib/postgresql/9.3/bin/ -d /mnt/datos/ -D /mnt/datos/datos_9.3/main/ -o ' -c config_file=/etc/postgresql/8.4/main/postgresql.conf' -O ' -c config_file=/etc/postgresql/9.3/main/postgresql.conf' without check /usr/lib/postgresql/9.3/bin/pg_upgrade -b /usr/lib/postgresql/8.4/bin/ -B /usr/lib/postgresql/9.3/bin/ -d /mnt/datos/ -D /mnt/datos/datos_9.3/main/ -o ' -c config_file=/etc/postgresql/8.4/main/postgresql.conf' -O ' -c config_file=/etc/postgresql/9.3/main/postgresql.conf' ----Mensaje original----- From: Adrian Klaver Sent: Wednesday, May 28, 2014 11:15 AM To: "Leonardo M. Ramé" ; PostgreSql-general Cc: c.biasatti@griensu.com Subject: Re: [GENERAL] Error while upgrading from 8.4 to 9.3 On 05/28/2014 06:19 AM, Leonardo M. Ramé wrote: > Hi, we are trying to upgrade from 8.4 to 9.3, but at the end of the > process we've got the error: > > command: "/usr/lib/postgresql/9.3/bin/pg_resetxlog" -o 2429057 > "/mnt/datos/datos_9.3/main" >> "pg_upgrade_utility.log" 2>&1 > pg_resetxlog: lock file «postmaster.pid» exists > Is a server running? If not, delete the lock file and try again. > > Our setup is this: > Server: Ubuntu 12.04 – 32 bits > Clusters: Postgresql 8.4 y Postgresql 9.3 > > The steps we followed are: > > 1) pg_upgrade using –-check result Ok. > 2) pg_upgrade without --check Can you show us the complete command with arguments for both 1 & 2 above? > > Everything went ok, data directory was copied without problems. > > At the end, we got the error I mentioned at the beggining of this email. > > P.S.: pg_upgrade_utility.log attached. > > Regards, > > > > -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: