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.klaver@aklaver.com