Thread: Re: [pgsql-advocacy] Setting up for Press Contacts inSE Asia
Moved to -www On Jan 29, 2008 11:42 AM, Magnus Hagander <magnus@hagander.net> wrote: > This doesn't really belong on advocacy, so let me just post the reason > here, and take further discussions off-list. > > psql locally = locally on his box, *not* wwwmaster, is what I meant. OK, missed the distinction. > We don't want end-users running *anything* on wwwmaster. This is the reason > we made it it's own VM. We do *not* want the mess of svr1 all over again. Unless I missed something (which is possible, I haven't really been paying attention), we're talking about Josh having access to the 186_www database in lieu of an admin interface to... hmm, OK - what is he trying to do exactly? At least part of this thread doesn't seem to be on the archives site or my own mail folder :-( In any case, I don't consider Josh to be an end user, nor do I have any problem giving him a shell account on wwwmaster to do work which sounds like it's comparable to one of us loading the latest version of the docs. I'm pretty confident we can train him not to use the account for any other purpose! I'd certainly much rather do that than have random IPs granted direct access to the DB. /D
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 29 Jan 2008 12:19:31 +0000 "Dave Page" <dpage@postgresql.org> wrote: > In any case, I don't consider Josh to be an end user, nor do I have > any problem giving him a shell account on wwwmaster to do work which > sounds like it's comparable to one of us loading the latest version of > the docs. I'm pretty confident we can train him not to use the account > for any other purpose! I'd certainly much rather do that than have > random IPs granted direct access to the DB. I don't think that is why he wants the database. I think the database is a list of press contacts (I could be wrong). My take is, wwwmaster should only be used "if" required. Otherwise use the french boxen. Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHn1MAATb/zqfZUUQRAqD8AJ0U+l+Hqwfe/l1t8GTAx51akScKewCfT+2B W5NVp5YYaIaiKuGkqneHot0= =FkJi -----END PGP SIGNATURE-----
On Jan 29, 2008 4:23 PM, Joshua D. Drake <jd@commandprompt.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Tue, 29 Jan 2008 12:19:31 +0000 > "Dave Page" <dpage@postgresql.org> wrote: > > > In any case, I don't consider Josh to be an end user, nor do I have > > any problem giving him a shell account on wwwmaster to do work which > > sounds like it's comparable to one of us loading the latest version of > > the docs. I'm pretty confident we can train him not to use the account > > for any other purpose! I'd certainly much rather do that than have > > random IPs granted direct access to the DB. > > I don't think that is why he wants the database. I think the database > is a list of press contacts (I could be wrong). My take is, wwwmaster > should only be used "if" required. Otherwise use the french boxen. > Huh? What have they got to do with this? /D
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 29 Jan 2008 16:26:00 +0000 "Dave Page" <dpage@postgresql.org> wrote: > > I don't think that is why he wants the database. I think the > > database is a list of press contacts (I could be wrong). My take > > is, wwwmaster should only be used "if" required. Otherwise use the > > french boxen. > > > > Huh? What have they got to do with this? > My understanding is that he just needs a database that he has constant access to. Why not just use the french boxen instead of putting yet more stuff on wwwmaster. Or am I missing something? Joshua D. Drake > /D > - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHn1WQATb/zqfZUUQRAimzAKCk0XvcFllCkoKGIUAuj49g78XBPwCfRfFV Y/+HWhA5D5aKXg/lRTcAo0k= =EhXx -----END PGP SIGNATURE-----
On Jan 29, 2008 4:34 PM, Joshua D. Drake <jd@commandprompt.com> wrote: > My understanding is that he just needs a database that he has constant > access to. Why not just use the french boxen instead of putting yet > more stuff on wwwmaster. Or am I missing something? Yeah, I think a few of us have been in this thread. The data will be used by the website anyway - the question is how Josh maintains it and uses it for other purposes. I think we all agree that non-website related work should be done elsewhere (eg. svr1), but he'll still need access to the database, for which I prefer giving a shell account and thus the ability to ssh tunnel to the db over direct access to the db from svr1 or elsewhere. /D
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 29 Jan 2008 16:38:29 +0000 "Dave Page" <dpage@postgresql.org> wrote: > On Jan 29, 2008 4:34 PM, Joshua D. Drake <jd@commandprompt.com> wrote: > > > My understanding is that he just needs a database that he has > > constant access to. Why not just use the french boxen instead of > > putting yet more stuff on wwwmaster. Or am I missing something? > > Yeah, I think a few of us have been in this thread. > > The data will be used by the website anyway - the question is how Josh > maintains it and uses it for other purposes. I think we all agree that > non-website related work should be done elsewhere (eg. svr1), but > he'll still need access to the database, for which I prefer giving a > shell account and thus the ability to ssh tunnel to the db over direct > access to the db from svr1 or elsewhere. O.k. no sweat. Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHn1stATb/zqfZUUQRArulAJ4nERKUCl9jaBBsdqjz4dWlAMOD1gCePR5M tcse/cbBlJ0VD+DGCTXPL2M= =sTwH -----END PGP SIGNATURE-----