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(at)sss(dot)pgh(dot)pa(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +