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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
