Grant Maxwell writes:
> The error was that if "show all" was run on this postgresql (version
> 8.3) server, postgres would crash and then recover.
> The postgres log showed:
> Sep 10 23:55:36 theconsole postgres[31118]: [4-1] 0: LOG: 0:
> server process (PID 31145) was te
First of all thanks to those who provided input.
This problem is now fixed and I thought I would post this solution so
that others might benefit in the future.
For the sake of completeness:
The error was that if "show all" was run on this postgresql (version
8.3) server, postgres would cr
Grant Maxwell writes:
> On 11/09/2009, at 8:36 AM, Tom Lane wrote:
>> Did you restart the postmaster afterwards?
> yep - full restart.
okay, next step is to collect a stack trace ...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgres
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> shared_preload_libraries = 'pgmemcache'
...
> Sounds like a smoking gun to me.
Yep, known problem with pgmemcache. Bruce and I poked around
with this about a year ago. Bruce, I think you were going
to throw the problem at some EDB people - di
On 11/09/2009, at 8:36 AM, Tom Lane wrote:
Grant Maxwell 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 pro
Grant Maxwell 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
On 11/09/2009, at 8:17 AM, Tom Lane wrote:
Grant Maxwell writes:
On 11/09/2009, at 1:09 AM, Richard Huxton wrote:
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
Grant Maxwell writes:
> On 11/09/2009, at 1:09 AM, Richard Huxton wrote:
>> 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 ?
The contents of the local_preloa
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 ow
On Thu, Sep 10, 2009 at 8:37 AM, 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).
> I have three of these servers and gene
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
11 matches
Mail list logo
