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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin