Обсуждение: Copy DataBases Server to server

Поиск
Список
Период
Сортировка

Copy DataBases Server to server

От
"nicolas.hafner"
Дата:
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!


Re: Copy DataBases Server to server

От
Tino Wildenhain
Дата:
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