Clone a database to other machine

From: "Terence Chang" <TChang(at)nqueue(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Clone a database to other machine
Date: 2003-07-28 20:38:34
Message-ID: 00da01c35548$379454a0$09f1e9a7@PEANUTLEN
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there:

I am just wondering if this is a doable method to clone a database to other machine. I have three identical linux serves with postgresql server installed at the same location. I have a new customized database and initial data load into server 1. Can I just copy all of the database files physically from server 1 to server 2 and server 3? I assume this is one of the method to restore a database.

What I am trying to do is to sell a solution package to clients. The solution will include Linux + Apache + PHP + PostgreSQL. So every customers will have the same database configuration initially.

Any other suggestion?

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Bartlett 2003-07-28 20:55:26 Re: CREATE TABLE with REFERENCE
Previous Message Larry Rosenman 2003-07-28 20:33:35 Re: Using YY-MM-DD date input