Re: BUG #12670: Can't create postgis extension in single-user mode - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #12670: Can't create postgis extension in single-user mode
Date
Msg-id 20150129190712.GB7402@momjian.us
Whole thread Raw
In response to Re: BUG #12670: Can't create postgis extension in single-user mode  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-bugs
On Wed, Jan 28, 2015 at 04:26:03PM +0100, Andres Freund wrote:
> On 2015-01-28 01:05:20 +0000, Andrew Gierth wrote:
> > >>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
> >
> >  >> [ Can't create postgis extension in single-user mode ]
> >
> >  Tom> Why in the world would you think that's a good thing to do?
> >
> > The context, for what it's worth, is setting up docker containers, so
> > there's a reasonable desire to be able to do some basic database setup
> > before starting any listener.
>
> Well, that's about as easily done using a nonstandard/private socket
> directory. Has the advantage of being able to use a sane client, useful
> error handling, performance ...

Yes, that's what pg_upgrade does.  Windows doesn't have sockets, which
limits that option for general use.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #12670: Can't create postgis extension in single-user mode
Next
From: Tom Lane
Date:
Subject: Re: BUG #12694: crash if the number of result rows is lower than gin_fuzzy_search_limit