Re: "show all" command crashes server - Mailing list pgsql-general

From Richard Huxton
Subject Re: "show all" command crashes server
Date
Msg-id 4AA9169D.2050600@archonet.com
Whole thread Raw
In response to "show all" command crashes server  (Grant Maxwell <grant.maxwell@maxan.com.au>)
Responses Re: "show all" command crashes server
List pgsql-general
Grant Maxwell wrote:
> Hi folks
>
> First time poster here so please extend grace if I don't initially
> provide what is needed to help.
>
> I am running postgresql 8.3.7 on debian lenny
> (postgresql-8.3_8.3.7-0lenny1_i386.deb)

Well that's useful.

> I have three of these servers and generally they run well.

As is that.

> On this one server if I use the command "show all" in psql, phpPgAdmin
> or pgAdmin3 the postgresql server spits the dummy as follows:

> postgres=# show all;
> server closed the connection unexpectedly

Hmm - some modules can provide their own config variables. Do you have
the same modules installed in all three servers?

Can you "show" individual variables?

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [DOCS] What happens when syslog gets blocked?
Next
From: Sam Mason
Date:
Subject: Re: Adding integers ( > 8 bytes) to an inet