Обсуждение: Storing the data on a portable extenal hard drive
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.
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
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
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
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.