pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Morus Walter <morus.walter@tanto.de>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: when datas filesystem is full how to do
Date: Wed, 16 Feb 2005 14:57:53 +0100
Message-ID: <16915.20833.452186.548671@tanto-xipolis.de> (raw)
In-Reply-To: <421347DD.2090602@3times25.net>
References: <nD949783794582.03450@send2.inner-21cn.com>
	<421347DD.2090602@3times25.net>

Geoffrey writes:
> guly wrote:
> > 	I have installed postgresql in /usr/local filesystem on RH Linux. But Running for two months,the datas are growing too fast.There is no enough space at /usr/local filesystem. I want to make this filesystem bigger or move the database to another 
> > filesystem and don't stop the database.Someone can tell me how to do that?Thanks.
> 
> I don't know about all the aspects regarding Postgresql, but you could
> create another partition, either from current free space, or by adding
> another drive and migrate /usr/local to it.
> 
I guess the problem is, that he doesn't want to stop the database.

I'd rather suggest to look into tablespaces.
Create a new tablespace on some other filesystem and move the contents
of the database by using ALTER TABLE/INDEX SET TABLESPACE...
Presumably part of the data will remain on /usr/local but if the goal
is to provide sufficiant space that should not harm.
Of course that's assuming we speak of PG 8 here.

But I'd make sure first, that it's really the data and not unvacuumed 
space or no longer needed WALs filling the disk.

For details see postgresqls excellent docs (I can say that, I'm also 
just learning postgresql from the docs).

Note that I didn't test that.

HTH
Morus





view thread (4+ messages)  latest in thread

Message-ID: <16915.20833.452186.548671@tanto-xipolis.de>
Permalink:  ../16915.20833.452186.548671@tanto-xipolis.de/
Also on:    postgresql.org/message-id/16915.20833.452186.548671@tanto-xipolis.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: morus.walter@tanto.de
  Subject: Re: when datas filesystem is full how to do
  In-Reply-To: <16915.20833.452186.548671@tanto-xipolis.de>
  References: <nD949783794582.03450@send2.inner-21cn.com> <421347DD.2090602@3times25.net> <16915.20833.452186.548671@tanto-xipolis.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox