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

2012-08-23 Thread Tom Lane
Peter Eisentraut 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 code.

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?

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

2012-07-01 Thread Robert Haas
On Fri, Jun 29, 2012 at 3:32 PM, Bruce Momjian 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 on being

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 > > wrote: > > > Excerpts from Robert Haas's message of lun jun 25 11:57:36 -0400 2012: > > >> Really

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 > 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

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 c

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

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

2012-06-27 Thread Amit Kapila
Tom Lane writes: Amit Kapila 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

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

2012-06-26 Thread Tom Lane
Amit Kapila 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 issue whatsoever o

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

2012-06-25 Thread Amit Kapila
From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Tom Lane Robert Haas 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 connectio

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

2012-06-25 Thread Tom Lane
Robert Haas 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 pg_upgrade can conne

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 > 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 th

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

2012-06-25 Thread Robert Haas
On Mon, Jun 25, 2012 at 2:49 PM, Alvaro Herrera 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 database >> names w

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.

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

2012-06-25 Thread Robert Haas
On Sat, Jun 23, 2012 at 6:26 PM, 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. Oops. That was an oversight. >

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.

[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 run