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@xxxxxxxxxxx
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@xxxxxxxxxxx
