move database directory

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: move database directory
Date: 2002-03-06 20:48:23
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB0452E06F@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy:

Running Postgres 7.1.3 on RedHat Linux 7.2 kernel
2.4.7 rev. 10.

My situation is this: I'm running out of room
on a partition where the database resides.
I'd like to move the database directory to another
partition.

I don't supposed there is a 'howto' and 'reminder'
for pulling off such things, is there? As I've
never done this before, I keep thinking that
there is more to it than remapping the
postmaster from startup and vacuum analyze
all of the tables after the move.

Any suggestions / documentation about such
matters?

Thanks!

-X

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-03-06 21:21:22 Re: move database directory
Previous Message Eric Webber 2002-03-06 20:27:46 ODBC from win2k to postgres on Linux HELL