Re: Removing a Database Server

From: jayknowsunix(at)gmail(dot)com
To: "Ferrell, Denise CTR NSWCDD, Z11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Removing a Database Server
Date: 2014-09-24 14:17:39
Message-ID: B62DF581-C321-4F70-AB3E-1E359767E12B@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Try "rm -fr" for what you're trying to remove. I'm guessing you need "rm -fr /var/lib/pgsql/black"

Sent from my iPad

> On Sep 24, 2014, at 10:08 AM, "Ferrell, Denise CTR NSWCDD, Z11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil> wrote:
>
> This is not working. The problem stems from my SA creating the a database server prior...I'm guessing.
>
> I'm having issues with the rm command...getting "Is a directory"
>
> Process I used...
>
> initdb -D /var/lib/pgsql/black
> The files belonging to this database system will be owned by user 'postgres'.
> This user must also own the server process.
>
> The database cluster will be initialized with locale en_US.UTF-8.
> The default database encoding....
> The default text search.....
>
> Creating directory /var/lib/pgsql/black . . . ok
> Creating subdirectories . . . ok
> ...
>
>
> Success. You can now start the database server using:
>
> Postgres -D /var/lib/pgsql/black
> Or
> Pg_ctl -D /var/lib/pgsql/black -l logfile start (which I used)
>
> Thank you in advance.
>
> -----Original Message-----
> From: jayknowsunix(at)gmail(dot)com [mailto:jayknowsunix(at)gmail(dot)com]
> Sent: Monday, September 22, 2014 3:37 PM
> To: Ferrell, Denise CTR NSWCDD, Z11
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] Removing a Database Server
>
> service postgresql-9.3 stop
> rm /var/lib/pgsql/9.3/data
>
> Unless, of course, you built the database in some other location. That would get rid of it completely.
>
> Sent from my iPad
>
>> On Sep 22, 2014, at 2:59 PM, "Ferrell, Denise CTR NSWCDD, Z11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil> wrote:
>>
>> Using Linux Red-Hat & PostgreSQL v9.3.4
>>
>> What would be the easiest way to remove a Database Server that shouldn't have been created?
>>
>> Thank you in advance for any assistance.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stefan Carl 2014-09-24 14:45:53 readonly user
Previous Message Ferrell, Denise CTR NSWCDD, Z11 2014-09-24 14:08:54 Re: Removing a Database Server