Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9tdl-0002PL-4v for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Mar 2019 15:41:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9tdj-0007Z6-U7 for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Mar 2019 15:41:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9tdj-0007Wn-Gm for pgsql-hackers@lists.postgresql.org; Fri, 29 Mar 2019 15:41:55 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9tdh-0003wI-3z for pgsql-hackers@lists.postgresql.org; Fri, 29 Mar 2019 15:41:54 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x2TFfQb7024257; Fri, 29 Mar 2019 11:41:26 -0400 From: Tom Lane To: Christoph Berg cc: Tatsuo Ishii , andreas@proxel.se, tomas.vondra@2ndquadrant.com, eldmannen@gmail.com, mark.kirkwood@catalyst.net.nz, michael@paquier.xyz, chris.travers@adjust.com, alvherre@2ndquadrant.com, euler@timbira.com.br, rjuju123@gmail.com, pgsql-hackers@lists.postgresql.org Subject: Re: PostgreSQL pollutes the file system In-reply-to: <20190329152557.GI20294@msg.df7cb.de> References: <20190327142657.GC17983@development> <375ea28a-2e8c-9954-66b1-bd0a3ff657f5@proxel.se> <18182.1553697687@sss.pgh.pa.us> <20190329.100407.1159785913847835944.t-ishii@sraoss.co.jp> <20190329152557.GI20294@msg.df7cb.de> Comments: In-reply-to Christoph Berg message dated "Fri, 29 Mar 2019 16:25:57 +0100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <24255.1553874086.1@sss.pgh.pa.us> Date: Fri, 29 Mar 2019 11:41:26 -0400 Message-ID: <24256.1553874086@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Christoph Berg writes: > What might possibly make sense is to add options to psql to > facilitate common tasks: > psql --createdb foo > psql --createuser bar --superuser > psql --reindex foo That's a thought. Or perhaps better, allow pg_ctl to grow new subcommands for those tasks? regards, tom lane