Re: Trouble Upgrading Postgres

On 11/5/18 8:50 AM, Charles Martin wrote:
> Daniel said:
>

> This appears to be the case. I ran:
>
> SELECT max(length(docfilecontents::text)) FROM docfile;
>  and after a very long time, got:
> ERROR: invalid memory alloc request size 1636085512 SQL state: XX000
>
> Adrian said:
>>> Ok, thanks for explaining this. Here is the current value:
>>> "shared_buffers""131072""8kB"
> >It should be a single value something like this for the default:
> >shared_buffers = 128MB
>
> The results I pasted were from:
>
> SELECT * FROM pg_settings
>
> Maybe I didn't get it the right way.
>
> The system has only 4GB of RAM. I read that a reasonable swap size is
> 1/4 of RAM, so I've created a swap file of 1GB.

I would change the shared_buffers setting to 128MB and retry.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com