Re:

---------- Forwarded Message ----------

Subject: Re: [NOVICE]
Date: Wed, 10 Sep 2003 12:27:27 +0300
From: Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: "Mickey" <mickey(at)mcnjeni(dot)com>

Hi,

From command line:

pg_dump -c your_db > your_db_dump

Then move the file to the other machine and command

psql your_db < your_db_dumb

or

cat your_db_dumb | psql your_db

Please see the online docs for more dump options.

BR,

Aarni

On Wednesday 10 September 2003 03:28, you wrote:
> HI,
>
> I'm obviously new to this list, but I am also new to postgres as well.. I
> am looking for someone who can dumb a database on one server (postgres
> 7.1.3) and restore it on another server (postgres 7.1.3) some OS on both
> machines, should be pretty easy, I just have failed in every attempt.
>
> Thanks in advance for anything that could be offered,
>
> Mickey
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Aarni Ruuhimäki
Megative Tmi
KYMI.com

Pääsintie 26
45100 Kouvola
FINLAND

info(at)kymi(dot)com / aarni(dot)ruuhimaki(at)kymi(dot)com

+358-5-3755 035 / +358-50-4910 037
------------------------------------------------
Linux RedHat / KDE