From: Steve Crawford <scrawford@pinpointresearch.com>
To: Matias Monteverde <mmonte@linuxtech.cl>
To: pgsql-admin@postgresql.org
Subject: Re:
Date: Thu, 6 Feb 2003 13:56:49 -0800
Message-ID: <20030206215648.EDC38103F5@polaris.pinpointresearch.com> (raw)
In-Reply-To: <1044475418.5096.3.camel@padme>
References: <1044475418.5096.3.camel@padme>
If I understand correctly, you should be able to copy the files directly if
the database is shut down (completely stopped, not just idle).
But have you considered running pg_dump from your other machine? As long as
you set postgresql to accept remote connections and pg_hba.conf allows them
from the other machines then you can have your server on machine A and run
your pg_dump or pg_dumpall on machine B saving its output to that machine.
Or, if you can rsh from machine B to a you can use rsh to start your dump
(ie. rsh A "pg_dumpall ..." > backupfile) so pg_dumpall will be running on A
but dumping its output across the wire to stdout on B which then gets
redirected to your bakup file (of if you want to be fancy, directly as input
to psql to create the database on your other machine).
"There's more than one way to do it."
Cheers,
Steve
On Wednesday 05 February 2003 12:03 pm, Matias Monteverde wrote:
> Dear list:
>
> I need to move all databases from one fiscal server to other,
> but, the
> main problem I have is: I can't dump databases, for internal problems
> from hdd. My question is, so, how can rescue all databases in 'cp
> command' way in posgresql version 7.0 ?
>
>
> Needing to know:
>
> I copy /usr/local/pgsql/data/base.
>
> Any help will be great.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, mmonte@linuxtech.cl
Subject: Re:
In-Reply-To: <20030206215648.EDC38103F5@polaris.pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox