PostgreSQL Newbies - postgres file

Author

postgres file

Ramon Orticio

2005-05-22, 8:23 pm

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

Volkan YAZICI

2005-05-23, 3:24 am

Hi,

On 5/23/05, Ramon Orticio <rporticio@yahoo.com> wrote:
> postgresql database files is quite complicated for me.
> how can one transfer a postgressl database file from
> one computer to another.

http://www.postgresql.org/docs/8.0/...ive/backup.html

> in access dbms, this can be
> easily done by locating the filename with extension
> .mdb. how does one do it in postgresql.

AFAIC, PostgreSQL uses partitoned database files to store data. Thus,
it's far from MS Access' concept. (Furthermore, both method have its
own pros and cons.) But, in the related documentation (which I pasted
above), you'll see how easy it is to backup/restore a PostgreSQL
database/table/object using supplied utilities.

Regards.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Aarni Ruuhimäki

2005-05-23, 3:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Sponsored Links