Re: "show all" command crashes server

Grant Maxwell <grant.maxwell@maxan.com.au> writes:
> On the problem server:
>     shared_preload_libraries = 'pgmemcache'
>     #local_preload_libraries = ''

> on the others both are emply.

Sounds like a smoking gun to me.

> For good measure I removed pgmemcache but the problem persists.

Did you restart the postmaster afterwards?  shared_preload_libraries
is only considered at postmaster start.

            regards, tom lane