Recreating uaadb and ccdb databases


R M
 

Hello, is there a way of recreating uaadb and ccdb databases? I had
corrupted my CF install and in the process deleted both of these
databases. I wonder if there are some scripts that I can run to recreate
these databases.

Thanks.


Amit Kumar Gupta
 

Hi Rishi,

Are you trying to recover the data or just recreate the ccdb and uaadb
(starting from scratch with the data)? If you're willing to start with
scratch with respect to the data, it may be simplest to delete your
deployment and redeploy. If you don't want to start from scratch, then you
must have your data backed up somewhere on a persistent volume. Can you say
more about your deployment and how you configured the persistence aspect of
ccdb and uaadb?

Best,
Amit



-----
Amit, CF OSS Release Integration PM
Pivotal Software, Inc.
--
View this message in context: http://cf-dev.70369.x6.nabble.com/cf-dev-Recreating-uaadb-and-ccdb-databases-tp1007p1010.html
Sent from the CF Dev mailing list archive at Nabble.com.


R M
 

Hi Amit - since this is a fresh install I an just trying to recreate ccdb and
uaadb from scratch. What is the best way of deleting/redeploying my
environment? Note that due to I am only able to use cf_nise installer for
this deployment. This is another reason I wanted to just recreate dbs if
possible.

Thanks.



--
View this message in context: http://cf-dev.70369.x6.nabble.com/cf-dev-Recreating-uaadb-and-ccdb-databases-tp1007p1011.html
Sent from the CF Dev mailing list archive at Nabble.com.


CF Runtime
 

If you are using the default postgres job, you should just be able to "bosh
restart postgres_z1/0". This will create both the databases, but they will
not have the schemas.

The individual jobs should recreate the schemas, so you'll probably need to
"bosh restart api_z1/0" and "bosh restart uaa_z1/0".

Joseph
OSS Release Integration Team

On Sat, Aug 1, 2015 at 3:36 AM, rmi <rishi.investigate(a)gmail.com> wrote:

Hi Amit - since this is a fresh install I an just trying to recreate ccdb
and
uaadb from scratch. What is the best way of deleting/redeploying my
environment? Note that due to I am only able to use cf_nise installer for
this deployment. This is another reason I wanted to just recreate dbs if
possible.

Thanks.



--
View this message in context:
http://cf-dev.70369.x6.nabble.com/cf-dev-Recreating-uaadb-and-ccdb-databases-tp1007p1011.html
Sent from the CF Dev mailing list archive at Nabble.com.
_______________________________________________
cf-dev mailing list
cf-dev(a)lists.cloudfoundry.org
https://lists.cloudfoundry.org/mailman/listinfo/cf-dev


James Bayer
 

joseph, did you mean "bosh recreate" instead of "bosh restart"?

On Sat, Aug 1, 2015 at 5:28 AM, CF Runtime <cfruntime(a)gmail.com> wrote:

If you are using the default postgres job, you should just be able to
"bosh restart postgres_z1/0". This will create both the databases, but they
will not have the schemas.

The individual jobs should recreate the schemas, so you'll probably need
to "bosh restart api_z1/0" and "bosh restart uaa_z1/0".

Joseph
OSS Release Integration Team

On Sat, Aug 1, 2015 at 3:36 AM, rmi <rishi.investigate(a)gmail.com> wrote:

Hi Amit - since this is a fresh install I an just trying to recreate ccdb
and
uaadb from scratch. What is the best way of deleting/redeploying my
environment? Note that due to I am only able to use cf_nise installer for
this deployment. This is another reason I wanted to just recreate dbs if
possible.

Thanks.



--
View this message in context:
http://cf-dev.70369.x6.nabble.com/cf-dev-Recreating-uaadb-and-ccdb-databases-tp1007p1011.html
Sent from the CF Dev mailing list archive at Nabble.com.
_______________________________________________
cf-dev mailing list
cf-dev(a)lists.cloudfoundry.org
https://lists.cloudfoundry.org/mailman/listinfo/cf-dev

_______________________________________________
cf-dev mailing list
cf-dev(a)lists.cloudfoundry.org
https://lists.cloudfoundry.org/mailman/listinfo/cf-dev

--
Thank you,

James Bayer


CF Runtime
 

No, there are no special scripts that run on job instance creation,
everything is embedded in the startup control scripts. So while recreate
would work too, restart should be fine.

Joseph
OSS Release Integration Team

On Sat, Aug 1, 2015 at 5:31 AM, James Bayer <jbayer(a)pivotal.io> wrote:

joseph, did you mean "bosh recreate" instead of "bosh restart"?

On Sat, Aug 1, 2015 at 5:28 AM, CF Runtime <cfruntime(a)gmail.com> wrote:

If you are using the default postgres job, you should just be able to
"bosh restart postgres_z1/0". This will create both the databases, but they
will not have the schemas.

The individual jobs should recreate the schemas, so you'll probably need
to "bosh restart api_z1/0" and "bosh restart uaa_z1/0".

Joseph
OSS Release Integration Team

On Sat, Aug 1, 2015 at 3:36 AM, rmi <rishi.investigate(a)gmail.com> wrote:

Hi Amit - since this is a fresh install I an just trying to recreate
ccdb and
uaadb from scratch. What is the best way of deleting/redeploying my
environment? Note that due to I am only able to use cf_nise installer
for
this deployment. This is another reason I wanted to just recreate dbs if
possible.

Thanks.



--
View this message in context:
http://cf-dev.70369.x6.nabble.com/cf-dev-Recreating-uaadb-and-ccdb-databases-tp1007p1011.html
Sent from the CF Dev mailing list archive at Nabble.com.
_______________________________________________
cf-dev mailing list
cf-dev(a)lists.cloudfoundry.org
https://lists.cloudfoundry.org/mailman/listinfo/cf-dev

_______________________________________________
cf-dev mailing list
cf-dev(a)lists.cloudfoundry.org
https://lists.cloudfoundry.org/mailman/listinfo/cf-dev


--
Thank you,

James Bayer

_______________________________________________
cf-dev mailing list
cf-dev(a)lists.cloudfoundry.org
https://lists.cloudfoundry.org/mailman/listinfo/cf-dev