Re: Error while upgrading from 8.4 to 9.3

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(dot)biasatti(at)griensu(dot)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(dot)klaver(at)aklaver(dot)com