Ask Your Question

Is it possible to install database schema with puppet?

asked 2014-06-01 15:56:32 -0600

jaksky gravatar image

updated 2014-06-01 15:59:16 -0600

Is it possible to install a database schema with puppet? I am facing a following scenario - to install a webapplication:

  1. install an application server-s

  2. deploy an application

  3. install a database (database server)
  4. create a db user
  5. create a db schema for a application item

Points one to three there is no problem at all but I am wondering about step 4 and 5? What is the common practice in following situations? Is there some plugin/resource which take advantage of dedicated tool like liquibase or ...

I will appreciate any hints or experiences Thanks

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

answered 2014-06-02 10:17:19 -0600

ethrbunny gravatar image

I can only speak for mysql but I've used puppet to read in a schema definition from a text file. This works fine and creates accounts, populates data, and so on.

edit flag offensive delete link more

answered 2014-06-02 16:00:53 -0600

it's also possible with the puppetlabs-postgres module.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower


Asked: 2014-06-01 15:56:32 -0600

Seen: 592 times

Last updated: Jun 02 '14