{"_id":"56ce135449abf10b0036a3a9","parentDoc":null,"user":"55282916d9e1db2d00cd923c","version":{"_id":"552829408962f339009a6790","project":"552829408962f339009a678d","__v":26,"createdAt":"2015-04-10T19:49:20.516Z","releaseDate":"2015-04-10T19:49:20.516Z","categories":["552829418962f339009a6791","55284ed68962f339009a67e1","55286c73391a362500d9b3f4","552918f6b316811900149f59","5529b255d739240d00a3483e","553287590a578a0d008d4ff5","55329385e7d1fa0d003fc946","5550b55200420e0d00d1312f","55525fca953c9c0d00f507d7","559199695631432f002d358a","559d8d96980b801700d5ec7e","55c5e833cccdeb2d004e24b9","55d76504f662951900fc0e7d","55ea213cc62aa02f008229cd","56157b750f5ed00d00483dd8","561981fbac0924170069f4e8","561b8b1ea430930d0037ea67","563417428b86331700b488ca","56cd785bface161300dae0ec","56cdcc6e70db8a15006395f4","56cdf1b749abf10b0036a34a","56cedc8ce50c9c1b00830423","56e97ba8d825061900d1ac83","570d505228e6900e00477229","573614ca2ab52e1700c8e851","57d556a2496a3117004d70cf"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"__v":13,"project":"552829408962f339009a678d","category":{"_id":"56cedc8ce50c9c1b00830423","__v":1,"pages":["56d763c2693ef41d0003abec"],"project":"552829408962f339009a678d","version":"552829408962f339009a6790","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-02-25T10:50:52.142Z","from_sync":false,"order":8,"slug":"server-configuration","title":"Server Configuration"},"updates":["578737a39832f20e00dd5fbf"],"next":{"pages":[],"description":""},"createdAt":"2016-02-24T20:32:20.890Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":1,"body":"After installation you need to create a database and user with superuser privileges:\n[block:code]\n{\n  \"codes\": [\n    {\n      \"code\": \"sudo -u postgres createuser --superuser <user>\\nsudo -u postgres psql postgres --command '\\\\password <user>'\\nsudo -u postgres createdb <dbname> -O <user>\",\n      \"language\": \"shell\"\n    }\n  ]\n}\n[/block]\nAfter creation of database and user put configuration to your `server.conf` file:\n[block:code]\n{\n  \"codes\": [\n    {\n      \"code\": \"services {\\n\\n  # PostgreSQL storage for data\\n  # The only required service to start server\\n  postgresql {\\n    # Host of PostgreSQL instance\\n    host: <write_psql_server_host_here>\\n    # Port of PostgreSQL instance\\n    port: 5432\\n    # Database name\\n    db: actor\\n    # User name in PostgreSQL\\n    user: <write_psql_user_here>\\n    # Password in PostgreSQL\\n    password: <write_psql_password_here>\\n  }\\n}\",\n      \"language\": \"text\",\n      \"name\": \"application.conf\"\n    }\n  ]\n}\n[/block]","excerpt":"Configure postgres database","slug":"configure-database","type":"basic","title":"Database confguration"}

Database confguration

Configure postgres database

After installation you need to create a database and user with superuser privileges: [block:code] { "codes": [ { "code": "sudo -u postgres createuser --superuser <user>\nsudo -u postgres psql postgres --command '\\password <user>'\nsudo -u postgres createdb <dbname> -O <user>", "language": "shell" } ] } [/block] After creation of database and user put configuration to your `server.conf` file: [block:code] { "codes": [ { "code": "services {\n\n # PostgreSQL storage for data\n # The only required service to start server\n postgresql {\n # Host of PostgreSQL instance\n host: <write_psql_server_host_here>\n # Port of PostgreSQL instance\n port: 5432\n # Database name\n db: actor\n # User name in PostgreSQL\n user: <write_psql_user_here>\n # Password in PostgreSQL\n password: <write_psql_password_here>\n }\n}", "language": "text", "name": "application.conf" } ] } [/block]