Re: replicating database

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: replicating database
Date: 2002-07-16 22:42:57
Message-ID: 1026859377.19261.408.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If your trying to "duplicate" your database, then this link should work
http://www.postgresql.org/idocs/index.php?app-pgdump.html

if you want to set up "replication", thats a different beast. I guess I
would look at http://gborg.postgresql.org/ for that.

Robert Treat

On Tue, 2002-07-16 at 17:52, Johnson, Shaunn wrote:
> Howdy:
>
> Running PostgreSQL 7.1.3 on RedHat Linux 7.2, kernel 2.4.7-10
> and a PostgreSQL 7.2.1 on Mandrake Linux 8.0 kernel 2.4.17.
>
> Sometime ago (not a year, I think) I was able to move
> a database from one server to another using pg_dump (or,
> pg_dumpall). There was a few things that I had to do
> and know ahead of time; I can't remember what that was.
> I do recall that I had to specify the host and the
> destination server.
>
> Where in the documentation does it tell me how I can
> connect to a remote server and replicate / dump my
> existing database?
>
> Thanks!
>
> -X
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Linwood 2002-07-16 22:49:22 Re: Tom, I've got an emergency - please help me
Previous Message Ralph Graulich 2002-07-16 22:31:13 Re: size of function body