Re: [HACKERS] new --maintenance-db options

2012-08-23 Thread Peter Eisentraut
On Sun, 2012-06-24 at 01:26 +0300, Peter Eisentraut wrote: About the new --maintenance-db options: Why was this option not added to createuser and dropuser? In the original discussion[0] they were mentioned, but it apparently never made it into the code. What should we do with this? Add

Re: [HACKERS] new --maintenance-db options

2012-08-23 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On Sun, 2012-06-24 at 01:26 +0300, Peter Eisentraut wrote: About the new --maintenance-db options: Why was this option not added to createuser and dropuser? In the original discussion[0] they were mentioned, but it apparently never made it into the

Re: [HACKERS] new --maintenance-db options

2012-07-01 Thread Robert Haas
On Fri, Jun 29, 2012 at 3:32 PM, Bruce Momjian br...@momjian.us wrote: On Mon, Jun 25, 2012 at 11:57:36AM -0400, Robert Haas wrote: In retrospect, it seems as though it might have been a good idea to make the postgres database read-only and undroppable, so that all client utilities could count

Re: [HACKERS] new --maintenance-db options

2012-06-29 Thread Bruce Momjian
On Sun, Jun 24, 2012 at 01:26:58AM +0300, Peter Eisentraut wrote: About the new --maintenance-db options: What is the purpose of these options? The initial discussion was unclear on this. The documentation contains no explanation of why they should be used. If we want to really support the

Re: [HACKERS] new --maintenance-db options

2012-06-29 Thread Bruce Momjian
On Mon, Jun 25, 2012 at 11:57:36AM -0400, Robert Haas wrote: In retrospect, it seems as though it might have been a good idea to make the postgres database read-only and undroppable, so that all client utilities could count on being able to connect to it and get a list of databases in the

Re: [HACKERS] new --maintenance-db options

2012-06-29 Thread Bruce Momjian
On Mon, Jun 25, 2012 at 02:58:25PM -0400, Robert Haas wrote: On Mon, Jun 25, 2012 at 2:49 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Robert Haas's message of lun jun 25 11:57:36 -0400 2012: Really, I think pg_upgrade needs this option too, unless we're going to kill

Re: [HACKERS] new --maintenance-db options

2012-06-29 Thread Bruce Momjian
On Mon, Jun 25, 2012 at 03:12:00PM -0400, Alvaro Herrera wrote: Excerpts from Robert Haas's message of lun jun 25 14:58:25 -0400 2012: On Mon, Jun 25, 2012 at 2:49 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Robert Haas's message of lun jun 25 11:57:36 -0400

Re: [HACKERS] new --maintenance-db options

2012-06-27 Thread Amit Kapila
Tom Lane t...@sss.pgh.pa.us writes: Amit Kapila amit.kap...@huawei.com writes: [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Tom Lane The implementation I've wanted to see for some time is that you can start a standalone backend, but it speaks FE/BE protocol to its caller

Re: [HACKERS] new --maintenance-db options

2012-06-26 Thread Amit Kapila
From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Tom Lane Robert Haas robertmh...@gmail.com writes: From pg_upgrade's perspective, it would be nice to have a flag that starts the server in some mode where nobody but pg_upgrade can connect to it

Re: [HACKERS] new --maintenance-db options

2012-06-26 Thread Tom Lane
Amit Kapila amit.kap...@huawei.com writes: [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Tom Lane The implementation I've wanted to see for some time is that you can start a standalone backend, but it speaks FE/BE protocol to its caller (preferably over pipes, so that there is no

Re: [HACKERS] new --maintenance-db options

2012-06-25 Thread Robert Haas
On Sat, Jun 23, 2012 at 6:26 PM, Peter Eisentraut pete...@gmx.net wrote: About the new --maintenance-db options: Why was this option not added to createuser and dropuser?  In the original discussion[0] they were mentioned, but it apparently never made it into the code. Oops. That was an

Re: [HACKERS] new --maintenance-db options

2012-06-25 Thread Alvaro Herrera
Excerpts from Robert Haas's message of lun jun 25 11:57:36 -0400 2012: Really, I think pg_upgrade needs this option too, unless we're going to kill the problem at its root by providing a reliable way to enumerate database names without first knowing the name one that you can connect to. I

Re: [HACKERS] new --maintenance-db options

2012-06-25 Thread Robert Haas
On Mon, Jun 25, 2012 at 2:49 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Robert Haas's message of lun jun 25 11:57:36 -0400 2012: Really, I think pg_upgrade needs this option too, unless we're going to kill the problem at its root by providing a reliable way to enumerate

Re: [HACKERS] new --maintenance-db options

2012-06-25 Thread Alvaro Herrera
Excerpts from Robert Haas's message of lun jun 25 14:58:25 -0400 2012: On Mon, Jun 25, 2012 at 2:49 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Robert Haas's message of lun jun 25 11:57:36 -0400 2012: Really, I think pg_upgrade needs this option too, unless we're

Re: [HACKERS] new --maintenance-db options

2012-06-25 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: From pg_upgrade's perspective, it would be nice to have a flag that starts the server in some mode where nobody but pg_upgrade can connect to it and all connections are automatically allowed, but it's not exactly clear how to implement nobody but

[HACKERS] new --maintenance-db options

2012-06-23 Thread Peter Eisentraut
About the new --maintenance-db options: Why was this option not added to createuser and dropuser? In the original discussion[0] they were mentioned, but it apparently never made it into the code. I find the name to be unfortunate. For example, I think of running vacuum as maintenance. So

Re: [HACKERS] new --maintenance-db options

2012-06-23 Thread Dave Page
On Saturday, June 23, 2012, Peter Eisentraut wrote: About the new --maintenance-db options: Why was this option not added to createuser and dropuser? In the original discussion[0] they were mentioned, but it apparently never made it into the code. I find the name to be unfortunate. For