Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL setup on dual boot laptop

PostgreSQL setup on dual boot laptop

From
"Brian Johnson"
Date:
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

Re: PostgreSQL setup on dual boot laptop

From
Andrew McMillan
Date:
On Sat, 2002-06-29 at 02:05, Brian Johnson wrote:
>
> 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

This works best for me if I run everything under Linux and run Access in
a vmware session.  As a result I removed all dual booting from my laptop
around 2 years ago.

Cheers,
                    Andrew.
--
--------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/        PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201    MOB: +64(21)635-694    OFFICE: +64(4)499-2267
       Are you enrolled at http://schoolreunions.co.nz/ yet?