Thread:

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.
--
Matias Monteverde

Dir.
Linuxtech.cl
email:mmonte@linuxtech.cl
-------------------------
' This month I wrote two lines of code one of
them did not work and other was a comment '

Matias Monteverde <mmonte@linuxtech.cl> writes:
> 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 ?

If the data is so messed up that pg_dump doesn't work, I really doubt
that 'cp' will make it better :-(.  I hope you have a recent backup.

            regards, tom lane

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.