Search Postgresql Archives

Re: Restoring database from old DATA folder

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



# rohitprakash123@xxxxxxxxxxxxxx / 2006-08-07 22:17:26 -0700:
> 
> I have a DATA folder of my previous PostgreSQL 8.1 (Windows XP) installation.
> I do not have any DUMP or other backups. I want to use this folder instead
> of the newly created DATA folder after new installtion.
> 
> I tried replacing the new folder with the old folder, but it did not work.
> pgAdmin also stopped working.
 
    Was the old postgres stopped when you created the copy?
    Was the new postgres stopped when you put the copy in?
    Did you restore correct permissions when you put the copy in?
    Is the new install the same version of postgres as the old one?
    What are the error messages?

> I want to know how to recover the database from a DATA folder in case of
> worst situations if no backups are available.

    http://www.postgresql.org/docs/8.1/static/backup-file.html
    http://www.postgresql.org/docs/8.1/static/migration.html

-- 
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux