Re: Moving data to another disk

From: "Clodoaldo Pinto Neto" <clodoaldo(dot)pinto(at)gmail(dot)com>
To: "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Moving data to another disk
Date: 2006-10-04 11:32:54
Message-ID: a595de7a0610040432v3eb520e6tf3e7ccd5e884f9eb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This is the original message from october 2 that didn't appear in the
list. I don't know if someone received it.

X-Gmail-Received: c62ada517ba59dc1cb70c46da86fdd974cd80c63
Received: by 10.70.35.9 with HTTP; Mon, 2 Oct 2006 10:59:43 -0700 (PDT)
Message-ID: <a595de7a0610021059g4d9c5d21m2f4cbb9d5275d697(at)mail(dot)gmail(dot)com>
Date: Mon, 2 Oct 2006 14:59:43 -0300
From: "Clodoaldo Pinto Neto" <clodoaldo(dot)pinto(at)gmail(dot)com>
To: "pgsql-general postgresql.org" <pgsql-general(at)postgresql(dot)org>
Subject: Moving data to another disk
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Delivered-To: clodoaldo(dot)pinto(at)gmail(dot)com

I want to move the data directory to another disk and mantain the
config files in the same place. I will change the data_directory
parameter in postgresql.conf.

I could just copy everything under /var/lib/pgsql/data to the other
disk but I also want to clean the diretory now used thus I need to
know for sure what files/directories are data.

I have read the 50.1 section of the postgres manual.

I suppose all directories under /var/lib/pgsql/data are data
directories and i guess the postmaster.opts, postmaster.pid and
PG_VERSION files should stay in the config directory and obviously the
*.conf files are config files. Am i right?

Regards, Clodoaldo

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Kratz 2006-10-04 12:59:23 Re: Need help with a function from hell..
Previous Message TIJod 2006-10-04 10:03:01 Storing images in PostgreSQL databases (again)