pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
3+ messages / 3 participants
[nested] [flat]
* (no subject)
@ 2003-02-05 20:03 Matias Monteverde <mmonte@linuxtech.cl>
2003-02-06 20:51 ` Re: Tom Lane <tgl@sss.pgh.pa.us>
2003-02-06 21:56 ` Re: Steve Crawford <scrawford@pinpointresearch.com>
0 siblings, 2 replies; 3+ messages in thread
From: Matias Monteverde @ 2003-02-05 20:03 UTC (permalink / raw)
To: pgsql-admin
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 '
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re:
2003-02-05 20:03 (no subject) Matias Monteverde <mmonte@linuxtech.cl>
@ 2003-02-06 20:51 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2003-02-06 20:51 UTC (permalink / raw)
To: Matias Monteverde <mmonte@linuxtech.cl>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re:
2003-02-05 20:03 (no subject) Matias Monteverde <mmonte@linuxtech.cl>
@ 2003-02-06 21:56 ` Steve Crawford <scrawford@pinpointresearch.com>
1 sibling, 0 replies; 3+ messages in thread
From: Steve Crawford @ 2003-02-06 21:56 UTC (permalink / raw)
To: Matias Monteverde <mmonte@linuxtech.cl>; pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-02-06 21:56 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-05 20:03 Matias Monteverde <mmonte@linuxtech.cl>
2003-02-06 20:51 ` Re: Tom Lane <tgl@sss.pgh.pa.us>
2003-02-06 21:56 ` Re: Steve Crawford <scrawford@pinpointresearch.com>
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