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

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Zdeněk Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Survey: renaming/removing script binaries (createdb, createuser...)
Date: 2008-03-26 17:46:46
Message-ID: 47EA8C06.3030702@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-03-26 17:48:23 Re: PostgreSQL Replication with read-only access to standby DB
Previous Message Alvaro Herrera 2008-03-26 17:46:12 Re: Survey: renaming/removing script binaries (createdb, createuser...)