Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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
1  
I also noticed that locales such as en_US.UTF8 is not supported on Windows. Such a pity, I've successfully shared MongoDB data folder between Linux and Windows in my dual-boot system. – Hendy Irawan Feb 13 at 6:36

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

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.