---------- Forwarded Message ----------
Subject: Re: [NOVICE]
Date: Wed, 10 Sep 2003 12:27:27 +0300
From: Aarni Ruuhimäki <aarni.ruuhimaki@kymi.com>
To: "Mickey" <mickey@mcnjeni.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@kymi.com / aarni.ruuhimaki@kymi.com
+358-5-3755 035 / +358-50-4910 037
------------------------------------------------
Linux RedHat / KDE