[NOVICE] postgres file

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[NOVICE] postgres file

Ramon Orticio
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
Reply | Threaded
Open this post in threaded view
|

Re: [NOVICE] postgres file

Volkan YAZICI
Hi,

On 5/23/05, Ramon Orticio <[hidden email]> 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/interactive/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
Reply | Threaded
Open this post in threaded view
|

Re: [NOVICE] postgres file

Aarni Ruuhimäki
In reply to this post by Ramon Orticio
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