create_postgres_db.py 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. #!/usr/bin/env python
  2. # -*- coding: utf-8 -*-
  3. # Copyright 2019 The Matrix.org Foundation C.I.C.
  4. #
  5. # Licensed under the Apache License, Version 2.0 (the "License");
  6. # you may not use this file except in compliance with the License.
  7. # You may obtain a copy of the License at
  8. #
  9. # http://www.apache.org/licenses/LICENSE-2.0
  10. #
  11. # Unless required by applicable law or agreed to in writing, software
  12. # distributed under the License is distributed on an "AS IS" BASIS,
  13. # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  14. # See the License for the specific language governing permissions and
  15. # limitations under the License.
  16. import logging
  17. from synapse.storage.engines import create_engine
  18. logger = logging.getLogger("create_postgres_db")
  19. if __name__ == "__main__":
  20. # Create a PostgresEngine.
  21. db_engine = create_engine({"name": "psycopg2", "args": {}})
  22. # Connect to postgres to create the base database.
  23. # We use "postgres" as a database because it's bound to exist and the "synapse" one
  24. # doesn't exist yet.
  25. db_conn = db_engine.module.connect(
  26. user="postgres", host="postgres", password="postgres", dbname="postgres"
  27. )
  28. db_conn.autocommit = True
  29. cur = db_conn.cursor()
  30. cur.execute("CREATE DATABASE synapse;")
  31. cur.close()
  32. db_conn.close()