| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincenzo Romano | 2005-06-29 11:30:07 | Rule creation and evaluation order |
| Previous Message | Andreas Kretschmer | 2005-06-29 08:31:25 | Re: [despammed] posgres file |