PostGIS workflow

[George Silva]

Hello guys and gals!

First of all, I think this is a wonderful project and the GIS people have been dreaming about this for a loong time.

I have read the manual (parts of it) and I have some questions, to be able to determine if this is suitable for our workflow.

First:

I have an routing application that needs to import data regularly. That is, all data is exported from PostGIS databases (cartography production) to shapefiles, and then uploaded to our server, which grinds through this data, and imports it correctly in another PostGIS database.

I was thinking a more natural approach through this problem, and I think GeoGIt can help me.

My two approaches can be:

1 - Export all transaction logs to PostgreSQL server. The server would pick this logs, and "import" the data. I can do this with pgbarman or other simple unix tools.

2 - Use geogit. My remote would be the remote server. All my production users would work on the cartography side of things. Whenever the work is done, I would just commit and push the data.

Is this workflow possible with geogit?

In the manual, it states that geogit has to import all data to its .geogit folder. 

How that is handled by the database? 

I would no longer edit directly in the database, but in a local PostGIS, connected to geogit? 

Can I start the geogit repository in my local server and sync that with the other server (remote)? All my users would continue to use QuantumGIS and all the already made PostGIS verifications we have and just export it when necessary?

So, some light, please?

Thanks everyone!