←back to thread

75 points markusw | 1 comments | | HN request time: 0.213s | source
Show context
eirikbakke ◴[] No.45335495[source]
The PostgreSQL data directory format is not very stable or portable. You can't just ZIP it up and move it to a different machine, unless the new machine has the same architecture and "sufficiently" similar PostgreSQL binaries.

In theory the data directory works with any PostgreSQL binaries from the same major version of PostgreSQL, but I have seen cases where this fails e.g. because the binaries were from the same major version but compiled with different build options.

replies(5): >>45335952 #>>45336357 #>>45336495 #>>45336741 #>>45337960 #
1. freedomben ◴[] No.45335952[source]
I've been hit by this too, so definitely a risk. I've also had permissions on the files get broken which is a bitch to debug