Re: Porting existing postgresql databases to another machine

From: "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Porting existing postgresql databases to another machine
Date: 2002-01-25 19:56:55
Message-ID: 000c01c1a5da$7123a6e0$4800a8c0@jecinc.on.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)agliodbs(dot)com]
Sent: Friday, January 25, 2002 11:32 AM
To: Brian Johnson; pgsql-novice(at)postgresql(dot)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(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message lee johnson 2002-01-25 23:31:56 pgaccess
Previous Message Tom Lane 2002-01-25 16:42:23 Re: System info for Postgre