Thread: Storing the data on a portable extenal hard drive

Storing the data on a portable extenal hard drive

From
Sindile Bidla
Date:
I a running Windows 7 64bit.
Is it possible to store the PostgreSQL data (database) on a usb external hard-drive and be able to use this on multiple computers running either Windows or Linux. That is as long as the PostgreSQL is installed on each computer.

Re: Storing the data on a portable extenal hard drive

From
Sean Davis
Date:


On Fri, Jul 9, 2010 at 9:14 AM, Sindile Bidla <sindile.bidla@gmail.com> wrote:
I a running Windows 7 64bit.
Is it possible to store the PostgreSQL data (database) on a usb external hard-drive and be able to use this on multiple computers running either Windows or Linux. That is as long as the PostgreSQL is installed on each computer.

While probably possible, this doesn't sound like a very robust solution.  Why not just connect to a single server from the multiple machines?

Sean

Re: Storing the data on a portable extenal hard drive

From
Sindile Bidla
Date:
This is really for my own personal use.
The idea is to move all the database object currently on my laptop hard-drive to an external hard-drive connected to my laptop via usb. This will allow me to free space on the laptop.
  

On 9 July 2010 15:22, Sean Davis <sdavis2@mail.nih.gov> wrote:


On Fri, Jul 9, 2010 at 9:14 AM, Sindile Bidla <sindile.bidla@gmail.com> wrote:
I a running Windows 7 64bit.
Is it possible to store the PostgreSQL data (database) on a usb external hard-drive and be able to use this on multiple computers running either Windows or Linux. That is as long as the PostgreSQL is installed on each computer.

While probably possible, this doesn't sound like a very robust solution.  Why not just connect to a single server from the multiple machines?

Sean



Re: Storing the data on a portable extenal hard drive

From
Sean Davis
Date:


On Fri, Jul 9, 2010 at 9:49 AM, Sindile Bidla <sindile.bidla@gmail.com> wrote:
This is really for my own personal use.
The idea is to move all the database object currently on my laptop hard-drive to an external hard-drive connected to my laptop via usb. This will allow me to free space on the laptop.
  

I often symlink the pgdata directory to another location for convenience.  You could probably do the same thing, allowing you to move the data to anywhere you like, including an external hard drive.  Again, you'll want to make sure that this won't be removed with the server running, or you will have problems.

Sean

 

On 9 July 2010 15:22, Sean Davis <sdavis2@mail.nih.gov> wrote:


On Fri, Jul 9, 2010 at 9:14 AM, Sindile Bidla <sindile.bidla@gmail.com> wrote:
I a running Windows 7 64bit.
Is it possible to store the PostgreSQL data (database) on a usb external hard-drive and be able to use this on multiple computers running either Windows or Linux. That is as long as the PostgreSQL is installed on each computer.

While probably possible, this doesn't sound like a very robust solution.  Why not just connect to a single server from the multiple machines?

Sean




Re: Storing the data on a portable extenal hard drive

From
"Jean-Yves F. Barbier"
Date:
Le Fri, 9 Jul 2010 15:49:49 +0200,
Sindile Bidla <sindile.bidla@gmail.com> a écrit :

> This is really for my own personal use.
> The idea is to move all the database object currently on my laptop
> hard-drive to an external hard-drive connected to my laptop via usb. This
> will allow me to free space on the laptop.

As it is personnal use only, everything's possible; but if your data has
value, this is a terrible idea (nothing's more fragile than a portable HD)

have you considered an ssh server access from home (w/ dyndns if needed)?

--
You will be dead within a year.