Re: Drop Cluster

Поиск
Список
Период
Сортировка
От Roderick A. Anderson
Тема Re: Drop Cluster
Дата
Msg-id 4A745427.2060805@cyber-office.net
обсуждение исходный текст
Ответ на Re: Drop Cluster  (sweta@opspl.com)
Список pgsql-general
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
--


В списке pgsql-general по дате отправления:

Предыдущее
От: John
Дата:
Сообщение: Re: MSSQL to PostgreSQL
Следующее
От: Denis BUCHER
Дата:
Сообщение: How to execute external script from a TRIGGER or FUNCTION ?