Thread: posgres file

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

am  29.06.2005, um  1:17:45 -0700 mailte Ramon Orticio folgendes:
> dear colleagues,
>
> how do you transfer postgres file to another computer
> having postgresql application.

What do you mean with 'postgres file'? I use ssh/scp to store
Backup-Dumps from PostgresSQL to other machines.


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

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
>
>
>
>