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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
