# Can not start logstash with jdbc to postgresql9.5.5,except an error"role 'greg' does not exist"

**URL:** <https://discuss.elastic.co/t/can-not-start-logstash-with-jdbc-to-postgresql9-5-5-except-an-error-role-greg-does-not-exist/74623>\
**Category:** Logstash\
**Created:** [February 10, 2017, 9:11am UTC](https://discuss.elastic.co/t/can-not-start-logstash-with-jdbc-to-postgresql9-5-5-except-an-error-role-greg-does-not-exist/74623 "2017-02-10T09:11:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Wynter\_Greg](https://avatars.discourse-cdn.com/v4/letter/w/6bbea6/32.png) [@Wynter\_Greg](https://discuss.elastic.co/u/Wynter_Greg)\
**Post date:** [February 10, 2017, 9:11am UTC](https://discuss.elastic.co/t/can-not-start-logstash-with-jdbc-to-postgresql9-5-5-except-an-error-role-greg-does-not-exist/74623/1 "2017-02-10T09:11:36Z")

</div>

This is the first time I use logstash.I installed logstash5.2.0 by downloading logstash-5.2.0.tar.gz.  
The input is:

```auto
input {
  jdbc {
    jdbc_driver_library => "jdbc-drivers/postgresql-9.4.1212.jar"
    jdbc_driver_class => "org.postgresql.Driver"
    jdbc_connection_string => "jdbc:postgresql://192.168.5.16:5432/AUDIT"
    jdbc_user => "postgres"
    schedule => "* * * * *"
    statement => "SELECT id, username, depname, srcpath, dstpath FROM pulic.tfilemonex WHERE id > :sql_last_value"
    use_column_value => true
    tracking_column => id
  }
}

```

The error:

```auto
[ERROR][logstash.agent] Pipeline aborted due to error {:exception=>#<Sequel::DatabaseConnectionError: Java::OrgPostgresqlUtil::PSQLException: FATAL: role "greg" does not exist>, :backtrace=>["org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(org/postgresql/core/v3/QueryExecutorImpl.java:2455)",
...

```

And the "greg" is the user of my os--CentOS6.5.  
How can I fix it?

---

<div class="post-metadata">

**Author:** ![Wynter\_Greg](https://avatars.discourse-cdn.com/v4/letter/w/6bbea6/32.png) [@Wynter\_Greg](https://discuss.elastic.co/u/Wynter_Greg)\
**Post date:** [February 12, 2017, 1:33am UTC](https://discuss.elastic.co/t/can-not-start-logstash-with-jdbc-to-postgresql9-5-5-except-an-error-role-greg-does-not-exist/74623/2 "2017-02-12T01:33:38Z")

</div>

Anybody help?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 12, 2017, 1:34am UTC](https://discuss.elastic.co/t/can-not-start-logstash-with-jdbc-to-postgresql9-5-5-except-an-error-role-greg-does-not-exist/74623/3 "2017-03-12T01:34:20Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.