Re: Trouble Upgrading Postgres

Ron said:

>We were expecting the output of the "SHOW SHARED_BUFFERS;" command.

Ok, the result from that command is:

1GB

>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.

>Times have changed... (I'd have made a 4GB swap file.)

I have a spare drive that is 230G, so I have enough space. I suppose I can
set swapoff, delete the swapfile, create a new 4G one, and set swapon. Or
is there a better way?

On Mon, Nov 5, 2018 at 11:56 AM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> On 11/05/2018 10:50 AM, Charles Martin wrote:
> [snip]
>
> The results I pasted were from:
>
> SELECT * FROM pg_settings
>
> Maybe I didn't get it the right way.
>
>
> We were expecting the output of the "SHOW SHARED_BUFFERS;" command.
>
>
> 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.
>
>
> Times have changed... (I'd have made a 4GB swap file.)
>
>
> --
> Angular momentum makes the world go 'round.
>