Hi,
I realise this is probably a very basic question but if anyone could point
me in the right direction i'd be very grateful.
I have a database which is just my data table and "geometry columns" and
"spatial_ref_sys" tables.
The data is of a significant volume with periodic updates which take days to
re-index
Apart from the updating (every month or so), read only access is the only
interaction.
Which is the best of the following options:
1) Run 2 copies of the database table and switch between them depending on
which is being updated
a) How would i create a copy of the table with the data it holds now
b) Is it better to create a copy within the same database or another on
the same server
2) Create a copy of the data and somehow change the table/database name
rather than
a) Is it ok to simply rename a database table so that any connecting
services just connect to a different table without being updated.
b) As for 1, i would need to know the best way to establish a copy
Of course, even better would be a way to reindex whilst a database is in use
but i'm under the impression that this is not possible at the moment?
Apologies again if this is a blindingly obvious question, didn't see
anything in the forums.
Thanks
Andy
--
View this message in context:
http://old.nabble.com/Basic-duplicating-database-question-tp30018606p30018606.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
