| From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | live metadata changes v8.3.4 |
| Date: | 2011-09-27 20:51:42 |
| Message-ID: | 482E80323A35A54498B8B70FF2B8798004D2D6172C@azsmsx504.amr.corp.intel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi:
How does one make a metadata change to a DB that's actively being used. Specifically, I want to drop a view, drop some columns from a table that's used in the view, recreate the view without those columns.
In the past, I've resorted to connecting as a super user, running "select procpid from pg_stat_activity..." then pg_ctl kill ABRT <procpid>. This would create a window where I could get in and make the change. But it also created some angry users whos processes got killed.
V8.3.4 on linux.
Thanks for any advice !
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Long | 2011-09-27 20:51:49 | Identifying old/unused views and table |
| Previous Message | Merlin Moncure | 2011-09-27 20:25:00 | Re: [Solved] Generic logging system for pre-hstore using plperl triggers |