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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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



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:
> ---------------------------(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-2017 The PostgreSQL Global Development Group