Re: [PATCHES] script binaries renaming

2008-04-01 Thread Bruce Momjian

FYI, the patch author and survey requestor has withdrawn the patch with
the following comment:

> I think we can reject this patch. I don't process yet output from survey
> on general, but it seems that more users prefer pg_ prefix, but idea of
> "pgc" command seems to be better. I think it is good idea for 9.0 release.

The TODO item has been removed as well:

* Prefix command-line utilities like createuser with 'pg_'

  http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php

---

Zdenek Kotala wrote:
> Tom Lane napsal(a):
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> Where are we on this?  Tom thinks we don't want this.  TODO has:
> >>* Prefix command-line utilities like createuser with 'pg_'
> >>  http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php
> > 
> >> I think we need to make a decision.
> > 
> > Well, I don't have any particular objection to adding pg_ prefixes
> > as alternate names for the existing scripts.  However, it's not clear
> > what is the point unless we have the intention to remove the old names
> > at some time in the foreseeable future.  And the consensus of the
> > previous thread on -patches seemed to be that nobody except Zdenek
> > was very eager to do that.
> 
> Yeah, I have to had two reason for this patch. First is my personal, because 
> I 
> don't like these names since 1999. And second is that Solaris architects do 
> not 
> like these names. Especially createdb and createuser. It could clash with 
> some 
> system utility.
> 
> > In any case, there is no value in discussing this further on -patches
> > since the readers of this list already weighed in.  If you want to
> > make a decision then it needs to be made on -hackers or -general.
> 
> I think both are important (maybe general is more important). Maybe we can 
> put 
> also a survey on webpage.
> 
> On other side. The question is also if we really still need these utilities? 
> If 
> you look on them there are missing features. E.g vacuumdb does not allow make 
> VACUUM FREEZ or set some modern version of vacuum parameters. There is not 
> createtablespace command and so on...
> 
>   Zdenek

-- 
  Bruce Momjian  <[EMAIL PROTECTED]>http://momjian.us
  EnterpriseDB http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

-- 
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches


Re: [PATCHES] script binaries renaming

2008-03-24 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Mon, 24 Mar 2008 18:30:46 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:

> Which part of "this is the wrong list" wasn't clear to you guys?

I actually didn't even notice. Sorry Tom.

Joshua D. Drake


- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH6C1YATb/zqfZUUQRAlenAJwIBnHS0rWIyx2gE/lbeHWEmeGVgACbB/1/
HmcDiHcVbe5zhJcXW8oir1g=
=KS1F
-END PGP SIGNATURE-

-
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches


Re: [PATCHES] script binaries renaming

2008-03-24 Thread Tom Lane
Which part of "this is the wrong list" wasn't clear to you guys?

regards, tom lane

-
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches


Re: [PATCHES] script binaries renaming

2008-03-24 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Mon, 24 Mar 2008 14:12:19 -0700
David Fetter <[EMAIL PROTECTED]> wrote:


> > Yeah, I have to had two reason for this patch. First is my personal,
> > because I don't like these names since 1999. And second is that
> > Solaris architects do not like these names. Especially createdb and
> > createuser. It could clash with some system utility.
> 
> +1 for renaming the utilities.  Not stomping on the global namespace
> is one place where MySQL is really out ahead of us.

- -1 I have not yet seen an argument that has compelled me to actually
want to have us enter the Gnome world of binary naming.

However, if we *must* go down this route let us please use pgcreatedb
*not* pg_createdb.

Sincerely,

Joshua D. Drake


- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH6BohATb/zqfZUUQRAjm5AJ0QFb1C5/BaAIMjnu/OdqTsCO/1EACfX3XL
PNC+b1WIXd1fgJz23e9Gles=
=UkoA
-END PGP SIGNATURE-

-
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches


Re: [PATCHES] script binaries renaming

