Re: postgres file

Hi,

With Pg you do not move a db file or files, but a dump file that has the data
in it.

You need to set up a Pg-system on the other machine, take a db dump on machine
1, move that file to the other machine and read it in.

E.g. / guide lines:

Machine1#pg_dump -c yourdb > yourdb_dumpfile

Machine2#createdb yourdb
Machine2#psql yourdb < yourdb_dumpfile

This moves one database.

To move all databases use pg_dumpall:

Machine1#pg_dumpall -c > all_dumpfile

Machine2#psql < all_dumpfile

BR,

Aarni

On Monday 23 May 2005 04:37, you wrote:
> hello!
>
> postgresql database files is quite complicated for me.
> how can one transfer a postgressl database file from
> one computer to another. in access dbms, this can be
> easily done by locating the filename with extension
> .mdb. how does one do it in postgresql.
>
> thanks for any help
>
> mon.
>
>
>
>
>
>
>
> Yahoo! Mail
> Stay connected, organized, and protected. Take the tour:
> http://tour.mail.yahoo.com/mailtour.html
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

--------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core 2** linux system
--------------