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 1h9tON-0001eZ-FH for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Mar 2019 15:26:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9tOL-0003Ta-Mz for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Mar 2019 15:26:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9tOL-0003TT-Eq for pgsql-hackers@lists.postgresql.org; Fri, 29 Mar 2019 15:26:01 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9tOJ-0002D1-1r for pgsql-hackers@lists.postgresql.org; Fri, 29 Mar 2019 15:26:01 +0000 Received: from msg.df7cb.de (unknown [IPv6:2003:5b:203b:100:7627:eaff:fe52:8e03]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 44W5D61kRWz3Dws; Fri, 29 Mar 2019 16:25:58 +0100 (CET) Date: Fri, 29 Mar 2019 16:25:57 +0100 From: Christoph Berg To: Tatsuo Ishii Cc: tgl@sss.pgh.pa.us, 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 Message-ID: <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> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20190329.100407.1159785913847835944.t-ishii@sraoss.co.jp> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Re: Tatsuo Ishii 2019-03-29 <20190329.100407.1159785913847835944.t-ishii@sraoss.co.jp> > If we were to invent new command names, what about doing similar to > git? I mean something like: > > pgsql createdb .... That is pretty close to "psql" and it will be utterly confusing for new users. And everyone will have a hard time when talking about the tools, imagine someone saying "please run psql appdbname" or "please run pgsql createdb". The difference is just too small. 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 Christoph