Re: pg_dump error - out of memory, Failed on request of size 536870912

[Stefan Kaltenbrunner <stefan@xxxxxxxxxxxxxxxx>]

Marcin Citowicki wrote:
> Hello,
>
> I forgot to add - all those 'out of memory' errors happen when backup db 
> is trying to create index. Every 'CREATE INDEX' operation is followed by 
> 'out of memory' error.

are you sure that your OS (or ulimit) is able to support a 
maintenance_work_setting that large ? - try reducing to a say 128MB for 
a start and try again.


Stefan