Re: Error while upgrading from 8.4 to 9.3

On 2014-05-28 07:39:33 -0700, Adrian Klaver wrote:
> On 05/28/2014 07:24 AM, Claudio Biasatti wrote:
> >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'
> >
> >
>
> So what are the port numbers in the conf files.
>
> I have not used that option, but is there a chance you are double
> starting the servers?
>
> Starting an instance for each using the port numbers from the conf
> files and then pg_upgrade is starting them on 50432.
>
>

Sorry guys, one of the in-site tech support guys started the postgresql
service while we were trying to do the upgrade. Looks like this was the
cause of the failure.

Regards,

--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877