Re: Disk space - Mailing list pgsql-novice

From David Lloyd
Subject Re: Disk space
Date
Msg-id 3D91386C.6402AC44@rebel.net.au
Whole thread Raw
In response to Disk space  ("Joachim Smit" <jo@chimsmit.com>)
List pgsql-novice
Hi There,

> I have 8Gb free disk space. What should I do?

1) Work out where Postgres is storing the database
 - on my RH 7.1 + Postgres 7.2.2 it's in /var/lib/pgsql

2) Work out what partition that is in
 - in /var for me

3) Do a `df' to see how much space is left on that partition

You can have terabytes of space on a disk left over, but still run out
of space in a user defined partition.

DSL
--
Qualcuno no mi basta.
  Vivere cercando il grande amore.
  Vivere come se mai dovessimo morire.
(Anastasio, Valli e Travato)

pgsql-novice by date:

Previous
From: "Jim Steil"
Date:
Subject: Newbie help needed on Functions
Next
From: HK
Date:
Subject: Executing multiple statements in a single query?