Skip site navigation (1) Skip section navigation (2)

Re: Script binaries renaming

From: Zdeněk Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Script binaries renaming
Date: 2008-03-26 12:38:41
Message-ID: 47EA43D1.1040405@sun.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Magnus Hagander napsal(a):
> On Wed, 2008-03-26 at 13:21 +0100, Zdeněk Kotala wrote:
>> Magnus Hagander napsal(a):
>>> On Tue, 2008-03-25 at 21:59 -0400, Tom Lane wrote:
>> <snip>
>>
>>>> Are we really prepared to break everyone's scripts for this?
>>> I wonder how many people actually use those commands :-) I know I always
>>> use psql with a commandline parameter, and the majority of other peoples
>>> scripts that I've come across also do that. So I'm not sure exactly how
>>> important it is.
>>>
>>> Another option then might be to simply deprecate their use, and
>>> eventually get rid of them, instead of renaming them?
>> In one of my mail I also mentioned to replace all of these commands by one (e.g. 
>> pg_cmd) which will integrate all of them.  Removing is not good solution for 
>> people who writes scripts, because process psql output is complicated and there 
>> is not easy way how to run vacuum on all databases for example.
> 
> You can add lots of nice parameters to psql to make it quite easy to
> process the output. Running vacuum on all databases isn't particularly
> hard - but it does require a small bit of shell-fu.

Yes, it needs extra lines in shell script and probably most of use cases are 
possible do by psql command. Maybe removing will be better solution.

  > But I'll grant you that one for vacuumdb. I was specifically thinking
> about the create/drop user/db/lang scripts, which are the ones likely to
> "conflict" with other parts of the system. Didn't think of vacuumdb.

I see. I think that autovacuum stops usage of vacuumdb command anyway.

		Zdenek

In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2008-03-26 12:48:45
Subject: Re: Script binaries renaming
Previous:From: Alvaro HerreraDate: 2008-03-26 12:31:15
Subject: Re: Auto Partitioning Patch - WIP version 1

pgsql-patches by date

Next:From: Magnus HaganderDate: 2008-03-26 12:45:37
Subject: \password in psql help
Previous:From: Alvaro HerreraDate: 2008-03-26 12:31:15
Subject: Re: Auto Partitioning Patch - WIP version 1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group