Hmm. That is suspiciously close to the location of some last-minute
changes in Postgres 9.0. I wonder whether Andrea is using a version of
PostGIS that was compiled against pre-9.0RC1 Postgres sources.
If so, I am to and it's the latest PostGIS binary from their website.
Hi,
Yes, I will
On 5/10/2010 10:02 AM, Tom Lane wrote:
Craig Ringer writes:
After turning autovacuum off completely, though, it does crash when
ANALYZE is run.
postgres.exe!pfree(void * pointer=0x68f08610) Line 591 + 0x3 bytes C
postgres.exe!examine_attribute(RelationData * onerel=0x, int attnu
Craig Ringer writes:
> After turning autovacuum off completely, though, it does crash when
> ANALYZE is run.
>> postgres.exe!pfree(void * pointer=0x68f08610) Line 591 + 0x3 bytes C
>> postgres.exe!examine_attribute(RelationData * onerel=0x, int
>> attnum=5, Node * index_expr=0x000
On 4/10/2010 10:56 AM, Tom Lane wrote:
Craig Ringer writes:
While it's consistently crashing my Pg 9 on win7 32-bit, too, I haven't
been able to get a backtrace yet. I thought it'd be trivial given the
ease of reproducing the crash - but the process that's crashing isn't
the backend running the
Hi,
I have do some other test.
I set
autovacuum = off.
With this setting the server don't crash.
But certainly something go bad.
Infact
if (after run the query) I connect with posql as user 'postgres' and try
a single command
VACUUM;
nothing happened.
But if I try a
single command
ANALYZE;
Just an update on this issue:
I've been able to reproduce the crash (thanks for the test case!) and
obtain the crash information here on my 32-bit windows 7 install, so
there's no need for you to do anything else so far.
I still can't get a usable backtrace. The autovacuum workers/launcher
sp
On 04/10/10 10:56, Tom Lane wrote:
> Craig Ringer writes:
>> While it's consistently crashing my Pg 9 on win7 32-bit, too, I haven't
>> been able to get a backtrace yet. I thought it'd be trivial given the
>> ease of reproducing the crash - but the process that's crashing isn't
>> the backend r
Craig Ringer writes:
> While it's consistently crashing my Pg 9 on win7 32-bit, too, I haven't
> been able to get a backtrace yet. I thought it'd be trivial given the
> ease of reproducing the crash - but the process that's crashing isn't
> the backend running the query.
> It looks like it's o
On 10/03/2010 05:11 PM, Andrea Peri wrote:
Hi, thx for response.
>Does that include PostGIS datatypes?
yes, but after some email with the guys of Posgis team , I think the
problem is related to postgres.
(see this thread on postgis ML):
http://postgis.refractions.net/pipermail/postgis-users/2
On 4/10/2010 4:41 AM, Andrea Peri 2007 wrote:
Hi,
I have some update on the crash of pg9.0.
seem that PG9 will crash even on windows 32bit.
Yes, it will. I've just been able to reproduce it here with your script,
on 32-bit win7. I should be able to report where it's crashing shortly.
I gav
Hi,
I have some update on the crash of pg9.0.
seem that PG9 will crash even on windows 32bit.
But meanwhile in win7-64 bit crash always at first try, in win7 32bit it
crash
from first and second time after restart.
As report here from Postgis Team.
http://postgis.refractions.net/pipermail/p
>Truly, the most helpful thing at this point would be to collect a
backtrace showing where in the postgresql server it crashed.
>There are instructions on how to do that here:
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows
>In your case, a
Hi, thx for response.
>Does that include PostGIS datatypes?
yes, but after some email with the guys of Posgis team , I think the problem
is related to postgres.
(see this thread on postgis ML):
http://postgis.refractions.net/pipermail/postgis-users/2010-October/027841.html
The postgis team was
On 2/10/2010 9:08 PM, Andrea Peri wrote:
Hi,
I'm using usually
Postgres 8.4.4 (32bit) + Postgis 1.5.1 on Windows7 64bit.
Now I try-ing the last
Postgres 9.0 (32bit) + Postgis 1.5.2 on the same machine (win7 64bit).
I experience a
crash of Postgres while it is running a huge load of data.
Do
Hi,
I'm using usually
Postgres 8.4.4 (32bit) + Postgis 1.5.1 on Windows7 64bit.
Now I try-ing the last
Postgres 9.0 (32bit) + Postgis 1.5.2 on the same machine (win7 64bit).
I experience a
crash of Postgres while it is running a huge load of data.
This is the report of log.
2010-10-01 22:38:
15 matches
Mail list logo
