Re: BUG #6392: leak memory while restore/load dump

On 11.01.2012 02:24, vic@nix.kh.ua wrote:
> The following bug has been logged on the website:
>
> Bug reference:      6392
> Logged by:          Vic
> Email address:      vic@nix.kh.ua
> PostgreSQL version: 9.0.6
> Operating system:   FreeBSD/Linux
> Description:
>
> While trying load database dump, postgresql (server process) eat up all
> memory, including swap.
>
> This problem start after update on 9.0.6 and same problem with 9.1.2.
>
> PostgreSQL version 9.0.5 load same dump  without problem.

You probably have an inet field in the database. 9.0.6/9.1.2 contained a
bug causing a memory leak in inet/cidr functions. See:

http://archives.postgresql.org/pgsql-committers/2011-12/msg00086.php
http://archives.postgresql.org/pgsql-bugs/2011-12/msg00068.php

This will be fixed in 9.0.7/9.1.3.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com