Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id ECA609FB542 for ; Mon, 22 Jan 2007 18:09:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 17019-01 for ; Mon, 22 Jan 2007 18:09:55 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from kenobi.snowman.net (kenobi.snowman.net [70.84.9.186]) by postgresql.org (Postfix) with ESMTP id E7DD89FB508 for ; Mon, 22 Jan 2007 18:09:55 -0400 (AST) Received: by kenobi.snowman.net (Postfix, from userid 1000) id E0E855803D; Mon, 22 Jan 2007 16:09:54 -0600 (CST) Date: Mon, 22 Jan 2007 17:09:54 -0500 From: Stephen Frost To: Peter Koczan Cc: "Jim C. Nasby" , pgsql-admin@postgresql.org Subject: Re: Upgrading to 8.2, changes in user/group management scripts Message-ID: <20070122220954.GD24675@kenobi.snowman.net> Mail-Followup-To: Peter Koczan , "Jim C. Nasby" , pgsql-admin@postgresql.org References: <4544e0330701191345l64b72722j7530db0d7d345f6f@mail.gmail.com> <20070121173854.GD77382@nasby.net> <4544e0330701221236o205ec223t7da292a1cce6bba3@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="KSMsDZmyr2nwiDTS" Content-Disposition: inline In-Reply-To: <4544e0330701221236o205ec223t7da292a1cce6bba3@mail.gmail.com> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.6.16-2-vserver-686 (i686) X-Uptime: 17:09:19 up 126 days, 22:18, 19 users, load average: 0.30, 0.48, 0.50 User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/205 X-Sequence-Number: 24361 --KSMsDZmyr2nwiDTS Content-Type: text/plain; charset=us-ascii Content-Disposition: inline * Peter Koczan (pjkoczan@gmail.com) wrote: > The main thing I'm worried about is the orphaned objects problem. It's not > adding users so much as removing them that I'm concerned about (I work at a > University and we remove inactive/non-enrolled users). These cases would > likely require a lot more in-depth intervention by myself and other staff. Isn't there an option to drop the associated objects...? Not sure if that's an option for you though. Stephen --KSMsDZmyr2nwiDTS Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFFtTYyrzgMPqB3kigRAkOEAJ9jgAdZxSd5et2PTNZPoOddF3y77gCfeqOc 0owmBNIIyXrA4gA99wwj4ek= =zKQY -----END PGP SIGNATURE----- --KSMsDZmyr2nwiDTS--