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 1h9uTY-00056i-QQ for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Mar 2019 16:35:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9uTW-0002Fs-S0 for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Mar 2019 16:35:26 +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 1h9uTW-0002CD-HH for pgsql-hackers@lists.postgresql.org; Fri, 29 Mar 2019 16:35:26 +0000 Received: from mail-qt1-x843.google.com ([2607:f8b0:4864:20::843]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9uTT-0004Dm-K7 for pgsql-hackers@lists.postgresql.org; Fri, 29 Mar 2019 16:35:26 +0000 Received: by mail-qt1-x843.google.com with SMTP id v20so2997605qtv.12 for ; Fri, 29 Mar 2019 09:35:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=9K2d5bPQrNDb9tsramIBKyRrT6OkeWTQSxYnIsPL72I=; b=vZBidePennYgnTH1fmwYH0iFyn29/00kAU7rhePm7NiLRxVvUNq7KasP0cifaiG8lb T1mWpyOAiU2vBVBx6fbkKtKkGBegTWQmo9mtQsog8L4iTySYyvCC89IVSk3neyr9BaPC cjb2JPFDIZUuwibbLQFRRZEIilGuUG0C1S2xSlNGArfqsI3tEPsveXjRrTe5885zz00h ALmunZmBi2QDovTomtOCSiczbumqZYcSj2UhRNNw2zoKsvto6NB757I9NUqGHEkkUoFK bQ7GbDZQoB+g9HEOeIU2UlSEEwMuez/knuOgiU8r6eJfxbAFslIxy2ArvITe/2eXDfMO LxuQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=9K2d5bPQrNDb9tsramIBKyRrT6OkeWTQSxYnIsPL72I=; b=fvdYV56vhRjoLtw+LbEQJJJjYn7KymfNcZdD/5HaYABvkp70eLxCcVYNTAJos+Re/f gYs6QQlN5gZ6m3Nk8BmP7lxGnoNZORpRkS2AovTwNMDO+QU0NGb/fo64vn7GdY08xsv+ 1n2Pht8qYJNpOqKKzlFFRpylOD6p0aK8R8iNkqRGuCGIvT3wLnl+uFttxCmUcFxZ05+C WeCDdOT2tlA7n9iEZmGO9TMdJoOX4BiU8CZ9ynZ+w0qYusMEFlNeWFS/6YfYyAKZGXjI htfIvUwGLuPxO93ndgFYhhJ7hyiylHmLTz4/GCzzj7XJkanQiIHJtjSZSytjxO1xp8yh dUyA== X-Gm-Message-State: APjAAAVoCiNskFmSjL6aqqnOVrvT0rREnNV9sdLdA/jSEeqkSyneuQ5Z prVX8YkcsHdpyDbhq5woJGuFkg== X-Google-Smtp-Source: APXvYqyHcUjXSjZXwhwK7Cz31qY6S96xPUk7cq6Sva7tRrX5bci0EzcgJW7N1Z720TybfjR9EmWS8w== X-Received: by 2002:a0c:c486:: with SMTP id u6mr39916680qvi.145.1553877321672; Fri, 29 Mar 2019 09:35:21 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id d21sm1623816qtc.91.2019.03.29.09.35.20 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Fri, 29 Mar 2019 09:35:20 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id E1C8B120A6D; Fri, 29 Mar 2019 13:35:18 -0300 (-03) Date: Fri, 29 Mar 2019 13:35:18 -0300 From: Alvaro Herrera To: Tom Lane Cc: Christoph Berg , Tatsuo Ishii , andreas@proxel.se, tomas.vondra@2ndquadrant.com, eldmannen@gmail.com, mark.kirkwood@catalyst.net.nz, michael@paquier.xyz, chris.travers@adjust.com, euler@timbira.com.br, rjuju123@gmail.com, pgsql-hackers@lists.postgresql.org Subject: Re: PostgreSQL pollutes the file system Message-ID: <20190329163518.GA2370@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <24256.1553874086@sss.pgh.pa.us> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-Mar-29, Tom Lane wrote: > 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? +1, as I proposed in 2016: https://www.postgresql.org/message-id/20160826202911.GA320593@alvherre.pgsql -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services