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

["Joey K." <pguser@xxxxxxxxx>]

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

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