Search Postgresql Archives

Re: Copy DataBases Server to server

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

 



nicolas.hafner schrieb:
Hi everyone,
I've a problem that i'am not able to solve alone (i'm kinda newbie on postgresql). we were running PostgreSQL 7.4 under Linux (Mandriva) but our HDD crashs and we lost the system but were able to backup the database files to an other HDD. now we want to copy the databases to our new server but it runs windows XP Pro 64bits and PostGreSQL 8.0. I try something simple, copy the former databases files in postgresql\data\base but it doesn't work (i knew it won't be so simple) and i look the 3 .conf files but i've found nothing intersing for my case. I could easyly rebuild the relationship, but re-importing the data will be a last option (it takes a few days the last time).
I'll go with the questions:
First: Is it realistic to think that what we want is possible?
second: if yes, Is it for PostGre Gurus, or will i be able to do it?
third: thanks, that's all!

You need to set up exact same version of postgres and point it to your
backed up database cluster (filesystem copy).

Then make a regular backup via pg_dump from this running copy.
Best is with postgres 8 pg_dump from the other host.

Btw, to get all the tuning knobs and best out of your hardware,
you might use linux or bsd for your production server instead of
windows.

HTH
Tino


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[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