Re: how to merge two databases

From: Jyry Kuukkanen <jyry(at)neutech(dot)fi>
To: murali segu <segu_mk(at)yahoo(dot)co(dot)uk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to merge two databases
Date: 2005-11-10 09:58:25
Message-ID: Pine.LNX.4.58L.0511101155230.30311@cyclone.neutech.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hello

On Thu, 10 Nov 2005, murali segu wrote:

> i want to merge two databases how it is done plz help me
> thanQ

This should do the trick (under U*ix shell):

pg_dump -U username -h hostname source_db | psql -U username -h hostname target_db

--
--Jyry
C|:-( C|:-/ C|========8-O C|8-/ C|:-(

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2005-11-10 15:18:01 Re: autovacuum daemon question...
Previous Message Jeff Bohmer 2005-11-10 08:04:24 Re: autovacuum daemon question...