configure.swift

var databases = DatabasesConfig()
let databaseConfig: PostgreSQLDatabaseConfig
if let url = Environment.get("DB_POSTGRESQL") {
    databaseConfig = try PostgreSQLDatabaseConfig(url: url)
} else {
    // Local configuration
    let hostname = "localhost"
    let username = "vapor"
    let password = "password"
    let database = "vapor"

    databaseConfig = PostgreSQLDatabaseConfig(
        hostname: hostname, 
        username: username, 
        database: database, 
        password: password
    )
}
let database = PostgreSQLDatabase(config: databaseConfig)
databases.add(database: database, as: .psql)
services.register(databases)