pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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>
  2004-12-24 03:07 ` Re: restore data from DB base? Joshua D. Drake <jd@commandprompt.com>
  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-22 18:10 restore data from DB base? jennifer fan <jenniferfan007@yahoo.ca>
@ 2004-12-24 03:07 ` Joshua D. Drake <jd@commandprompt.com>
  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:

jd.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
^ permalink raw reply [nested|flat] 2+ messages in thread


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