Postgres Pro
Downloads
Home   >   mailing lists

Re: How to move a database from HP server to Linux Server that had already one database. - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: How to move a database from HP server to Linux Server that had already one database.
Date
Msg-id 201008100014.o7A0Enb03841@momjian.us
Whole thread Raw
In response to Re: How to move a database from HP server to Linux Server that had already one database.  ("ENGEMANN, DAYSE" <dayse.engemann@hp.com>)
Responses Re: How to move a database from HP server to Linux Server that had already one database.
Re: How to move a database from HP server to Linux Server that had already one database.
List pgsql-admin
Tree view 
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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

pgsql-admin by date:

Previous
From: "Tomeh, Husam"
Date:
Subject: Re: High-water Mark for number of sessions/connections reached in Postgres
Next
From: Rosser Schwarz
Date:
Subject: Re: High-water Mark for number of sessions/connections reached in Postgres