From: | "P Kapat" <kap4lin(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: how to replicate a database from one machine to the other? |
Date: | 2008-06-26 21:22:02 |
Message-ID: | daef5be80806261422m3c46ec96k4abaf5df47716963@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, Jun 25, 2008 at 11:10 PM, Shane Ambler <pgsql(at)sheeky(dot)biz> wrote:
> 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
Thanks Shane, that worked. There were some errors for missing roles,
but that was expected since the usernames were different on the two
machines.
--
Regards
PK
--------------------------------------
http://counter.li.org #402424
From | Date | Subject | |
---|---|---|---|
Next Message | Ridvan Lakas ng Bayan S. Baluyos | 2008-06-27 07:46:01 | Dumping tables with only create statements |
Previous Message | Sérgio R F Oliveira | 2008-06-26 19:30:06 | Sources of information about sizing of hardwares to run PostgreSQL |