jennifer fan wrote:
One server that hold postgresql(7.4.6) and data(account system data) stop working yesterday, the disks may be demaged. the data wasn't backuped. Does anybody know how to restore data from DB base. That means, if the data directory could be found from disk, is it possiple to install a postgresql(7.4.6) in a new machine, copy data directory to new machine, then try to restore data ? But how to ask postgresql knew the data directory? Any suggestion will very be apperciate.If the data directory is intact, you should be able to move it to a new 7.4.6 postgresql installation without issue.
You could then start it up with a command like this:
pg_ctl -D <path to data directory> -l <path to logfile> start
Sincerely,
Joshua D. Drake
Thanks
------------------------------------------------------------------------
Post your free ad now! *Yahoo! Canada Personals* <http://ca.personals.yahoo.com/>
-- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL
begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:[EMAIL PROTECTED] title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
