Обсуждение: restore data from DB base?
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
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