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: 42C261A3.5030007@goetheanum.ch (view raw or flat)
Thread:
Lists: pgsql-novice
hi

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

christoph

Ramon Orticio schrieb:

>dear colleagues,
>
>how do you transfer postgres file to another computer
>having postgresql application.
>
>thanks
>
>ramon 
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around 
>http://mail.yahoo.com 
>
>---------------------------(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-2014 The PostgreSQL Global Development Group