Re: Error while upgrading from 8.4 to 9.3

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "Leonardo M(dot) Ramé" <l(dot)rame(at)griensu(dot)com>, Claudio Biasatti <c(dot)biasatti(at)griensu(dot)com>, PostgreSql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Error while upgrading from 8.4 to 9.3
Date: 2014-05-29 02:30:53
Message-ID: 20140529023053.GC28469@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 do the upgrade. Looks like this was the
> >>cause of the failure.
> >
> >OK. We block users from connecting to our own postmaster by placing the
> >socket files in the current directory, but that doesn't prevent someone
> >from starting the server using the default configuration. Not sure how
> >we could block that.
> >
>
> 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.

Starting Postgres outside pg_upgrade would _certainly_ cause a problem.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-05-29 03:28:47 Re: Error while upgrading from 8.4 to 9.3
Previous Message Adrian Klaver 2014-05-28 23:56:53 Re: Error while upgrading from 8.4 to 9.3