Fwd: Survey: renaming/removing script binaries (createdb, createuser...)

---------- Forwarded message ----------
From: Joey K. <pguser(at)gmail(dot)com>
Date: Wed, Mar 26, 2008 at 9:42 AM
Subject: Re: [GENERAL] Survey: renaming/removing script binaries (createdb,
createuser...)
To: Zdeněk Kotala <Zdenek(dot)Kotala(at)sun(dot)com>

Please let us know your meaning,
>
> thanks Zdenek Kotala
>
>
> 1) What type of names do you prefer?
> -------------------------------
>
> a) old notation - createdb, createuser ...
> b) new one with pg_ prefix - pg_createdb, pg_creteuser ...
> c) new one with pg prefix - pgcreatedb, pgcreateuser ...
> d) remove them - psql is the solution
> e) remove them - pgadmin is the solution
>

[b]

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

[a]
In cron
from commandline.
in shell scripts

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

[c]

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

[a], [b] and [c]
Depending on the situation. For example ifcustomers complain, we manually do
cia SQL.

If this is a consistent problem, we usr cron for vacuumdb.

If the database is not too loaded and supports autovacuum, we also have
autovacuum enabled.

We'd like to keep vacuumdb but maybe pg_vacuumdb?

Hope this helps.

Joey