"Daniel Westermann (DWE)" <daniel.westermann@xxxxxxxxxxxxxxxx> writes: > we have a very strange behavior on PostgreSQL 12.3 when we try to create the extension postgis. Postgres and postgis have both been installed from packages: > ... > The process eats all the available memory and finally dies: > # create extension postgis; > ERROR: out of memory > DETAIL: Failed on request of size 8265691 in memory context "PortalContext". > Time: 773569.877 ms (12:53.570) Quite odd. There should have been a memory context dump written to the postmaster's stderr, can you show that? Also possibly useful would be a backtrace (set a breakpoint at errfinish): https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend regards, tom lane
