# I'm a beginner. I want to use elasticsearch with PostgreSQL **URL:** \ **Category:** Elasticsearch\ **Created:** [April 19, 2013, 3:03pm UTC](https://discuss.elastic.co/t/im-a-beginner-i-want-to-use-elasticsearch-with-postgresql/11646 "2013-04-19T15:03:11Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![eby\_eurogiciel](https://avatars.discourse-cdn.com/v4/letter/e/d9b06d/32.png) [@eby\_eurogiciel](https://discuss.elastic.co/u/eby_eurogiciel)\ **Post date:** [April 19, 2013, 3:03pm UTC](https://discuss.elastic.co/t/im-a-beginner-i-want-to-use-elasticsearch-with-postgresql/11646/1 "2013-04-19T15:03:11Z")
Hello, first thank you to read me ! second I'm french and my english is very bad ! third I hope you can help me. I really want to use ES !!!! So, I want to use ES with postgreSQL. ES and postgreSQL are on the same server (debian). ES is running no problem. I'm using Elasticsearch head. It's ok but status is yellow. Normal my cluster is Unassigned !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! And there's the default cluster (I don't mind....) There's no modification in elasticsearch.yml. Connection with PostgreSQL : I have done this : > **[jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc/wiki/Step-by-step-recipe-for-setting-up-the-river-with-PostgreSQL)** > > elasticsearch-jdbc - JDBC importer for Elasticsearch curl -XPUT 'localhost:920\_river/my\_jdbc\_river/\_meta' -d '{ "type" : "jdbc", "jdbc" : { "driver" : "org.postgresql.Driver", "url" : "jdbc:postgresql://localhost:5432/PMS", "user" : "postgres", "password" : "postgres" }, "index" : { "index" : "jdbc", "type" : "jdbc" } }' Result : {"ok":true,"\_index":"\_river","\_type":"my\_jdbc\_river","\_id":"\_meta","\_version":1} But if I redo this with bad user or password, result is the same !!!!!!!!!!!!!!!!! \*Well, \* 1. _how to remove the default cluster ?_ 2. _how to connect ES with PostgreSQL ? What is wrong ?_ 3. _Please, please, please, please help !!!!!_ _Thank you very much everyone._ -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [April 19, 2013, 3:12pm UTC](https://discuss.elastic.co/t/im-a-beginner-i-want-to-use-elasticsearch-with-postgresql/11646/2 "2013-04-19T15:12:24Z")
Welcome! We (frenchies) are always saying "excuse for my french". That's how everyone know that we are french 馃槈 About french question, you should be aware that there is also a french mailing list which should help you: [elasticsearch-fr@googlegroups.com](mailto:elasticsearch-fr@googlegroups.com) Everything you did by now sounds ok. Did you try to search after creating the river? Can you see anything in logs? Also, I don't understand what is a "Cluster" from your point of view? Are you talking about indexes? -- David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr | @scrutmydocs Le 19 avr. 2013 脿 17:03, eby eurogiciel [eby.eurogiciel@gmail.com](mailto:eby.eurogiciel@gmail.com) a 茅crit : > Hello, > first thank you to read me ! > second I'm french and my english is very bad ! > third I hope you can help me. I really want to use ES !!!! > > So, > I want to use ES with postgreSQL. ES and postgreSQL are on the same server (debian). > ES is running no problem. I'm using Elasticsearch head. > > It's ok but status is yellow. Normal my cluster is Unassigned !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! And there's the default cluster (I don't mind....) > > There's no modification in elasticsearch.yml. > > Connection with PostgreSQL : I have done this : [Step by step recipe for setting up the river with PostgreSQL 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Step-by-step-recipe-for-setting-up-the-river-with-PostgreSQL) > > curl -XPUT 'localhost:920\_river/my\_jdbc\_river/\_meta' -d '{ "type" : "jdbc", "jdbc" : { "driver" : "org.postgresql.Driver", "url" : "jdbc:postgresql://localhost:5432/PMS", "user" : "postgres", "password" : "postgres" }, "index" : { "index" : "jdbc", "type" : "jdbc" } }' > Result : {"ok":true,"\_index":"\_river","\_type":"my\_jdbc\_river","\_id":"\_meta","\_version":1} > > But if I redo this with bad user or password, result is the same !!!!!!!!!!!!!!!!! > > Well, > how to remove the default cluster ? > how to connect ES with PostgreSQL ? What is wrong ? > Please, please, please, please help !!!!! > > Thank you very much everyone. > > -- > You received this message because you are subscribed to the Google Groups "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![eby\_eurogiciel](https://avatars.discourse-cdn.com/v4/letter/e/d9b06d/32.png) [@eby\_eurogiciel](https://discuss.elastic.co/u/eby_eurogiciel)\ **Post date:** [April 19, 2013, 3:24pm UTC](https://discuss.elastic.co/t/im-a-beginner-i-want-to-use-elasticsearch-with-postgresql/11646/3 "2013-04-19T15:24:17Z")
Hello, thank you very much for your answer. Yes I have tried to search after creating the river but nothing. Please look the picture with my message. I think you will understand easier my problem. And sorry I'm wrong : I speak about node :s Ellande Le vendredi 19 avril 2013 17:12:25 UTC+2, David Pilato a 茅crit : > Welcome! > > We (frenchies) are always saying "excuse for my french". That's how > everyone know that we are french 馃槈 > About french question, you should be aware that there is also a french > mailing list which should help you: [elastics...@googlegroups.com](mailto:elastics...@googlegroups.com)\ > > Everything you did by now sounds ok. > Did you try to search after creating the river? > Can you see anything in logs? > > Also, I don't understand what is a "Cluster" from your point of view? Are > you talking about indexes? > > -- > _David Pilato_ | _Technical Advocate_ | _[Elasticsearch.com](http://Elasticsearch.com)_ > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > Le 19 avr. 2013 脿 17:03, eby eurogiciel \<[eby.eur...@gmail.com](mailto:eby.eur...@gmail.com)\\> > a 茅crit : > > Hello, > first thank you to read me ! > second I'm french and my english is very bad ! > third I hope you can help me. I really want to use ES !!!! > > So, > I want to use ES with postgreSQL. ES and postgreSQL are on the same server > (debian). > ES is running no problem. I'm using Elasticsearch head. > > It's ok but status is yellow. Normal my cluster is Unassigned > !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! And there's the default > cluster (I don't mind....) > > There's no modification in elasticsearch.yml. > > Connection with PostgreSQL : I have done this : > [Step by step recipe for setting up the river with PostgreSQL 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Step-by-step-recipe-for-setting-up-the-river-with-PostgreSQL) > > curl -XPUT 'localhost:920\_river/my\_jdbc\_river/\_meta' -d '{ "type" : > "jdbc", "jdbc" : { "driver" : "org.postgresql.Driver", "url" : > "jdbc:postgresql://localhost:5432/PMS", "user" : "postgres", "password" : > "postgres" }, "index" : { "index" : "jdbc", "type" : "jdbc" } }' > Result : > {"ok":true,"\_index":"\_river","\_type":"my\_jdbc\_river","\_id":"\_meta","\_version":1} > > But if I redo this with bad user or password, result is the same > !!!!!!!!!!!!!!!!! > > \*Well, > \* > > 1. _how to remove the default cluster ?_ > 2. _how to connect ES with PostgreSQL ? What is wrong ?_ > 3. _Please, please, please, please help !!!!!_ > > _Thank you very much everyone._ > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![eby\_eurogiciel](https://avatars.discourse-cdn.com/v4/letter/e/d9b06d/32.png) [@eby\_eurogiciel](https://discuss.elastic.co/u/eby_eurogiciel)\ **Post date:** [April 19, 2013, 3:29pm UTC](https://discuss.elastic.co/t/im-a-beginner-i-want-to-use-elasticsearch-with-postgresql/11646/4 "2013-04-19T15:29:58Z")
Ah ah, effectivement, en fran莽ais, 莽a va 锚tre plus simple !!!! Surtout que pour le moment, je panne 脿 peu pr猫s rien :s !!! Le vendredi 19 avril 2013 17:03:11 UTC+2, eby eurogiciel a 茅crit : > Hello, > first thank you to read me ! > second I'm french and my english is very bad ! > third I hope you can help me. I really want to use ES !!!! > > So, > I want to use ES with postgreSQL. ES and postgreSQL are on the same server > (debian). > ES is running no problem. I'm using Elasticsearch head. > > It's ok but status is yellow. Normal my cluster is Unassigned > !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! And there's the default > cluster (I don't mind....) > > There's no modification in elasticsearch.yml. > > Connection with PostgreSQL : I have done this : > [Step by step recipe for setting up the river with PostgreSQL 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Step-by-step-recipe-for-setting-up-the-river-with-PostgreSQL) > > curl -XPUT 'localhost:920\_river/my\_jdbc\_river/\_meta' -d '{ "type" : > "jdbc", "jdbc" : { "driver" : "org.postgresql.Driver", "url" : > "jdbc:postgresql://localhost:5432/PMS", "user" : "postgres", "password" : > "postgres" }, "index" : { "index" : "jdbc", "type" : "jdbc" } }' > Result : > {"ok":true,"\_index":"\_river","\_type":"my\_jdbc\_river","\_id":"\_meta","\_version":1} > > But if I redo this with bad user or password, result is the same > !!!!!!!!!!!!!!!!! > > \*Well, > \* > > 1. _how to remove the default cluster ?_ > 2. _how to connect ES with PostgreSQL ? What is wrong ?_ > 3. _Please, please, please, please help !!!!!_ > > _Thank you very much everyone._ -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [April 19, 2013, 4:58pm UTC](https://discuss.elastic.co/t/im-a-beginner-i-want-to-use-elasticsearch-with-postgresql/11646/5 "2013-04-19T16:58:43Z")
Even with node, I don't understand what is "removing the default node"? Removing a node from the cluster is simply "stop it". If you need to clean an index (remove an index), just run: curl -XDELETE [http://localhost:9200/yourindexname](http://localhost:9200/yourindexname) If you want to remove the river: curl -XDELETE [http://localhost:9200/\_river/yourrivername](http://localhost:9200/_river/yourrivername) -- David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr | @scrutmydocs Le 19 avr. 2013 脿 17:24, eby eurogiciel [eby.eurogiciel@gmail.com](mailto:eby.eurogiciel@gmail.com) a 茅crit : > Hello, > thank you very much for your answer. > Yes I have tried to search after creating the river but nothing. > Please look the picture with my message. I think you will understand easier my problem. > And sorry I'm wrong : I speak about node :s > > Ellande > > Le vendredi 19 avril 2013 17:12:25 UTC+2, David Pilato a 茅crit : > Welcome! > > We (frenchies) are always saying "excuse for my french". That's how everyone know that we are french 馃槈 > About french question, you should be aware that there is also a french mailing list which should help you: [elastics...@googlegroups.com](mailto:elastics...@googlegroups.com) > > Everything you did by now sounds ok. > Did you try to search after creating the river? > Can you see anything in logs? > > Also, I don't understand what is a "Cluster" from your point of view? Are you talking about indexes? > > -- > David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) > @dadoonet | @elasticsearchfr | @scrutmydocs > > Le 19 avr. 2013 脿 17:03, eby eurogiciel [eby.eur...@gmail.com](mailto:eby.eur...@gmail.com) a 茅crit : > > > Hello, > > first thank you to read me ! > > second I'm french and my english is very bad ! > > third I hope you can help me. I really want to use ES !!!! > > > > So, > > I want to use ES with postgreSQL. ES and postgreSQL are on the same server (debian). > > ES is running no problem. I'm using Elasticsearch head. > > > > It's ok but status is yellow. Normal my cluster is Unassigned !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! And there's the default cluster (I don't mind....) > > > > There's no modification in elasticsearch.yml. > > > > Connection with PostgreSQL : I have done this : [Step by step recipe for setting up the river with PostgreSQL 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Step-by-step-recipe-for-setting-up-the-river-with-PostgreSQL) > > > > curl -XPUT 'localhost:920\_river/my\_jdbc\_river/\_meta' -d '{ "type" : "jdbc", "jdbc" : { "driver" : "org.postgresql.Driver", "url" : "jdbc:postgresql://localhost:5432/PMS", "user" : "postgres", "password" : "postgres" }, "index" : { "index" : "jdbc", "type" : "jdbc" } }' > > Result : {"ok":true,"\_index":"\_river","\_type":"my\_jdbc\_river","\_id":"\_meta","\_version":1} > > > > But if I redo this with bad user or password, result is the same !!!!!!!!!!!!!!!!! > > > > Well, > > how to remove the default cluster ? > > how to connect ES with PostgreSQL ? What is wrong ? > > Please, please, please, please help !!!!! > > > > Thank you very much everyone. > > > > -- > > You received this message because you are subscribed to the Google Groups "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > -- > You received this message because you are subscribed to the Google Groups "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > \ ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 2:40am UTC](https://discuss.elastic.co/t/im-a-beginner-i-want-to-use-elasticsearch-with-postgresql/11646/6 "2017-07-06T02:40:21Z")