Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux