Skip site navigation (1) Skip section navigation (2)

Re: restore data from DB base?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: jennifer fan <jenniferfan007(at)yahoo(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: restore data from DB base?
Date: 2004-12-24 03:07:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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


Joshua D. Drake

> Thanks
> ------------------------------------------------------------------------
> Post your free ad now! *Yahoo! Canada Personals* 
> <>

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(at)commandprompt(dot)com -
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachment: jd.vcf
Description: text/x-vcard (285 bytes)

In response to

pgsql-admin by date

Next:From: Devi MunandarDate: 2004-12-24 04:40:29
Subject: Install Slony-I on Postgresql 7.3.2
Previous:From: Si ChenDate: 2004-12-23 20:28:27
Subject: pg_hba.conf and password authentication problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group