create a schema in postgres while spring boot starts

Question

I need to create a new schema in Postgres when the spring boot loads. So, it should check if the schema doesn't exist then create a new schema. I am using application.properties for database configuration.

spring.datasource.platform=postgres
spring.datasource.url=jdbc:postgresql://${vcap.services.postgresql-lite.credentials.hostname}:${vcap.services.postgresql-lite.credentials.port}/${vcap.services.postgresql-lite.credentials.dbname}
spring.datasource.username=${vcap.services.postgresql-lite.credentials.username}
spring.datasource.password=${vcap.services.postgresql-lite.credentials.password}
spring.jpa.properties.hibernate.default_schema=${DATABASE_SCHEMA}
spring.jpa.hibernate.ddl-auto=update
spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect

The default schema that Postgres uses is public, I need to change that make my own schema, which I'll define in env.

mukut bhattacharjee · Accepted Answer · 2018-11-02 09:32:22Z

2

Use the following your application.properties file:

spring.datasource.initialize=true
spring.datasource.schema=${DB_SCHEMA}

In your schema file add the following:

CREATE TABLE IF NOT EXISTS...

answered Nov 2, 2018 at 9:32

mukut bhattacharjee

3111 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

abj1305 · Accepted Answer · 2018-11-02 09:29:42Z

1

You can have a schema-postgresql.sql file placed in src/main/resources with content: as follows:

CREATE SCHEMA IF NOT EXISTS ;

answered Nov 2, 2018 at 9:29

abj1305

66510 silver badges25 bronze badges

10 Comments

nirvair Over a year ago

Do I need to add anything in application.properties?

abj1305 Over a year ago

You have all the things covered in your application.properties it seems. You can refer this link as I have tested it and is working. Make sure your postgres version is later to 9.1

nirvair Over a year ago

I get an error saying: Relation schema_name doesn't exist.

abj1305 Over a year ago

Can you paste your stacktrace ??

abj1305 Over a year ago

I guess your postgres version is older

|

Collectives™ on Stack Overflow

create a schema in postgres while spring boot starts

2 Answers 2

Comments

10 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

10 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related