Re: Out of Memory errors while running pg_dump

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Out of Memory errors while running pg_dump
Дата
Msg-id 1202250480.24634.44.camel@dogma.ljc.laika.com
обсуждение исходный текст
Ответ на Re: Out of Memory errors while running pg_dump  (Erik Jones <erik@myemma.com>)
Ответы Re: Out of Memory errors while running pg_dump
Список pgsql-general
On Mon, 2008-02-04 at 16:11 -0600, Erik Jones wrote:
> > Are you sure the postmaster is being launched
> > under ulimit unlimited?
>
> ulimit -a gives:
>
> core file size        (blocks, -c) unlimited
> data seg size         (kbytes, -d) unlimited
> file size             (blocks, -f) unlimited
> open files                    (-n) 256
> pipe size          (512 bytes, -p) 10
> stack size            (kbytes, -s) 10240
> cpu time             (seconds, -t) unlimited
> max user processes            (-u) 16357
> virtual memory        (kbytes, -v) unlimited
>

If you are using FreeBSD, is it possible you ran into the kern.maxdsiz
kernel tunable? It can only be adjusted at boot, I think.

Regards,
    Jeff Davis


В списке pgsql-general по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: How to track query execution time
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Empty to NULL conversion - Ruby - Postgres ?