Postgres Pro
Downloads
Home   >   mailing lists

Re: Porting existing postgresql databases to another - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Porting existing postgresql databases to another
Date
Msg-id web-675886@davinci.ethosmedia.com
Whole thread Raw
In response to Porting existing postgresql databases to another machine  ("Brian Johnson" <bjohnson@jecinc.on.ca>)
Responses Re: Porting existing postgresql databases to another machine
List pgsql-novice
Tree view 
Brian,

> I'm trying to port some existing postgresql databases to another
>  machine
>
> I'd really like to replicate the databases on the second machine, but
>  would
> accept a process that just copies the data over
>
> Can anyone point me to a how-to or offer some advice?

HTTP://techdocs.postgresql.org/

Though, quite frankly, if you're running on Unix the fastest process is
 to use pg_dump files.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

pgsql-novice by date:

Previous
From: "Summer S. Wilson"
Date:
Subject: System info for Postgre
Next
From: Tom Lane
Date:
Subject: Re: System info for Postgre