creating bottledwater.control file in remote db

[gyan]

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]

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

I also have a 2 server setup,

• db server
• bottled water+kafka server.

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]

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.