It is possible to install postgres on usb driver to run it anywhere???

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

On Tue, 9 May 2006 16:54:37 -0400
"Rodrigo Cortés" <roco3d@gmail.com> wrote:

> It is possible to install postgres on usb driver to run it anywhere???
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 4: Have you searched our
> list archives?
>
> http://archives.postgresql.org

A) "Possible" is a BIG word. So is "anywhere". If you could narrow
these two down a bit it might help answer your question.

B) Why? Posgrgres is a network aware service so your clients can
generally attach TO the server FROM "anywhere" so why have a portable
installation? Not arguing, just trying to understand.

John Purser

--
Beware the one behind you.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

On 5/9/06, John Purser <jmpurser@gmail.com> wrote:
> On Tue, 9 May 2006 16:54:37 -0400
> "Rodrigo Cortés" <roco3d@gmail.com> wrote:
>
> > It is possible to install postgres on usb driver to run it anywhere???
> >
> > ---------------------------(end of
> > broadcast)--------------------------- TIP 4: Have you searched our
> > list archives?
> >
> > http://archives.postgresql.org
>
> A) "Possible" is a BIG word. So is "anywhere". If you could narrow
> these two down a bit it might help answer your question.
>
> B) Why? Posgrgres is a network aware service so your clients can
> generally attach TO the server FROM "anywhere" so why have a portable
> installation? Not arguing, just trying to understand.
>
> John Purser
>
> --
> Beware the one behind you.
>
Im trying to make a portable development environment for ruby on rails.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

> A) "Possible" is a BIG word. So is "anywhere". If you could narrow
> these two down a bit it might help answer your question.
>
possible mean "how to do it"
anywhere mean "a pc with a windows os"

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On Tue, 9 May 2006 17:06:53 -0400
"Rodrigo Cortés" <roco3d@gmail.com> wrote:

> On 5/9/06, John Purser <jmpurser@gmail.com> wrote:
> > On Tue, 9 May 2006 16:54:37 -0400
> > "Rodrigo Cortés" <roco3d@gmail.com> wrote:
> >
> > > It is possible to install postgres on usb driver to run it
> > > anywhere???
> > >

> Im trying to make a portable development environment for ruby on
> rails.
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 5: don't forget to increase
> your free space map settings

Well, I see no problem with INSTALLING postgreSQL on a USB drive. But
if you compiled it for Linux I don't think it would run on a windows
machine. In fact you might have a lot of trouble just getting to to
run on a different version of the same DISTRIBUTION of linux and that's
assuming you could maintain mount points and paths.

I think I'd go with a cheap laptop and/or Ruby installed on the USB
drive and my postgreSQL installation on the network.

John Purser

--
Q: How do you keep a moron in suspense?

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On Tue, 9 May 2006 17:10:21 -0400
"Rodrigo Cortés" <roco3d@gmail.com> wrote:

> > A) "Possible" is a BIG word. So is "anywhere". If you could narrow
> > these two down a bit it might help answer your question.
> >
> possible mean "how to do it"
> anywhere mean "a pc with a windows os"
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 6: explain analyze is your
> friend

Rodrigo with Windows I'm not sure how much the registry would have to
be edited (if at all) to run the same postgrsql installation from
windows machines A B and C. I strongly doubt that you could just walk
up to a strange machine, plug in your USB drive, and away you go.

Some years ago when I was still running Windows at home I recall there
was a discussion on the cygwin mailing lists about running cygwin from
a cd drive. You might want to check out their archives and see if you
could use that information.
http://www.cygwin.com/

Good luck.

John Purser

--
You will never know hunger.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match