Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is it possible to use a PostrgeSQL database in Windows and use the same one in Linux after rebooting? Will pointing the data folder to a common folder be sufficient?

I know I could test it and then see for myself, but if someone has a better idea, I'm all ears!

share|improve this question
    
You can use a VM that is on a folder shared by both Linux and Windows. –  Mircea Vutcovici Sep 23 '11 at 22:29
add comment

2 Answers 2

up vote 2 down vote accepted

PostgreSQL data files are operating system and CPU architecture specific. So first of all your Linux and Windows systems would need to be of the same architecture. And then the data layout that the compilers use would need to be the same as well. I have tried this in the past between Linux and Cygwin, and it did not work. So I would be very surprised if it worked between Linux and native Windows. In general, don't count on it.

share|improve this answer
add comment

I'd be very surprised if it worked.

Why not just run a virtual machine when you've booted up with the non-native OS?

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.