Thread: Using same database from XP and Linux in notebook

I have notebook which can be booted into Windows XP/NTFS and into Linux.
Notebook is not connected to any network. There are separate IDE partitions
for both OS.

I want same Postgres 8.1 database to be available in both modes.

I think I must put Postgres database cluster into a NTFS partition which can
be written from Postgres running on Linux or into Linux partition which can
be written from Postgres running in XP.

Any idea how to implement dual OS database ? Is there a ready to install
Linux distro which supports this ?

Andrus.

Here is an example I always used as a start point in this type of project.

http://campbellcentral.org/rick/code/setup.html

Generally, I would store the datafiles on an NTFS partition - it seems
easier to reach NTFS from Linux then vice-versa.

I have seen this done successfully with virtually all Linux distributions.

Bill Penberthy
Scarpa Technology, Inc.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Andrus Moor
Sent: Saturday, March 04, 2006 8:52 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Using same database from XP and Linux in notebook

I have notebook which can be booted into Windows XP/NTFS and into Linux.
Notebook is not connected to any network. There are separate IDE partitions
for both OS.

I want same Postgres 8.1 database to be available in both modes.

I think I must put Postgres database cluster into a NTFS partition which can

be written from Postgres running on Linux or into Linux partition which can
be written from Postgres running in XP.

Any idea how to implement dual OS database ? Is there a ready to install
Linux distro which supports this ?

Andrus.



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

> Here is an example I always used as a start point in this type of project.
>
> http://campbellcentral.org/rick/code/setup.html
>
> Generally, I would store the datafiles on an NTFS partition - it seems
> easier to reach NTFS from Linux then vice-versa.

Bill,

Your example mounts NTFS as read-only. Is it possible to mount NTFS as
read-write ?

Have you used Posgres on Linux writing to a Postgres/XP cluster residing on
a NTFS file system ?
Are Postgres Linux and XP database formats binary compatible ?
My db cluster uses Windows specific locale setting. How Postgres on Linux
interpets this setting ?

Andrus.

As a heads-up, the database has some protection mechanisms that may not
allow you to do this. I can't say for certain, though, so it's at least
worth a shot. I'm interested to know how it turns out.

On Sat, Mar 04, 2006 at 10:43:41AM -0700, William Penberthy wrote:
> Here is an example I always used as a start point in this type of project.
>
> http://campbellcentral.org/rick/code/setup.html
>
> Generally, I would store the datafiles on an NTFS partition - it seems
> easier to reach NTFS from Linux then vice-versa.
>
> I have seen this done successfully with virtually all Linux distributions.
>
> Bill Penberthy
> Scarpa Technology, Inc.
>
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Andrus Moor
> Sent: Saturday, March 04, 2006 8:52 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Using same database from XP and Linux in notebook
>
> I have notebook which can be booted into Windows XP/NTFS and into Linux.
> Notebook is not connected to any network. There are separate IDE partitions
> for both OS.
>
> I want same Postgres 8.1 database to be available in both modes.
>
> I think I must put Postgres database cluster into a NTFS partition which can
>
> be written from Postgres running on Linux or into Linux partition which can
> be written from Postgres running in XP.
>
> Any idea how to implement dual OS database ? Is there a ready to install
> Linux distro which supports this ?
>
> Andrus.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

On Mar 4, 2006, at 7:51 AM, Andrus Moor wrote:

> I have notebook which can be booted into Windows XP/NTFS and into
> Linux.
> Notebook is not connected to any network. There are separate IDE
> partitions
> for both OS.
>
> I want same Postgres 8.1 database to be available in both modes.
>
> I think I must put Postgres database cluster into a NTFS partition
> which can
> be written from Postgres running on Linux or into Linux partition
> which can
> be written from Postgres running in XP.
>
> Any idea how to implement dual OS database ? Is there a ready to
> install
> Linux distro which supports this ?

I've done this in the past (for windows client development) by booting
linux in a vmware partition and running the database there, then
connecting
to it from windows. It also avoids the whole rebooting issue altogether.

Given a decent X server running natively on Windows (the cygwin X
server is workable, if not great) it makes for a good blended
development
environment.

Cheers,
   Steve