From: | Shane Ambler <pgsql(at)Sheeky(dot)Biz> |
---|---|
To: | P Kapat <kap4lin(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: how to replicate a database from one machine to the other? |
Date: | 2008-06-26 03:10:49 |
Message-ID: | 486308B9.8040503@Sheeky.Biz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
P Kapat wrote:
> A total novice here!
>
> Machine A: Kubuntu 8.04 has the required database under user userA
> Machine B: RHEL 5 is the destination machine with userB
>
> I want to transfer the entire database under userA from machine A to
> user B under machine B. Is that possible?
>
Yes.
If the MachineB postgres version is older then you may have problems.
MachineA
pg_dump machineadb > madb.sql
copy madb.sql across to machineB
MachineB
psql < madb.sql
This would make a copy of the database named machineadb, if you want
every db on the server then you can use pg_dumpall
You may need options like -U -h and -W (username/host/prompt for
password) man psql or man pg_dump for more detail
Feel free to compress the file to reduce transfer times etc.
You can also reduce it to one step -
pg_dump machineadb | psql -h remotename
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
From | Date | Subject | |
---|---|---|---|
Next Message | Shane Ambler | 2008-06-26 03:31:11 | Re: editing pg_hba.conf |
Previous Message | Devrim GÜNDÜZ | 2008-06-25 23:49:56 | Re: yum repos problem |