[postgis-users] Basic duplicating database question

[lplateandy]

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.