Re: [TCLUG:20610] moving PostgreSQL table

["Thomas T. Veldhouse" <veldy@veldy.net>]

It is called, pg_dump - see my previous post.

Tom Veldhouse
veldy@veldy.net

----- Original Message -----
From: David Wood <jbevren@yahoo.com>
To: TCLUG <tclug-list@mn-linux.org>
Sent: Thursday, August 24, 2000 12:01 AM
Subject: Re: [TCLUG:20610] moving PostgreSQL table


>
> I recommend you check out the dumpdb command :)
>
> It allows you to dump an entire database to a schema file (aimed at backup
> and archival I'm sure), but can also be handy for moving databases across
> systems ;)
>
> Have at 'em!
>
> -David
>
> On Tue, 22 Aug 2000, Timothy Wilson wrote:
>
> > I'm migrating a very simple PostgreSQL database from one machine to
another
> > and I can't figure out the proper procedure. I scanned a bunch of the
docs,
> > but I can't find anything that says, "Hey, idiot, here's how you move a
> > database from one machine to another!"
> >
> > Can I simply tar up the files in the existing 'foo_db' directory and
move
> > them to the new machine and untar in the appropriate place?
>
> I suppose you could try that, but I'd recommend the above solution so the
> database is built by the daemon instead of some other daemon :)
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tclug-list-unsubscribe@mn-linux.org
> For additional commands, e-mail: tclug-list-help@mn-linux.org
>
>