Postgres Pro
Downloads
Home   >   mailing lists

Clone a database to other machine - Mailing list pgsql-general

From Terence Chang
Subject Clone a database to other machine
Date
Msg-id 00da01c35548$379454a0$09f1e9a7@PEANUTLEN
Whole thread Raw
Responses Re: Clone a database to other machine  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Clone a database to other machine  (Ron Johnson <ron.l.johnson@cox.net>)
Re: Clone a database to other machine  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general
Tree view
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!
 
 
 
 

pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: CREATE TABLE with REFERENCE
Next
From: Larry Rosenman
Date:
Subject: Re: Using YY-MM-DD date input