2008-03-24 Thread David Fetter
On Mon, Mar 24, 2008 at 09:19:42PM +0100, Zdenek Kotala wrote:
> Tom Lane napsal(a):
>> Bruce Momjian <[EMAIL PROTECTED]> writes:
>>> Where are we on this?  Tom thinks we don't want this.  TODO has:
>>> * Prefix command-line utilities like createuser with 'pg_'
>>>   http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php
>>
>>> I think we need to make a decision.
>>
>> Well, I don't have any particular objection to adding pg_ prefixes
>> as alternate names for the existing scripts.  However, it's not
>> clear what is the point unless we have the intention to remove the
>> old names at some time in the foreseeable future.  And the
>> consensus of the previous thread on -patches seemed to be that
>> nobody except Zdenek was very eager to do that.
>
> Yeah, I have to had two reason for this patch. First is my personal,
> because I don't like these names since 1999. And second is that
> Solaris architects do not like these names. Especially createdb and
> createuser. It could clash with some system utility.

+1 for renaming the utilities.  Not stomping on the global namespace
is one place where MySQL is really out ahead of us.

Cheers,
David.
-- 
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter  XMPP: [EMAIL PROTECTED]

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

-
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches


Re: [PATCHES] script binaries renaming

2008-03-24 Thread Zdenek Kotala

Tom Lane napsal(a):

Bruce Momjian <[EMAIL PROTECTED]> writes:

Where are we on this?  Tom thinks we don't want this.  TODO has:
* Prefix command-line utilities like createuser with 'pg_'
  http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php



I think we need to make a decision.


Well, I don't have any particular objection to adding pg_ prefixes
as alternate names for the existing scripts.  However, it's not clear
what is the point unless we have the intention to remove the old names
at some time in the foreseeable future.  And the consensus of the
previous thread on -patches seemed to be that nobody except Zdenek
was very eager to do that.


Yeah, I have to had two reason for this patch. First is my personal, because I 
don't like these names since 1999. And second is that Solaris architects do not 
like these names. Especially createdb and createuser. It could clash with some 
system utility.



In any case, there is no value in discussing this further on -patches
since the readers of this list already weighed in.  If you want to
make a decision then it needs to be made on -hackers or -general.


I think both are important (maybe general is more important). Maybe we can put 
also a survey on webpage.


On other side. The question is also if we really still need these utilities? If 
you look on them there are missing features. E.g vacuumdb does not allow make 
VACUUM FREEZ or set some modern version of vacuum parameters. There is not 
createtablespace command and so on...


Zdenek

-
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches


Re: [PATCHES] script binaries renaming

2008-03-24 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Where are we on this?  Tom thinks we don't want this.  TODO has:
>   * Prefix command-line utilities like createuser with 'pg_'
> http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php

> I think we need to make a decision.

Well, I don't have any particular objection to adding pg_ prefixes
as alternate names for the existing scripts.  However, it's not clear
what is the point unless we have the intention to remove the old names
at some time in the foreseeable future.  And the consensus of the
previous thread on -patches seemed to be that nobody except Zdenek
was very eager to do that.

In any case, there is no value in discussing this further on -patches
since the readers of this list already weighed in.  If you want to
make a decision then it needs to be made on -hackers or -general.

regards, tom lane

-
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches


Re: [PATCHES] script binaries renaming

2008-03-24 Thread Bruce Momjian

Where are we on this?  Tom thinks we don't want this.  TODO has:

* Prefix command-line utilities like createuser with 'pg_'

  http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php

I think we need to make a decision.

---

Zdenek Kotala wrote:
> I attach complete patch which renames following binaries
> 
> createdb createlang createuser dropdb droplang dropuser clusterdb 
> vacuumdb reindexdb
> 
> to
> 
> pg_createdb pg_createlang pg_createuser pg_dropdb pg_droplang 
> pg_dropuser pg_clusterdb pg_vacuumdb pg_reindexdb
> 
> Symlinks (or copy on win32) are created for backward compatibility.
> 
> This renaming was discussed there:
> 
> http://archives.postgresql.org/pgsql-hackers/2007-06/msg00145.php
> 
> I create also separate unified patch for documentation.
> 
>   Zdenek

[ application/x-gzip is not supported, skipping... ]

