2011/10/6 Adarsh Sharma <adarsh.sharma@xxxxxxxxxx>
That's the bottleneck I need to solve:-
Previous data & Os Version :- Postgresql-8.3 and Suse Enterprise Linux
New Data & OS Version :- Postgresql-8.4 and Ubuntu 10.04
What to do know?
Thanks
Raymond O'Donnell wrote:On 06/10/2011 11:34, Filip Rembiałkowski wrote:To use existing data directory in new installation, you can just stop the server, replace data_directory, and start the server. Remember about file permissions - data_directory must be owned by server process owner ("postgres") and chmod 700.BUT - and this is a big but - the data *must* be from the same Postgres major version, same architecture, etc. This might have been mentioned upthread, but it's worth repeating. Ray.