Re: Survey: renaming/removing script binaries (createdb, createuser...) - Mailing list pgsql-general

From Ron Mayer
Subject Re: Survey: renaming/removing script binaries (createdb, createuser...)
Date
Msg-id 47EA8C06.3030702@cheapcomplexdevices.com
Whole thread Raw
In response to Survey: renaming/removing script binaries (createdb, createuser...)  (Zdeněk Kotala <Zdenek.Kotala@Sun.COM>)
Responses Re: Survey: renaming/removing script binaries (createdb, createuser...)  ("Leif B. Kristensen" <leif@solumslekt.org>)
Re: Survey: renaming/removing script binaries (createdb, createuser...)  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Re: Survey: renaming/removing script binaries (createdb, createuser...)  ("Dawid Kuroczko" <qnex42@gmail.com>)
List pgsql-general
Zdeněk Kotala wrote:

> 1) What type of names do you prefer?

I'd prefer a "pg" program that took as arguments
the command.  So you'd have "pg createdb" instead
of "pg_createdb".

There are many precedents. "cvs update", "git pull"
"apt-get install".

Anyone else like this approach?

Of the choices, though, I prefer (d).


> 2) How often do you use these tools?
> -----------------------------------
>
> a) every day (e.g. in my cron)
> b) one per week
> c) one time
> d) never

About monthly.  I guess (b) is closest.


> 3) What name of initdb do you prefer?
> ---------- --------------------------
>
> a) initdb
> b) pg_initdb
> c) pg_init
> d) pg_ctl -d <dir> init  (replace initdb with pg_ctl new functionality)
> e) What is initdb? My start/stop script does it automatically.

pg initdb

Of the choices, though, I guess (d).


> 4) How do you perform VACUUM?
> -----------------------------
>
> a) vacuumdb - shell command
> b) VACUUM - SQL command
> c) autovacuum
> d) What is vacuum?

(c) on most databases
(b) on certain databases



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Survey: renaming/removing script binaries (createdb, createuser...)
Next
From: Alvaro Herrera
Date:
Subject: Re: PostgreSQL Replication with read-only access to standby DB