Обсуждение: Porting existing postgresql databases to another machine

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?

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

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