[postgis-users] synchronise /replicate postgis database

Chris Hermansen chris.hermansen at timberline.ca
Wed Mar 12 09:27:32 PDT 2008

Create roles for all of your users.
Create two databases, production and publication.
grant the appropriate privileges to each database and to the tables
contained in the database to the roles.

Not difficult!  You will need to study:

- the "createuser" postgresql command-line utility
- the "createdb" postgresql command-line utility
- the SQL "GRANT" command

As an alternative to "createuser" and "createdb" you may wish to use the
"PGAdmin" GUI utility.

Intengu Technologies wrote:
> Hello list members, please assist this newbie how to implement the
> scenario below.
> What I would want to do is to have a production and publication
> database on a single physical machine also on this machine we will
> have our web mapping server(do not have funds to buy an additional
> server).
> Will have read/write access on this database for  only two people.
> Will have read only access for our users (20).  They could use web or
> desktop clients to access our data.
> Will also want to update the publication database with changes that
> have been made on the production database at predetermined intervals.
> Any additional advice would be greatly appreciated.
> -- 
> Sindile Bidla
> ------------------------------------------------------------------------
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


Chris Hermansen · mailto:clh at timberline.ca
tel:+1.604.714.2878 · fax:+1.604.733.0631
Timberline Natural Resource Group · http://www.timberline.ca
401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5

C'est ma façon de parler.

More information about the postgis-users mailing list