Re: How to store data on an external drive - Mailing list pgsql-general

From Jasen Betts
Subject Re: How to store data on an external drive
Date
Msg-id h85607$2j8$1@reversiblemaps.ath.cx
Whole thread Raw
In response to How to store data on an external drive  (Jia Chen <chen.1002@gmail.com>)
Responses Re: How to store data on an external drive  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
On 2009-09-08, Jia Chen <chen.1002@gmail.com> wrote:
> Hi there,
>
> As a beginner of PostgreSQL, I installed PostgreSQL 8.3.7 on Ubuntu 9.04
> by using sudo apt-get install.
>
> Now, I want to store PostgreSQL data on an external drive because I work
> both on my office machine and on my home machine a lot.  This way, I can
> always bring my external drive to either location and work on data
> stored on the drive.

start again and install from the source.
the ubuntu packge spreads the components of the postgres database about
putting some in /usr/bin, /usr/lib, /etc/postgres, /var/log, /var/lib and /etc

you should install them all onto the removable drive instead.
it's not just the table data that is needed need for the database to work.



pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Data folder in differnet filesystem
Next
From: Richard Huxton
Date:
Subject: Re: Fail to start Postgres on Ubuntu kernel 2.6.28-15-generic