Re: posgres file - Mailing list pgsql-novice

From Christoph Della Valle
Subject Re: posgres file
Date
Msg-id 42C261A3.5030007@goetheanum.ch
Whole thread Raw
In response to posgres file  (Ramon Orticio <rporticio@yahoo.com>)
List 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
>
>
>
>


pgsql-novice by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] posgres file
Next
From: Vincenzo Romano
Date:
Subject: Rule creation and evaluation order