copy entire database to a second machine - Mailing list pgsql-general

From John McKown
Subject copy entire database to a second machine
Date
Msg-id Pine.LNX.4.21.0009011245150.29711-100000@linux2.johnmckown.net
Whole thread Raw
List pgsql-general
This was really asked on another list, but I think it is interesting. Is
there a way to copy an entire database to a second machine other than
doing a pgdump? I.e. use ftp to copy the entire subdirectroy. But then how
to update the system tables? I couldn't think of one that was easy. I
guess a C program could do it by doing appropriate queries on the source
server and sending the information to the destination server.

Just curious,
John


pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Increasing system speed by using -F option
Next
From: Dave Smith
Date:
Subject: Re: Increasing system speed by using -F option