Skip site navigation (1) Skip section navigation (2)

Re: posgres file

From: Christoph Della Valle <christoph(dot)dellavalle(at)goetheanum(dot)ch>
To: Ramon Orticio <rporticio(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: posgres file
Date: 2005-06-29 08:53:55
Message-ID: (view raw or whole thread)
Lists: pgsql-novice

i would dump the database

pg_dumpall > targetfile.dmp

copy the file to the other server. 
enter postgres and import the database with
/i /full/path/targetfile.dmp


Ramon Orticio schrieb:

>dear colleagues,
>how do you transfer postgres file to another computer
>having postgresql application.
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around 
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend

In response to

pgsql-novice by date

Next:From: Vincenzo RomanoDate: 2005-06-29 11:30:07
Subject: Rule creation and evaluation order
Previous:From: Andreas KretschmerDate: 2005-06-29 08:31:25
Subject: Re: [despammed] posgres file

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group