moving database to a new partition on disk

From: sarlav kumar <sarlavk(at)yahoo(dot)com>
To: pgsqlnovice <pgsql-novice(at)postgresql(dot)org>
Subject: moving database to a new partition on disk
Date: 2005-01-07 17:41:26
Message-ID: 20050107174126.65160.qmail@web51305.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

Currently I have the database on a partition on the disk. I would like to move it to a separate partition which was created exclusively for databases. Is it enough if I just copy the files under /var/lib/pgsql/ directory to the new partition? I am not sure how to go about accomplishing this. Do I need to change any of the .conf files after moving?

It woud be great if someone can let me know how to go about moving the files and how to configure postgres to use the new directory.

Thanks,
Saranya

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Browse pgsql-novice by date

  From Date Subject
Next Message Tomka Gergely 2005-01-07 18:22:56 count(*) index
Previous Message Stephan Szabo 2005-01-07 15:22:17 Re: Updating views : cannot figure out what goes wrong