Re: How to move a database from HP server to Linux Server that had already one database.

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "ENGEMANN, DAYSE" <dayse(dot)engemann(at)hp(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to move a database from HP server to Linux Server that had already one database.
Date: 2010-08-10 00:14:49
Message-ID: 201008100014.o7A0Enb03841@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

ENGEMANN, DAYSE wrote:
> Hi Kevin,
> Sorry to disturb you.. But I am really new in it...
> Let me see if I understood...
>
> pg_dump -h sourcemachine -U sourceuser source_dbname | psql target_dbname

Has anyone done any measurement of whether it is faster to do the dump
on the local machine with psql remote or from a remote machine (where
psql would be local)?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rosser Schwarz 2010-08-10 00:56:18 Re: High-water Mark for number of sessions/connections reached in Postgres
Previous Message Tomeh, Husam 2010-08-09 23:33:48 Re: High-water Mark for number of sessions/connections reached in Postgres