Re: And the error comes from ... - Mailing list pgsql-jdbc

From Andrew Sullivan
Subject Re: And the error comes from ...
Date
Msg-id 20020730175714.C16703@mail.libertyrms.com
Whole thread Raw
In response to Re: And the error comes from ...  ("Mihai Gheorghiu" <tanethq@earthlink.net>)
List pgsql-jdbc
On Tue, Jul 30, 2002 at 05:31:44PM -0400, Mihai Gheorghiu wrote:
> Thanks, everybody.
> It looks like my /var partition is 91% full. The server came pre-configured,
> while the /usr partition is used only 50%, and it won't grow. Can someone,
> please, recommend me a (safe :-) Linux utility that can reallocate disk
> space between partitions - if it exists?

I don't think that's a good idea.

You could link your data area into /usr/local.  Here's how.

1.    Shut down your database.
2.    cp -Rp /var/path/to/data/area /usr/local/new/data/area
3.    rm -r /var/path/to/data/area
4.    ln -s /usr/local/new/data/area /var/path/to/data/area

Now you should be able to start up as though everything is the same.

Alternatively, you could just reconfigure postgres to think that it
lives in a different data area.  That's more standard, but it might
break some scripts you have or something.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


pgsql-jdbc by date:

Previous
From: "Mihai Gheorghiu"
Date:
Subject: Re: And the error comes from ...
Next
From: Dave Cramer
Date:
Subject: Re: And the error comes from ...