PostgreSQL Discussion - database update question

Author

database update question

Art Fore

2005-09-22, 8:24 pm

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

2005-09-22, 8:24 pm

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@pervasive.com
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

Sponsored Links