Re: Error while upgrading from 8.4 to 9.3 - Mailing list 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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +