From: | Grant Maxwell <grant(dot)maxwell(at)maxan(dot)com(dot)au> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: "show all" command crashes server |
Date: | 2009-09-10 22:02:41 |
Message-ID: | E5601F5E-846F-45D9-8742-8EE6159A9439@maxan.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/09/2009, at 1:09 AM, Richard Huxton wrote:
>
>
>> 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?
How can I determine what modules are installed ?
I do know that pgmemcache is installed on this server - but it was
there before the problems started and it works ok.
>
> Can you "show" individual variables?
I did a show all on one of the other servers, created a script to
use each of the resulting outputs in a single show statement and ran
on the problem server.
It ran without a fault.
I then took the postgresql.conf file from the problem server,
grabbed all the config lines and submitted them one at a time (again
with a script) and it also
worked fine.
regards
Grant Maxwell
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-09-10 22:17:34 | Re: "show all" command crashes server |
Previous Message | David Brain | 2009-09-10 21:18:07 | Re: Unable to drop a table due to seemingly non-existent dependencies |