EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
530 stars 162 forks source link

howto upgrade #128

Open eMerzh opened 7 years ago

eMerzh commented 7 years ago

Hi, just noticed that you made a new release ( 🎉 ) now i want to use it in my local install

but i can't find the [good] way to update the extension.

gabbasb commented 7 years ago

@eMerzh please try "make USE_PGXS=1 install" on the latest sources. It will update the extension.

eMerzh commented 7 years ago

@gabbasb OK Thanks,

And to reload the thing in PG , should I do something or it supposed to 'update itself'?

ahsanhadi commented 7 years ago

On Fri, Feb 17, 2017 at 11:24 AM, eMerzh notifications@github.com wrote:

@gabbasb https://github.com/gabbasb OK Thanks,

And to reload the thing in PG , should I do something or it supposed to 'update itself'?

You will need to drop and recreate the extension in PG...

—

You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/EnterpriseDB/mysql_fdw/issues/128#issuecomment-280564969, or mute the thread https://github.com/notifications/unsubscribe-auth/AHmqpKjIhXe05bA1ssEdK0gjyF-pOS5zks5rdT0qgaJpZM4MBZQ3 .

-- Ahsan Hadi Snr Director Product Development EnterpriseDB Corporation The Enterprise Postgres Company

Phone: +92-51-8358874 Mobile: +92-333-5162114

Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.

ibrarahmad commented 7 years ago

On Fri, Feb 17, 2017 at 4:18 PM, Ahsan Hadi notifications@github.com wrote:

On Fri, Feb 17, 2017 at 11:24 AM, eMerzh notifications@github.com wrote:

@gabbasb https://github.com/gabbasb OK Thanks,

And to reload the thing in PG , should I do something or it supposed to 'update itself'?

You will need to drop and recreate the extension in PG...

Actually you need to reconnect with PG only. This version does not require drop and create extension.

—

You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/EnterpriseDB/mysql_fdw/issues/ 128#issuecomment-280564969, or mute the thread https://github.com/notifications/unsubscribe-auth/ AHmqpKjIhXe05bA1ssEdK0gjyF-pOS5zks5rdT0qgaJpZM4MBZQ3 .

-- Ahsan Hadi Snr Director Product Development EnterpriseDB Corporation The Enterprise Postgres Company

Phone: +92-51-8358874 <(051)%208358874> Mobile: +92-333-5162114 <0333%205162114>

Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/EnterpriseDB/mysql_fdw/issues/128#issuecomment-280624178, or mute the thread https://github.com/notifications/unsubscribe-auth/ADbS8kBROUbThB9bIMUgrwIpycavBL2jks5rdYHvgaJpZM4MBZQ3 .

-- Ibrar Ahmed EnterpriseDB http://www.enterprisedb.com

ahsanhadi commented 7 years ago

On Fri, Feb 17, 2017 at 4:32 PM, Ibrar Ahmed notifications@github.com wrote:

On Fri, Feb 17, 2017 at 4:18 PM, Ahsan Hadi notifications@github.com wrote:

On Fri, Feb 17, 2017 at 11:24 AM, eMerzh notifications@github.com wrote:

@gabbasb https://github.com/gabbasb OK Thanks,

And to reload the thing in PG , should I do something or it supposed to 'update itself'?

You will need to drop and recreate the extension in PG...

Actually you need to reconnect with PG only. This version does not require drop and create extension.

Ibrar is right, the drop/create extension is not needed for this release...

—

You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/EnterpriseDB/mysql_fdw/issues/ 128#issuecomment-280564969, or mute the thread https://github.com/notifications/unsubscribe-auth/ AHmqpKjIhXe05bA1ssEdK0gjyF-pOS5zks5rdT0qgaJpZM4MBZQ3 .

-- Ahsan Hadi Snr Director Product Development EnterpriseDB Corporation The Enterprise Postgres Company

Phone: +92-51-8358874 <(051)%208358874> <(051)%208358874> Mobile: +92-333-5162114 <0333%205162114> <0333%205162114>

Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/EnterpriseDB/mysql_fdw/issues/ 128#issuecomment-280624178, or mute the thread https://github.com/notifications/unsubscribe-auth/ ADbS8kBROUbThB9bIMUgrwIpycavBL2jks5rdYHvgaJpZM4MBZQ3 .

-- Ibrar Ahmed EnterpriseDB http://www.enterprisedb.com

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/EnterpriseDB/mysql_fdw/issues/128#issuecomment-280626695, or mute the thread https://github.com/notifications/unsubscribe-auth/AHmqpPmd_I0FU5Jl-eaooJtB-8cAaYt9ks5rdYU0gaJpZM4MBZQ3 .

-- Ahsan Hadi Snr Director Product Development EnterpriseDB Corporation The Enterprise Postgres Company

Phone: +92-51-8358874 Mobile: +92-333-5162114

Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.

eMerzh commented 7 years ago

Actually you need to reconnect with PG only.

? like shut the connection and reconnect to postgres? anyway it might be cool to have a little note about this somewhere in the readme / faq / ...

ahsanhadi commented 7 years ago

On Fri, Feb 17, 2017 at 6:00 PM, eMerzh notifications@github.com wrote:

Actually you need to reconnect with PG only. ? like shut the connection and reconnect to postgres?

you just need to exit the session and reconnect..

anyway it might be cool to have a little note about this somewhere in the readme / faq / ...

yes we will have upgrade notes going forward..

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/EnterpriseDB/mysql_fdw/issues/128#issuecomment-280642760, or mute the thread https://github.com/notifications/unsubscribe-auth/AHmqpOx948E7DunRkMtAUcYkVQnUwZ-Yks5rdZoAgaJpZM4MBZQ3 .

-- Ahsan Hadi Snr Director Product Development EnterpriseDB Corporation The Enterprise Postgres Company

Phone: +92-51-8358874 Mobile: +92-333-5162114

Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.