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

From Ferrell, Denise CTR NSWCDD, Z11
Subject Re: Removing a Database Server
Date
Msg-id 2BC18916DE4BF141AC1EFC55CE2CAE7D5804C1@NAEANRFKXM01V.nadsusea.nads.navy.mil
Whole thread Raw
In response to Re: Removing a Database Server  (jayknowsunix@gmail.com)
Responses Re: Removing a Database Server
List pgsql-admin
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.

Attachment

pgsql-admin by date:

Previous
From: Raj Gandhi
Date:
Subject: Re: format() function with string_agg
Next
From: jayknowsunix@gmail.com
Date:
Subject: Re: Removing a Database Server