Re: Removing a Database Server

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.