4

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!

Improve this question
1
  • You can use a VM that is on a folder shared by both Linux and Windows.
    – Mircea Vutcovici
    Sep 23, 2011 at 22:29

2 Answers 2

Reset to default
2

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.

Improve this answer
1
  • 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, 2016 at 6:36
1

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?

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .