Hi:
Here’s the problem...
I have a read-only DB that gets reloaded from scratch every night. This takes several hours and I don’t want any late night users to have to wait for this process to complete, so I have 2 DBs. The first DB is the one the users access. Call it “main_db”. I load a second DB which has an identical architecture at night. Call it “standby_db”. When the load finishes, I rename “main_db” to “tmp”, then rename “standby_db” to “main_db”, then rename “tmp” to “standby_db”. So, the users should have access to a “main_db” all the time (except for a second when the renames happen). And “standby_db” serves as a full backup which I can use should I need it.
Here’s the problem...
Sometimes the renames fail because people are still attached to either “main_db” or “standby_db”. The error messages indicate this is the problem anyway. Someof those users (most of them) are probably fast asleep at home and forgot to exit the interactive session that was connected to the DB.
Q: Is there a way I can set a timeout where, if a user is inactive for say an hour, they get disconnected?
Q Is there a way to “kill” all active users without having to cycle the DB server with something like “pg_ctl stop –m fast –D ...” ?
Q: (the best option)... Is there a way I can leave those users attached to their DB regardless of the fact that it’s name changed while they were attached?
Thanks in ADvance for any help.