Обсуждение: Drop Cluster

Hi,

Is there any command to drop a postgres cluster???

I tried the following link
http://www.digipedia.pl/man/pg_dropcluster.8.html

but it says command not found.
Is there any other way??

Any help will be highly appreciated.

Thanks in advance.

Regards,
Sweta.

sweta@opspl.com wrote:
> Hi,
>
> Is there any command to drop a postgres cluster???
>
> I tried the following link
> http://www.digipedia.pl/man/pg_dropcluster.8.html
>
> but it says command not found.
> Is there any other way??
>
> Any help will be highly appreciated.
>


I believe that command is specific to the debian/ubuntu distributions.

in generic postgres, you'd simply stop the server, then delete the
contents of the $PGDATA directory

Hi,

> I believe that command is specific to the debian/ubuntu distributions.
>
> in generic postgres, you'd simply stop the server, then delete the
> contents of the $PGDATA directory

I am using CentOS 5  and postgrest 8.1.11 .  Could not find the PGDATA
directory. :(

Will deleting the contents from the directory remove "Cluster already exists"
error???

Thanks and Regards,
Sweta.

sweta@opspl.com wrote:
>
> Hi,
>
>> I believe that command is specific to the debian/ubuntu distributions.
>>
>> in generic postgres, you'd simply stop the server, then delete the
>> contents of the $PGDATA directory
>
> I am using CentOS 5  and postgrest 8.1.11 .  Could not find the PGDATA
> directory. :(

On my CentOS 5 systems using the PGDG, and the stock CentOS I found it
(but already knew where) based on the following.

[root@db3 ~]# su - postgres
-bash-3.2$ echo $PGDATA
/var/lib/pgsql/data
-bash-3.2$
>
> Will deleting the contents from the directory remove "Cluster already exists"
> error???

You will probably have to re-init_db to have a working PostgreSQL
database system.

> Thanks and Regards,
> Sweta.


\\||/
Rod
--

sweta@opspl.com wrote:
>> I believe that command is specific to the debian/ubuntu distributions.
>>
>> in generic postgres, you'd simply stop the server, then delete the
>> contents of the $PGDATA directory
>>
>
> I cleared the PGDATA directory like this -->
>
> PGDATA=""
> export PGDATA
>

that just sets the environment variable to an empty string.

you need to stop your postgres server if its already running, then

    rm -rf /var/lib/pgsql/data/*

then you can do a new initdb.... assuming thats what you're trying to
do.  I have no idea what replconfig.cnf is.