Re: [GENERAL] Error while upgrading from 8.4 to 9.3

2014-05-30 Thread Bruce Momjian
On Wed, May 28, 2014 at 11:28:47PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > On Wed, May 28, 2014 at 04:56:53PM -0700, Adrian Klaver wrote: > >> So for my edification, does that mean -O ' -c > >> config_file=/etc/postgresql/9.3/main/postgresql.conf' could cause a > >> problem or that st

Re: [GENERAL] Error while upgrading from 8.4 to 9.3

2014-05-28 Thread Tom Lane
Bruce Momjian writes: > On Wed, May 28, 2014 at 04:56:53PM -0700, Adrian Klaver wrote: >> So for my edification, does that mean -O ' -c >> config_file=/etc/postgresql/9.3/main/postgresql.conf' could cause a >> problem or that starting Postgres outside pg_upgrade could cause a >> problem, or both

Re: [GENERAL] Error while upgrading from 8.4 to 9.3

2014-05-28 Thread Bruce Momjian
On Wed, May 28, 2014 at 04:56:53PM -0700, Adrian Klaver wrote: > On 05/28/2014 08:15 AM, Bruce Momjian wrote: > >On Wed, May 28, 2014 at 12:05:54PM -0300, Leonardo M. Ramé wrote: > > >> > >>Sorry guys, one of the in-site tech support guys started the postgresql > >>service while we were trying to

Re: [GENERAL] Error while upgrading from 8.4 to 9.3

2014-05-28 Thread Adrian Klaver
On 05/28/2014 08:15 AM, Bruce Momjian wrote: On Wed, May 28, 2014 at 12:05:54PM -0300, Leonardo M. Ramé wrote: 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. OK. We block

Re: [GENERAL] Error while upgrading from 8.4 to 9.3

2014-05-28 Thread Claudio Biasatti
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.biasa...@griensu.com Subject: Re: [GENERAL] Error while upgrading from 8.4 to 9.3 On 05/28/2014 06:19 AM, Leonardo

Re: [GENERAL] Error while upgrading from 8.4 to 9.3

2014-05-28 Thread Bruce Momjian
On Wed, May 28, 2014 at 12:05:54PM -0300, Leonardo M. Ramé wrote: > 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/post

Re: [GENERAL] Error while upgrading from 8.4 to 9.3

2014-05-28 Thread Leonardo M . Ramé
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 > >con

Re: [GENERAL] Error while upgrading from 8.4 to 9.3

2014-05-28 Thread Adrian Klaver
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_fil

Re: [GENERAL] Error while upgrading from 8.4 to 9.3

2014-05-28 Thread Bruce Momjian
On Wed, May 28, 2014 at 10:19:24AM -0300, 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

Re: [GENERAL] Error while upgrading from 8.4 to 9.3

2014-05-28 Thread Adrian Klaver
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 «p

[GENERAL] Error while upgrading from 8.4 to 9.3

2014-05-28 Thread Leonardo M . Ramé
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