pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRemoving a Database Server
4+ messages / 2 participants
[nested] [flat]
* Removing a Database Server
@ 2014-09-22 18:59 Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
0 siblings, 1 reply; 4+ messages in thread
From: Ferrell, Denise CTR NSWCDD, Z11 @ 2014-09-22 18:59 UTC (permalink / raw)
To: pgsql-admin
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.
Attachments:
smime.p7s (application/pkcs7-signature, 5.5K) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Removing a Database Server
@ 2014-09-22 19:37 jayknowsunix@gmail.com
parent: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
0 siblings, 1 reply; 4+ messages in thread
From: jayknowsunix@gmail.com @ 2014-09-22 19:37 UTC (permalink / raw)
To: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>; +Cc: pgsql-admin
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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Removing a Database Server
@ 2014-09-24 14:08 Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
parent: jayknowsunix@gmail.com
0 siblings, 1 reply; 4+ messages in thread
From: Ferrell, Denise CTR NSWCDD, Z11 @ 2014-09-24 14:08 UTC (permalink / raw)
To: jayknowsunix@gmail.com <jayknowsunix@gmail.com>; +Cc: 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.
Attachments:
smime.p7s (application/pkcs7-signature, 5.5K) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Removing a Database Server
@ 2014-09-24 14:17 jayknowsunix@gmail.com
parent: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
0 siblings, 0 replies; 4+ messages in thread
From: jayknowsunix@gmail.com @ 2014-09-24 14:17 UTC (permalink / raw)
To: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>; +Cc: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2014-09-24 14:17 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-09-22 18:59 Removing a Database Server Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
2014-09-22 19:37 ` jayknowsunix@gmail.com
2014-09-24 14:08 ` Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
2014-09-24 14:17 ` jayknowsunix@gmail.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox