Error connecting to database

[jsooter]

Using version 4.0, when I try to connect to the database I get thefollowing error
SQLSTATE[08006] [7] could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

This is how I'm setting up the connection

$container->set('session', function() use ($config){
    // Create a connection
    $connection = new \Phalcon\Db\Adapter\Pdo\Postgresql((array)$config->session_db); // <-- error is here

    $session = New \Phalcon\Session\Adapter\SessionDatabase($connection,'session_data');

    $session->start();
    return $session;
});

The config looks like this

    'session_db' => array(
        'host'     => 'db',
        'username' => 'xxxxx',
        'password' => 'xxxxx',
        'dbname'   => 'session',
        'schema'   => 'public'
    ),

The database is running in another Docker container called db. It looks like Phalcon expects a local socket connection for some reason.

Anyone know why it's looking for a local socket connection?

[quasipickle]

My guess is it's looking for a socket because you haven't specified a hostname. I'm not too familiar with Docker, but I don't think specifying db is sufficient.

Maybe try specifying localhost and the correct port.

[jsooter]

Thanks @quasipickle. I finally figured out the issue. For some reason the config array was loading as a string.