> 
> ---(end of broadcast)---
> TIP 7: You can help support the PostgreSQL project by donating at
> 
> http://www.postgresql.org/about/donate

-- 
  Bruce Momjian  <[EMAIL PROTECTED]>http://momjian.us
  EnterpriseDB http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

-
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches


Re: [PATCHES] script binaries renaming

2007-07-09 Thread Zdenek Kotala

Jaime Casanova wrote:



what makes me wonder why doesn't exist "pg_ctl init"



I suggested it in previous discussion on hackers. See

http://archives.postgresql.org/pgsql-hackers/2007-06/msg00142.php

Zdenek

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

   http://www.postgresql.org/about/donate


Re: [PATCHES] script binaries renaming

2007-07-09 Thread Zdenek Kotala

Tom Lane wrote:

Zdenek Kotala <[EMAIL PROTECTED]> writes:

Dave Page wrote:

This is almost as bad as Magnus agreeing with JD (!), but I agree with
Peter :-). After years of typing the current names, changing them does
seem somewhat annoying. Worse yet, pg_* is just awkward to type.


But these utilities are mostly using in scripts -> one type, multi use. 


According to whom?  The ones that are really at issue I think are
createuser/createlang/dropuser/droplang, and those seem mainly intended
for interactive use.  In a script you might as well use psql -c.

The ones that have "db" in the name do not seem to me to need renaming.
While maybe not obviously connected to Postgres, the chance of a
collision with some other project is low.


Yes, but if we rename four why does it do for all of them?


One that I'd personally vote to remove completely is "ipcclean".
It's always been a crude, incomplete hack anyway, and the reason
no one has bothered to improve it is that there is next to no use
for it anymore.


And what's about remove all script commands? Everybody can use psql -c and it 
decreases amount of code. Initdb should be replaced by pg_ctl init command. We 
can plan it for Postgresql 9.0 as a main change :-).


Zdenek

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [PATCHES] script binaries renaming

2007-07-09 Thread Zdenek Kotala

Tom Lane wrote:

Zdenek Kotala <[EMAIL PROTECTED]> writes:
There is group of people who has different opinion. The main reasons for 
this patch are 1) names could collide with system tools


That argument is purely theoretical, though, since no one has complained
to us of an *actual* collision.  With these utilities having been around
with their current names for more than ten years, I think we've
established sufficient squatter's rights on the names ;-). 


