Re: Removing a Database Server - Mailing list pgsql-admin

From jayknowsunix@gmail.com
Subject Re: Removing a Database Server
Date
Msg-id B62DF581-C321-4F70-AB3E-1E359767E12B@gmail.com
Whole thread Raw
In response to Re: Removing a Database Server  ("Ferrell, Denise CTR NSWCDD, Z11" <denise.ferrell.ctr@navy.mil>)
List 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.ferrell.ctr@navy.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@gmail.com [mailto:jayknowsunix@gmail.com]
> Sent: Monday, September 22, 2014 3:37 PM
> To: Ferrell, Denise CTR NSWCDD, Z11
> Cc: pgsql-admin@postgresql.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.ferrell.ctr@navy.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.


pgsql-admin by date:

Previous
From: "Ferrell, Denise CTR NSWCDD, Z11"
Date:
Subject: Re: Removing a Database Server
Next
From: "Stefan Carl"
Date:
Subject: readonly user