Re: Trouble Upgrading Postgres - Mailing list pgsql-general

From Ron
Subject Re: Trouble Upgrading Postgres
Date
Msg-id ce4e1078-adc8-6a53-55e1-5ee7b0369586@gmail.com
Whole thread Raw
In response to Re: Trouble Upgrading Postgres  (Charles Martin <ssappeals@gmail.com>)
List pgsql-general
On 11/05/2018 11:06 AM, Charles Martin wrote:
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?

Linux already knows about the 1GB file; just add a 3GB swap file on the 230GB drive.

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Charles Martin
Date:
Subject: Re: Trouble Upgrading Postgres
Next
From: "Daniel Verite"
Date:
Subject: Re: Trouble Upgrading Postgres