| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Jennifer Trey <jennifer(dot)trey(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Move PGdata to a different drive |
| Date: | 2009-06-05 14:35:58 |
| Message-ID: | 20090605143558.GB5929@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jun 04, 2009 at 11:11:29AM -0400, Bruce Momjian wrote:
> Jennifer Trey wrote:
> > Hi,
> > What file should I be working with?
>
> Just shut down the server and move the directory whever you want and
> restart the server. There are no file contents that need changing.
> Of course should adjust your scripts or PGDATA environment variable.
Another way to do this is to mount the drive at the place where PGDATA
used to be. The down side of this approach is that it only works if
you want your PGDATA at the root of that new drive.
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-06-05 14:46:11 | Re: why dropping a trigger may cause a deadlock |
| Previous Message | Tom Lane | 2009-06-05 13:57:51 | Re: invalid byte sequence for encoding "UTF8": 0xab |