From: | Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2003-09-10 09:28:44 |
Message-ID: | 200309101228.44801.aarni.ruuhimaki@kymi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
---------- 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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Fromme | 2003-09-10 10:13:44 | Which files belong to which database? |
Previous Message | Stuart Woodward | 2003-09-10 09:26:53 | Re: R駱. |