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

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. +