Re: [Postgres-xc-general] "Dropdb/Dropuser command not found" problem

[Ashutosh B. <ash...@en...>]

Hector,
AFAIK, pgxc_ctl is not an interface for dropping database or user. It's
just a cluster management utility. You should use corresponding binaries or
SQL commands for that purpose.


On Tue, Oct 8, 2013 at 9:32 PM, Hector M. Jacas <hec...@et...>wrote:

>
> Hi all,
>
> Among the features described in: https://github.com/koichi-szk/**
> PGXC-Tools/blob/master/pgxc_**ctl/manual.txt<https://github.com/koichi-szk/PGXC-Tools/blob/master/pgxc_ctl/manual.txt>is deleting the databases (Dropdb) and users (Dropuser) and when I try make
> use of these commands pgxc_ctl answers: command not found
>
> PGXC Createdb testdb
> Selected coord2.
> PGXC Dropdb testdb
> sh: Dropdb: command not found
> PGXC Createuser usertest1
> Selected coord1.
> PGXC Dropuser usertest1
> sh: Dropuser: command not found
> PGXC
>
> Carefully review the source code and found that in the folder:
> postgres-xc/contrib/pgxc_ctl , there is a file (do_command.c) in which
> reference is made and performed the execution of Createdb (line 2339) and
> Createuser (line 2369).
>
> In this file there is no reference whatsoever to Dropdb or Dropuser .
>
> There is another file (in the same directory) called: pgxc_ctl.bash, in
> which reference is made and run the corresponding command to Createdb,
> Dropdb, Createuser and Dropuser.
>
> Do not remember reading during pgxc compliacion and deployment (or
> pgxc_ctl in the area of contributions ) anything regarding how to handle
> this situation.
>
> How to resolve this issue?
>
> The pgxc_ctl in its binary version lacks Dropdb and Dropuser commands?
> I must choose between the binary version and the version bash? What would
> be the impact of this change ?
>
> Can anyone guide me please
>
> Thanks in advance,
>
> Hector M. Jacas
>
> ---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE
> running at host imx3.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>


-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company