Обсуждение: Removing a Database Server
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.
Вложения
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.
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.
Вложения
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.