You can also use WAL log shipping; there's been recent discussion about
that on -admin.
BTW, I'm seeing duplicated emails from you...
On Tue, Jan 03, 2006 at 08:31:09PM -0500, Doug McNaught wrote:
> Allen Fair <[EMAIL PROTECTED]> writes:
>
> > Our databases can get large and we want to find the
In article <[EMAIL PROTECTED]>,
Allen Fair <[EMAIL PROTECTED]> wrote:
% Do you or (or anyone else) suggest a method for moving databases from
% one server to another without the time consuming dump/transfer/restore
% process? Anything in the contrib directory or a good management tool?
If you w
Tom,
Thanks for the reply. That makes sense.
Do you or (or anyone else) suggest a method for moving databases from
one server to another without the time consuming dump/transfer/restore
process? Anything in the contrib directory or a good management tool?
Our databases can get large and we w
Allen Fair <[EMAIL PROTECTED]> writes:
> Our databases can get large and we want to find the best way to plan for
> when a database outgrows its current server.
>
> How about a replication scheme and cutover? If so, is there a preferred
> replication package to support this?
Slony-I was designed
Tom,
Thanks for the reply. That makes sense.
Do you or (or anyone else) suggest a method for moving databases from
one server to another without the time consuming dump/transfer/restore
process? Anything in the contrib directory or a good management tool?
Our databases can get large and we want
Allen Fair <[EMAIL PROTECTED]> writes:
> Looking at the "create tablespace " command in the docs, I was wondering
> how easy it is to move a database/tablespace to another server/instance
> of PostgreSQL.
It's not. The contents of the tablespace are tied to the instance
(because rows contain tr
Hi!
Looking at the "create tablespace " command in the docs, I was wondering
how feasible it is to move a database/tablespace to another
server/instance of PostgreSQL.
Issue: moving databases using pg_dump and pg_restore is more
time-consuming than desired, requiring the db to be unavailable
Hi!
Looking at the "create tablespace " command in the docs, I was wondering
how easy it is to move a database/tablespace to another server/instance
of PostgreSQL.
We have lots of databases, with the same definitions, with 1 database
per client account on the server. I can setup the database
