Best bet is probably either dump and restore or shipping transaction logs. Slony is another option, but it's probably overkill. On Thu, Sep 22, 2005 at 11:19:14AM -0700, Art Fore wrote: > I have a psql database (8.01) running on a Suse 9.3 linux server, and I > have the same database (8.03) running on winxp laptop. I do updates, > that is, add parts to a table on the linux server quite frequently using > MS Access, all well and good. I also have pgadmin 3 on my machine for > editing the database sometimes, but I find access much easier to add new > parts to a new parts table in Access and then update the linux database. > I could also add these parts to the local machine the same way, but, I > have a work colleague that needs the same database. (Database is used by > another program as a parts entry database for a schematic capture > program and works very well via ODBC) Other userss have desktops so they > access the database on the linux server. The laptops though are taken > home for work and need the database to be mobile, that is why I set it > up that way. I was trying to figure out an easier way for my colleage to > update his database on his machine from the linux machine database. > Could do it with MSAccess I guess, but would like to find out if there > is another way to do this without MSAccess. > > Any suggestions on what would be an easy way to update the database on > the laptop with the main database on the linux server? There is only one > table that needs to be updated. > > TIA > > Art > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
