search

confluentinc / bottledwater-pg

Change data capture from PostgreSQL into Kafka
http://blog.confluent.io/2015/04/23/bottled-water-real-time-integration-of-postgresql-and-kafka/
Apache License 2.0
3 stars 149 forks source link

creating bottledwater.control file in remote db #136

Open gyan opened 7 years ago

gyan commented 7 years ago

running make && make install install extensions like bottledwater.so and bottledwater.control in locally installed postgres directories. How is one supposed to create same files in remote db while running make && make install command.

mbelarbi commented 7 years ago

make install only installs the bottled water postgres extension to your target database.

I also have a 2 server setup,

I (obviously) needed to install bottled water on the bottled water server but did not run the make install part since this server has no db to install the postgres extension to.

I needed to also install bottled water on the db server and only run the make install part to get the bottled water extension on my database, and ran the create extension bottledwater; query.

I then setup a replication user (pg_hba.conf) on the db server, opened port 5432 on the db server for the other server. I think that should do it.

tldr: you basically need to install bottled water on both servers, running make install on the db server to get the extension there.

gyan commented 7 years ago

Thanks for the reply. Well I got that working, but the end story followed up with the inability of Amazon hosted RDS to allow users to create third party extension.