[chef] Re: Chef11 HA

[Seth Falcon < >]

On Feb 11, 2013, at 1:29 PM, Vaidas Jablonskis wrote:

> This might be slightly unrelated to this conversion, but what I wonder what 
> is stored in postgres database?

All of the Chef object data is stored in the db. You can explore the schema a 
bit like this:


 :~#
 su - opscode-pgsql
$ bash    

 :~$
 which psql
/opt/chef-server/embedded/bin/psql

 :~$
 psql opscode_chef
psql (9.2.1)
Type "help" for help.

opscode_chef=# \d
                         List of relations
 Schema |             Name              |   Type   |     Owner     
--------+-------------------------------+----------+---------------
 public | checksums                     | table    | opscode-pgsql
 public | clients                       | table    | opscode-pgsql
 public | cookbook_version_checksums    | table    | opscode-pgsql
 public | cookbook_version_dependencies | view     | opscode-pgsql
 public | cookbook_versions             | table    | opscode-pgsql
 public | cookbook_versions_by_rank     | view     | opscode-pgsql
 public | cookbooks                     | table    | opscode-pgsql
 public | cookbooks_id_seq              | sequence | opscode-pgsql
 public | data_bag_items                | table    | opscode-pgsql
 public | data_bags                     | table    | opscode-pgsql
 public | environments                  | table    | opscode-pgsql
 public | joined_cookbook_version       | view     | opscode-pgsql
 public | nodes                         | table    | opscode-pgsql
 public | osc_users                     | table    | opscode-pgsql
 public | roles                         | table    | opscode-pgsql
 public | sandboxed_checksums           | table    | opscode-pgsql
 public | schema_info                   | table    | opscode-pgsql
(17 rows)

And find the script used to initialize the schema here:
https://github.com/opscode/chef_db/blob/master/priv/pgsql_schema.sql

> What happens when this database gets corrupted or data is lost, for 
> instance?

Bad things happen. If the db data is lost or corrupted, so is your Chef 
Server.

+ seth