# Postgres error

## post by Andrew_Meyer on Jul 21, 2025

Andrew Meyer

I recently rebuilt my Nexus Repo Manager server for my home lab. I’m running this on CentOS 9 w/ the latest nexus.

I’m trying to migrate from H2 to PostgreSQL 17.

I’m currently getting this in the logs

```auto
Caused by: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in
  Position: 28
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:180)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:75)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at org.sonatype.nexus.datastore.mybatis.EntityExecutor.update(EntityExecutor.java:74)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
	at org.sonatype.nexus.datastore.mybatis.DataAccessSqlSession.update(DataAccessSqlSession.java:83)
	... 62 common frames omitted
```

Here is the contents of my nexus-store.properties

```ini
password=$PASSWORD
jdbcUrl=jdbc\:postgresql\://$IP.AD.DR.ESS\:5432/sonatype?tcpKeepAlive\=true&advanced\=maximumPoolSize\=200&maxLifetime\=840000&currentSchema\=sonatype
maximumPoolSize=200
maxLifetime=840000
username=$USERNAME
```

[nexus_log_errors.zip](https://community.sonatype.com/uploads/short-url/8XBBLqoTPlPWlaOeYqz63nj6HRJ.zip) (34.7 KB)

Here is more of the errors.

## post by William_Leo on Jul 25, 2025

William Leo

Your JDBC URL has a misplaced parameter. Move `currentSchema=sonatype` **before** others like this:

```ini
jdbcUrl=jdbc:postgresql://$IP.AD.DR.ESS:5432/sonatype?currentSchema=sonatype&tcpKeepAlive=true
```

Also ensure the `sonatype` schema exists and your user has access to it.