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

From Brian Johnson
Subject Re: Porting existing postgresql databases to another machine
Date
Msg-id 000c01c1a5da$7123a6e0$4800a8c0@jecinc.on.ca
Whole thread Raw
In response to Re: Porting existing postgresql databases to another  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-novice
I found what I was looking for here:

http://www.ca.postgresql.org/users-lounge/docs/7.1/admin/migration.html

It took me hours to find it though


-----Original Message-----
From: Josh Berkus [mailto:josh@agliodbs.com]
Sent: Friday, January 25, 2002 11:32 AM
To: Brian Johnson; pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Porting existing postgresql databases to another
machine


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: Tom Lane
Date:
Subject: Re: System info for Postgre
Next
From: lee johnson
Date:
Subject: pgaccess