PostgreSQL setup on dual boot laptop - Mailing list pgsql-novice

From Brian Johnson
Subject PostgreSQL setup on dual boot laptop
Date
Msg-id 001101c21ea6$8b5e1b40$4200a8c0@jecinc.on.ca
Whole thread Raw
Responses Re: PostgreSQL setup on dual boot laptop
List pgsql-novice
I'm looking for advice on the concept of how I should set up my laptop

I've already set it up as dual boot Win98 and RH7.3 Linux

Here's my scenario:
small LAN with a Linux server running with mainly Windows workstations
(would like to switch workstations to Linux)

Here's the tasks I'd like to do
1. convert an existing MS Access database to PostgreSQL and change the Front
end to HTML based or OpenOffice
2. Have offline access to our main database (contacts & project listings)
when the laptop is disconnected from the LAN (two way replication)
3. Allow other laptop users to also have similar setup for offline access
(two other laptop users)
4. Have final system work under both Windows and Linux


Here's what I think will work (I'd like comments):
1. run cygwin under Windows to provide PostgreSQL and Apache servers.  Wwhen
running Linux, local servers can be run normally (can the Linux PostgreSQL
use the same data files as the cygwin PostgreSQL)
2. setup some kind of replication system for both Windows/Cygwin and Linux
to sync the laptop to the server when connected (can this be automated for
Windows?  Linux?)


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.org
For additional commands, e-mail: users-help@openoffice.org




pgsql-novice by date:

Previous
From: Tony Griffiths
Date:
Subject: Accessing geometric values from embedded SQL
Next
From: "James Kelty"
Date:
Subject: Re: NFS/NAS