Обсуждение: lost archives, alpha data files
Hi! I managed myself to a near-hopeless situation. My pg_dumps lost, the machine with the database died. I have the disk of the machina, with the data directory, with (hipotetically) intact files. So i copied the files to another computer, and tried to start a nearly-same-version psql with the data directory. The message says crc error in the pg_control file. This is plausible, because the dead machine was an alpha 500au, with debian sid, and this trick was only succesful when the versions are the same. My current machine sarge, also with pg version 7.4, but i think this is not enough. I have two questions: - I need to try on the same architecture this trick? Data files generated on 64 bit environment only usable in 64 bit env? - If yes, can someone help me (this was our last alpha:(), if not, what can i do? Thanks. The sid has the version 7.4.8-17, sarge has 7.4.7-6sarge1. -- Tomka Gergely Tudom, anyu. Sapka, sál, doksi.
Tomka Gergely <tomka@zeus.gau.hu> writes: > - I need to try on the same architecture this trick? Data files generated > on 64 bit environment only usable in 64 bit env? Yes. PG data files are not intended to be portable across architectures. It certainly will not work to move them between 32-bit and 64-bit machines, nor between little-endian and big-endian machines. You might possibly get away with changing hardware within those constraints, but even then it's iffy. regards, tom lane
2006-01-31 ragyogó napján Tom Lane ezt üzente: > Tomka Gergely <tomka@zeus.gau.hu> writes: > > - I need to try on the same architecture this trick? Data files generated > > on 64 bit environment only usable in 64 bit env? > > Yes. PG data files are not intended to be portable across > architectures. It certainly will not work to move them between 32-bit > and 64-bit machines, nor between little-endian and big-endian machines. > You might possibly get away with changing hardware within those > constraints, but even then it's iffy. Thanks. -- Tomka Gergely Tudom, anyu. Sapka, sál, doksi.