You have right on linux/*bsd world where postgres is squatter :-) for long time. 
But in Solaris world (and probably in HP-UX, AIX...) postgresql does not have 
established these squatter's rights. And names as "createuser" is something like 
reserved keyword for OS utilities.



Zdenek

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


Re: [PATCHES] script binaries renaming

2007-07-07 Thread Dave Page
Michael Glaesemann wrote:
> 
> On Jul 7, 2007, at 13:50 , Tom Lane wrote:
> 
>> Zdenek Kotala <[EMAIL PROTECTED]> writes:
>>> Dave Page wrote:
 This is almost as bad as Magnus agreeing with JD (!), but I agree with
 Peter :-). After years of typing the current names, changing them does
 seem somewhat annoying. Worse yet, pg_* is just awkward to type.
>>
>>> But these utilities are mostly using in scripts -> one type, multi use.
>>
>> According to whom?  The ones that are really at issue I think are
>> createuser/createlang/dropuser/droplang, and those seem mainly intended
>> for interactive use.  In a script you might as well use psql -c.
> 
> I'm curious as to know how often these are used at all. I think I may
> have used createuser once and used to use createlang, but I can't recall
> ever using the others.
> 
> Michael Glaesemann
> grzm seespotcode net
> 

I use createuser, createdb all the time, as well as createlang from time
to time. I never use the drop versions.


Regards, Dave

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [PATCHES] script binaries renaming

2007-07-07 Thread Jaime Casanova

On 7/7/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:

I'm curious as to know how often these are used at all. I think I may
have used createuser once and used to use createlang, but I can't
recall ever using the others.



i used to use createlang before the pg_pltemplate exists (because i
hate to have to create those pl handlers at hand). after that the only
script that has a real use to me is initdb and pg_ctl

what makes me wonder why doesn't exist "pg_ctl init"

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
  Richard Cook

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [PATCHES] script binaries renaming

2007-07-07 Thread Michael Glaesemann


On Jul 7, 2007, at 13:50 , Tom Lane wrote:


Zdenek Kotala <[EMAIL PROTECTED]> writes:

Dave Page wrote:
This is almost as bad as Magnus agreeing with JD (!), but I agree  
with
Peter :-). After years of typing the current names, changing them  
does

seem somewhat annoying. Worse yet, pg_* is just awkward to type.


But these utilities are mostly using in scripts -> one type, multi  
use.


According to whom?  The ones that are really at issue I think are
createuser/createlang/dropuser/droplang, and those seem mainly  
intended

for interactive use.  In a script you might as well use psql -c.


I'm curious as to know how often these are used at all. I think I may  
have used createuser once and used to use createlang, but I can't  
recall ever using the others.


Michael Glaesemann
grzm seespotcode net



---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [PATCHES] script binaries renaming

2007-07-07 Thread Tom Lane
Zdenek Kotala <[EMAIL PROTECTED]> writes:
> There is group of people who has different opinion. The main reasons for 
> this patch are 1) names could collide with system tools

That argument is purely theoretical, though, since no one has complained
to us of an *actual* collision.  With these utilities having been around
with their current names for more than ten years, I think we've
established sufficient squatter's rights on the names ;-).  No doubt
we'd do it differently if starting in a green field, but we're not
starting in a green field.  There's enough usage precedent now that I
doubt we can ever remove the existing names, which leaves me wondering
what is the point.

> By the way my original idea was create new command "pg_cmd", which 
> integrates all in one include missing commands(e.g. createtablespace).

There doesn't seem to be anyone but you who feels any attraction to that
concept.  These utilities have a wide enough difference in behavior and
intended usage that ISTM force-fitting them into a single binary would
just increase confusion and difficulty of use.

regards, tom lane

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


Re: [PATCHES] script binaries renaming

2007-07-07 Thread Tom Lane
Zdenek Kotala <[EMAIL PROTECTED]> writes:
> Dave Page wrote:
>> This is almost as bad as Magnus agreeing with JD (!), but I agree with
>> Peter :-). After years of typing the current names, changing them does
>> seem somewhat annoying. Worse yet, pg_* is just awkward to type.

> But these utilities are mostly using in scripts -> one type, multi use. 

According to whom?  The ones that are really at issue I think are
createuser/createlang/dropuser/droplang, and those seem mainly intended
for interactive use.  In a script you might as well use psql -c.

The ones that have "db" in the name do not seem to me to need renaming.
While maybe not obviously connected to Postgres, the chance of a
collision with some other project is low.

One that I'd personally vote to remove completely is "ipcclean".
It's always been a crude, incomplete hack anyway, and the reason
no one has bothered to improve it is that there is next to no use
for it anymore.

regards, tom lane

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [PATCHES] script binaries renaming

2007-07-07 Thread Zdenek Kotala

Joshua D. Drake wrote:

Michael Glaesemann wrote:


On Jul 6, 2007, at 5:53 , Dave Page wrote:


On Fri, July 6, 2007 8:51 am, Peter Eisentraut wrote:

Am Mittwoch, 4. Juli 2007 17:04 schrieb Zdenek Kotala:

I attach complete patch which renames following binaries

createdb createlang createuser dropdb droplang dropuser clusterdb
vacuumdb reindexdb


I just want to say I dislike this idea.


This is almost as bad as Magnus agreeing with JD (!), but I agree with
Peter :-). After years of typing the current names, changing them does
seem somewhat annoying. Worse yet, pg_* is just awkward to type.


While the change might be awkward, the names of these binaries really 
should be namespaced in some way. The current just too generic to be 
throwing into a bin/ directory in my opinion.


Of course I realize that I voted for the idea in the first place. I 
voted for it for consistency more than anything but as I think about it, 
it really is clunky and doesn't serve any real purpose.




There is group of people who has different opinion. The main reasons for 
this patch are 1) names could collide with system tools 2) it is 
confusing for lot of users - typically for newbies and me :-) 3) it is 
not consistent with naming convention.


I started to use postgres since version 6.5 and these names of script 
utilities are still confusing for me.


By the way my original idea was create new command "pg_cmd", which 
integrates all in one include missing commands(e.g. createtablespace).



Zdenek

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [PATCHES] script binaries renaming

2007-07-07 Thread Zdenek Kotala

Dave Page wrote:

On Fri, July 6, 2007 8:51 am, Peter Eisentraut wrote:

Am Mittwoch, 4. Juli 2007 17:04 schrieb Zdenek Kotala:

I attach complete patch which renames following binaries

createdb createlang createuser dropdb droplang dropuser clusterdb
vacuumdb reindexdb

I just want to say I dislike this idea.


This is almost as bad as Magnus agreeing with JD (!), but I agree with
Peter :-). After years of typing the current names, changing them does
seem somewhat annoying. Worse yet, pg_* is just awkward to type.


But these utilities are mostly using in scripts -> one type, multi use. 
I think, most users prefer psql for interactive typing.



Zdenek

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [PATCHES] script binaries renaming

2007-07-07 Thread Magnus Hagander
Zdenek Kotala wrote:
>> I'm also not sure we really should install copies on win32. Given how
>> seldom these commands are actually used on windows (most people really
>> use pgadmin to do these things).
> 
> Postmaster does same thing.

Actually, the win32 distribution only ships postgres.exe, not
postmaster.exe.


>> Also, your patch does not touch the msvc buildsystem, which will still
>> be generating files with the old name.
> 
> Hmm. I do not nothing about it :(. I need help there.

Actually, now that I look at it it seems like most of it comes out
automatically from the Makefile parser. We'll just have to test that if
the patch ends up being accepted (as there seems to be some discussion
about that...)

//Magnus

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


Re: [PATCHES] script binaries renaming

2007-07-07 Thread Zdenek Kotala

Magnus Hagander wrote:

Zdenek Kotala wrote:

I attach complete patch which renames following binaries

createdb createlang createuser dropdb droplang dropuser clusterdb
vacuumdb reindexdb

to

pg_createdb pg_createlang pg_createuser pg_dropdb pg_droplang
pg_dropuser pg_clusterdb pg_vacuumdb pg_reindexdb

Symlinks (or copy on win32) are created for backward compatibility.

This renaming was discussed there:

http://archives.postgresql.org/pgsql-hackers/2007-06/msg00145.php

I create also separate unified patch for documentation.


A couple of comments:

Do we actually need to remove and recreate the documentation files?
Can't we keep the source files and just have it generate the man pages
and other references with the outputname pg_xyz?


I used postmaster/postgresql as a pattern for makefile and documentation 
changes.



Should we be installing symlinks or at least a placeholder manpage for
the old commandnames (maybe a single man page for all the old commands
saying "prefix pg_ to get this command") the same way it's done for the
binaries? (my apologies if it already does this, I don't know exactly
how the man pages are generated from the sgml. I just noticed there was
no makefile modified in the docs area)


I'm not guru on documentation building, but there are driver files which 
contains list of files - see reference.sgml and ref/allfiles.sgml.


I copied decription from current pages to new pg_* files. In old files I 
only keep mention that it is obsolete command. See postmaster 
documentation.



I'm also not sure we really should install copies on win32. Given how
seldom these commands are actually used on windows (most people really
use pgadmin to do these things).


Postmaster does same thing.


Also, your patch does not touch the msvc buildsystem, which will still
be generating files with the old name.


Hmm. I do not nothing about it :(. I need help there.


Thank for your comments

Zdenek



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [PATCHES] script binaries renaming

2007-07-06 Thread Michael Glaesemann


On Jul 6, 2007, at 11:28 , Joshua D. Drake wrote:

Why should they be name spaced? I see zero reason why that should  
be the case...


apache_httpd?
gnu_ls?


Personally, I think that the Apache daemon *should* be named apached  
or something along those lines.


Compare with postgres, pg_ctl, pg_dump, or pg_config. Albeit postgres  
is not consistent, they're all easily identifiable with PostgreSQL.  
In my opinion, postgres, pg_ctl, pg_ccmp, and pg_config are better  
names than, say, dbmsd, dbms_ctl, db_dump, and db_config. Also, we  
recently deprecated the use of postmaster (easily confused with mail  
systems) in favor of postgres. Looking at the binaries that are  
installed for 8.2:


clusterdb
createdb
createlang
createuser
dropdb
droplang
dropuser
ecpg
initdb
ipcclean
pg_config
pg_controldata
pg_ctl
pg_dump
pg_dumpall
pg_resetxlog
pg_restore
postgres
postmaster -> postgres
psql
reindexdb
vacuumdb

If these are all dumped into /usr/local/bin (as they sometimes are),  
many of them are not readily identifiable with PostgreSQL. Shouldn't  
they be? Compare with Subversion:

svn
svnadmin
svndumpfileter
svnlook
svnserver
svnsync
svnversion

I find these names much more consistent.

Michael Glaesemann
grzm seespotcode net




---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


Re: [PATCHES] script binaries renaming

2007-07-06 Thread Joshua D. Drake

Michael Glaesemann wrote:


On Jul 6, 2007, at 5:53 , Dave Page wrote:


On Fri, July 6, 2007 8:51 am, Peter Eisentraut wrote:

Am Mittwoch, 4. Juli 2007 17:04 schrieb Zdenek Kotala:

I attach complete patch which renames following binaries

createdb createlang createuser dropdb droplang dropuser clusterdb
vacuumdb reindexdb


I just want to say I dislike this idea.


This is almost as bad as Magnus agreeing with JD (!), but I agree with
Peter :-). After years of typing the current names, changing them does
seem somewhat annoying. Worse yet, pg_* is just awkward to type.


While the change might be awkward, the names of these binaries really 
should be namespaced in some way. The current just too generic to be 
throwing into a bin/ directory in my opinion.


Of course I realize that I voted for the idea in the first place. I 
voted for it for consistency more than anything but as I think about it, 
it really is clunky and doesn't serve any real purpose.



Joshua D. Drake



Michael Glaesemann
grzm seespotcode net



---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org




--

  === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
 http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org


Re: [PATCHES] script binaries renaming

2007-07-06 Thread Joshua D. Drake

Michael Glaesemann wrote:


On Jul 6, 2007, at 5:53 , Dave Page wrote:


On Fri, July 6, 2007 8:51 am, Peter Eisentraut wrote:

Am Mittwoch, 4. Juli 2007 17:04 schrieb Zdenek Kotala:

I attach complete patch which renames following binaries

createdb createlang createuser dropdb droplang dropuser clusterdb
vacuumdb reindexdb


I just want to say I dislike this idea.


This is almost as bad as Magnus agreeing with JD (!), but I agree with
Peter :-). After years of typing the current names, changing them does
seem somewhat annoying. Worse yet, pg_* is just awkward to type.


While the change might be awkward, the names of these binaries really 
should be namespaced in some way. The current just too generic to be 
throwing into a bin/ directory in my opinion.


Why should they be name spaced? I see zero reason why that should be the 
case...


apache_httpd?
gnu_ls?

The only obvious name spaced applications out there are in the G/K world 
of nome and de.


Joshua D. Drake




Michael Glaesemann
grzm seespotcode net



---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org




--

  === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
 http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org


Re: [PATCHES] script binaries renaming

2007-07-06 Thread Michael Glaesemann


On Jul 6, 2007, at 5:53 , Dave Page wrote:


On Fri, July 6, 2007 8:51 am, Peter Eisentraut wrote:

Am Mittwoch, 4. Juli 2007 17:04 schrieb Zdenek Kotala:

I attach complete patch which renames following binaries

createdb createlang createuser dropdb droplang dropuser clusterdb
vacuumdb reindexdb


I just want to say I dislike this idea.


This is almost as bad as Magnus agreeing with JD (!), but I agree with
Peter :-). After years of typing the current names, changing them does
seem somewhat annoying. Worse yet, pg_* is just awkward to type.


While the change might be awkward, the names of these binaries really  
should be namespaced in some way. The current just too generic to be  
throwing into a bin/ directory in my opinion.


Michael Glaesemann
grzm seespotcode net



---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org


Re: [PATCHES] script binaries renaming

2007-07-06 Thread Dave Page
On Fri, July 6, 2007 8:51 am, Peter Eisentraut wrote:
> Am Mittwoch, 4. Juli 2007 17:04 schrieb Zdenek Kotala:
>> I attach complete patch which renames following binaries
>>
>> createdb createlang createuser dropdb droplang dropuser clusterdb
>> vacuumdb reindexdb
>
> I just want to say I dislike this idea.

This is almost as bad as Magnus agreeing with JD (!), but I agree with
Peter :-). After years of typing the current names, changing them does
seem somewhat annoying. Worse yet, pg_* is just awkward to type.


/D

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


Re: [PATCHES] script binaries renaming

2007-07-06 Thread Peter Eisentraut
Am Donnerstag, 5. Juli 2007 06:59 schrieb Magnus Hagander:
> I'm also not sure we really should install copies on win32. Given how
> seldom these commands are actually used on windows

But some people do use them, and they should have the same experience as on 
any other platform.  I don't think disk space is really a concern, is it?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


Re: [PATCHES] script binaries renaming

2007-07-06 Thread Peter Eisentraut
Am Mittwoch, 4. Juli 2007 17:04 schrieb Zdenek Kotala:
> I attach complete patch which renames following binaries
>
> createdb createlang createuser dropdb droplang dropuser clusterdb
> vacuumdb reindexdb

I just want to say I dislike this idea.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


Re: [PATCHES] script binaries renaming

2007-07-05 Thread Magnus Hagander
Zdenek Kotala wrote:
> I attach complete patch which renames following binaries
> 
> createdb createlang createuser dropdb droplang dropuser clusterdb
> vacuumdb reindexdb
> 
> to
> 
> pg_createdb pg_createlang pg_createuser pg_dropdb pg_droplang
> pg_dropuser pg_clusterdb pg_vacuumdb pg_reindexdb
> 
> Symlinks (or copy on win32) are created for backward compatibility.
> 
> This renaming was discussed there:
> 
> http://archives.postgresql.org/pgsql-hackers/2007-06/msg00145.php
> 
> I create also separate unified patch for documentation.

A couple of comments:

Do we actually need to remove and recreate the documentation files?
Can't we keep the source files and just have it generate the man pages
and other references with the outputname pg_xyz?

Should we be installing symlinks or at least a placeholder manpage for
the old commandnames (maybe a single man page for all the old commands
saying "prefix pg_ to get this command") the same way it's done for the
binaries? (my apologies if it already does this, I don't know exactly
how the man pages are generated from the sgml. I just noticed there was
no makefile modified in the docs area)

I'm also not sure we really should install copies on win32. Given how
seldom these commands are actually used on windows (most people really
use pgadmin to do these things).

Also, your patch does not touch the msvc buildsystem, which will still
be generating files with the old name.

//Magnus


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[PATCHES] script binaries renaming

2007-07-04 Thread Zdenek Kotala

I attach complete patch which renames following binaries

createdb createlang createuser dropdb droplang dropuser clusterdb 
vacuumdb reindexdb


to

pg_createdb pg_createlang pg_createuser pg_dropdb pg_droplang 
pg_dropuser pg_clusterdb pg_vacuumdb pg_reindexdb


Symlinks (or copy on win32) are created for backward compatibility.

This renaming was discussed there:

http://archives.postgresql.org/pgsql-hackers/2007-06/msg00145.php

I create also separate unified patch for documentation.

Zdenek


scripts-patch.tar.gz
Description: GNU Zip compressed data

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate