Skip site navigation (1) Skip section navigation (2)

Re: postgres file

From: Aarni Ruuhimäki <aarni(at)kymi(dot)com>
To: Ramon Orticio <rporticio(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: postgres file
Date: 2005-05-23 06:35:42
Message-ID: 200505230935.43127.aarni@kymi.com (view raw or flat)
Thread:
Lists: pgsql-novice
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
--------------

In response to

pgsql-novice by date

Next:From: Agustín Caminero HerráezDate: 2005-05-23 09:08:11
Subject: Problem restarting server
Previous:From: Volkan YAZICIDate: 2005-05-23 06:23:10
Subject: Re: postgres file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group