replicating database

replicating database

Re: replicating database

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 
>