Spring postgresql cannot connect to local database

Question

I'm trying to test my Spring DAO level but cannot connect to my local database. Here is the Configuration.

Yes, I use port 54321 instead of standard port 5432:

@Bean
public DataSource dataSource(){
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setPassword("password");
    dataSource.setUsername("postgres");
    dataSource.setUrl("jdbc:postgresql://localhost:53421/mydbtest");
    dataSource.setDriverClassName("org.postgresql.Driver");

    return dataSource;
}

@Bean 
public JdbcTemplate jdbcTemplate(){
    JdbcTemplate template = new JdbcTemplate();
    template.setDataSource(dataSource());

    return template;
}

@Bean
public DataSourceInitializer dataSourceInitializer(DataSource dataSource)
{
    DataSourceInitializer dataSourceInitializer = new DataSourceInitializer();    
    dataSourceInitializer.setDataSource(dataSource);        
    dataSourceInitializer.setEnabled(true);
     ResourceDatabasePopulator databasePopulator = new ResourceDatabasePopulator();
    databasePopulator.addScript(new ClassPathResource("src/resource/sql/01_init_database.sql"));
    dataSourceInitializer.setDatabasePopulator(databasePopulator);
    return dataSourceInitializer;
}

I switched the firewall off, tried different versions of postgresql driver. But I stilll get this exception. And he also writes me to check my user-password-port data, but I'm sure they are correct:

Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)

What could be also wrong?

I use postgresql 9.2

UPDATE

I am on Windows if it matters

Here is the line for pg_hba.conf

host    all             all                 0.0.0.0/0           trust

(I also tried md5)

Here a Snippet form postgres.conf

listen_addresses = '*'      # what IP address(es) to listen on;
                # comma-separated list of addresses;
                # defaults to 'localhost'; use '*' for all
                # (change requires restart)
port = 54321                # (change requires restart)
max_connections = 100           # (change requires restart)

Is Postgres really running? Can you connect using psql or another SQL client? Does localhost actually resolve to an IP address? (does ping localhost work?) What is the value of listen_address in postgresql.conf — user330315
– user330315, Commented Feb 5, 2017 at 11:25
localhost is pinged. the value in postgresconf is listen_addresses = '*' — user2957954
– user2957954, Commented Feb 5, 2017 at 11:36

jnemecz · Accepted Answer · 2017-02-05 11:57:37Z

2

Try to connect to PostgreSQL server on localhost:

psql -h localhost -p 53421

Are you able to connect? If not, what is an error?

Edit your PostgreSQL configuration:

pg_hba.conf

host all all 0.0.0.0/0 md5

postgresql.conf

    listen_addresses='*'
port = 53421

and restart server.

(it's not connected to Spring, it's rather PostgreSQL configuration issue)

edited Feb 5, 2017 at 11:57

answered Feb 5, 2017 at 11:34

jnemecz

3,6769 gold badges50 silver badges89 bronze badges

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

7 Comments

user2957954 Over a year ago

you are right: I cannot connect to locanhost from postgres. but pgAdmin cannot connect

jnemecz Over a year ago

What's the error message? "psql: could not connect to server: Connection refused" ?

user2957954 Over a year ago

I added this line and as far as i understand a restarted the server (with a command pg_clt start -D data). But I receive a message from restarting the cannot fins a configuration file and from psql still connection refused

jnemecz Over a year ago

Switch -D means data directory, you have to place there a system path to PostgreSQL data directory (and probably "data" is not correct directory, is it?).

user2957954 Over a year ago

It was a right directora. It finds now a file, but still cannot connect. I added an edit to the main post to show my conf files

|

Collectives™ on Stack Overflow

Spring postgresql cannot connect to local database

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related