pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
restore data from DB base? 2+ messages / 2 participants [nested] [flat]
* restore data from DB base? @ 2004-12-22 18:10 jennifer fan <jenniferfan007@yahoo.ca> 0 siblings, 1 reply; 2+ messages in thread From: jennifer fan @ 2004-12-22 18:10 UTC (permalink / raw) To: pgsql-admin 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. Thanks --------------------------------- Post your free ad now! Yahoo! Canada Personals ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: restore data from DB base? @ 2004-12-24 03:07 Joshua D. Drake <jd@commandprompt.com> parent: jennifer fan <jenniferfan007@yahoo.ca> 0 siblings, 0 replies; 2+ messages in thread From: Joshua D. Drake @ 2004-12-24 03:07 UTC (permalink / raw) To: jennifer fan <jenniferfan007@yahoo.ca>; +Cc: pgsql-admin 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 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL Attachments:^ permalink raw reply [nested|flat] 2+ messages in threadjd.vcf (text/x-vcard, 283B) download
begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com 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 thread, other threads:[~2004-12-24 03:07 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-12-22 18:10 restore data from DB base? jennifer fan <jenniferfan007@yahoo.ca> 2004-12-24 03:07 ` Joshua D. Drake <jd@commandprompt.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