Thread: [ADMIN] dblink_tds or similar for PostgreSQL 10
Hi. I need to migrate a database from Postgres 9.0 to Postgres 10. On pg9 we use dblink_tds to connect to a Ms SQL Server to do a simple INSERT and a simple SELECT. So, there is an alternative in pg10 similar to dblink_tds for make SELECTs and INSERTs on MS SQL? If not, what do yo recommend me? Thanks. Carlos Martinez. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
2017-09-27 4:02 GMT-03:00 Carlos Martinez <camarti@gmail.com>:
>
> Hi.
>
> I need to migrate a database from Postgres 9.0 to Postgres 10.
>
Be careful because version 10 "stable" isn't released yet.
> On pg9 we use dblink_tds to connect to a Ms SQL Server to do a simple
> INSERT and a simple SELECT.
>
> So, there is an alternative in pg10 similar to dblink_tds for make
> SELECTs and INSERTs on MS SQL?
>
> If not, what do yo recommend me?
>
I think dblink_tds is deprecated for a long time... for now we recommend use Foreign Data Wrappers [1] and in your case tds_fdw [2].
[1] https://wiki.postgresql.org/wiki/Foreign_data_wrappers
[2] https://pgxn.org/dist/tds_fdw/
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
> INSERT and a simple SELECT.
>
> So, there is an alternative in pg10 similar to dblink_tds for make
> SELECTs and INSERTs on MS SQL?
>
> If not, what do yo recommend me?
>
I think dblink_tds is deprecated for a long time... for now we recommend use Foreign Data Wrappers [1] and in your case tds_fdw [2].
Regards,
[1] https://wiki.postgresql.org/wiki/Foreign_data_wrappers
[2] https://pgxn.org/dist/tds_fdw/
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
Hi. I know that Postgres 10 is not yet stable. The migration will take around 3 or 4 months. I will expect by then, the stable version. I've reading about FDW and tds_fdw (library for MS SQL), but it says: "The current version does not yet support WHERE clause push-down, column push-down, JOIN push-down, or write operations." Sadly, I need to do a INSERT on MS SQL. Thanks. Carlos Martinez On Wed, Sep 27, 2017 at 8:57 AM, Fabrízio de Royes Mello <fabrizio@timbira.com.br> wrote: > > 2017-09-27 4:02 GMT-03:00 Carlos Martinez <camarti@gmail.com>: >> >> Hi. >> >> I need to migrate a database from Postgres 9.0 to Postgres 10. >> > > Be careful because version 10 "stable" isn't released yet. > > >> On pg9 we use dblink_tds to connect to a Ms SQL Server to do a simple >> INSERT and a simple SELECT. >> >> So, there is an alternative in pg10 similar to dblink_tds for make >> SELECTs and INSERTs on MS SQL? >> >> If not, what do yo recommend me? >> > > I think dblink_tds is deprecated for a long time... for now we recommend use > Foreign Data Wrappers [1] and in your case tds_fdw [2]. > > Regards, > > [1] https://wiki.postgresql.org/wiki/Foreign_data_wrappers > [2] https://pgxn.org/dist/tds_fdw/ > > -- > Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/ > PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Carlos Martinez wrote: > Hi. > > I know that Postgres 10 is not yet stable. The migration will take > around 3 or 4 months. I will expect by then, the stable version. > I've reading about FDW and tds_fdw (library for MS SQL), but it says: > "The current version does not yet support WHERE clause push-down, > column push-down, JOIN push-down, or write operations." In other words, you have 3-4 months to poke the tds_fdw maintainer to add support for that (or do it yourself, or convince someone else to do it for you). > Sadly, I need to do a INSERT on MS SQL. You should be happy that you're using the most advanced relational open source database server in the world, not sad. cheers -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Hi. On Wed, Sep 27, 2017 at 9:55 AM, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote: > Carlos Martinez wrote: >> Hi. >> >> I know that Postgres 10 is not yet stable. The migration will take >> around 3 or 4 months. I will expect by then, the stable version. >> I've reading about FDW and tds_fdw (library for MS SQL), but it says: >> "The current version does not yet support WHERE clause push-down, >> column push-down, JOIN push-down, or write operations." > > In other words, you have 3-4 months to poke the tds_fdw maintainer to > add support for that (or do it yourself, or convince someone else to do > it for you). Yes, this is an option. I will write to the mantainer of tds_fdw. If there is another alternative, it will be welcome. > >> Sadly, I need to do a INSERT on MS SQL. > > You should be happy that you're using the most advanced relational open > source database server in the world, not sad. Yes, I'm very happy to work with Postgres [and Linux and others open source projects]. I'm not very happy with to have to resolve this issue on database level. Best regards. Carlos Martínez. > > cheers > > -- > Álvaro Herrera https://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Carlos Martinez wrote: > On Wed, Sep 27, 2017 at 9:55 AM, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote: > > Carlos Martinez wrote: > >> Sadly, I need to do a INSERT on MS SQL. > > > > You should be happy that you're using the most advanced relational open > > source database server in the world, not sad. > > Yes, I'm very happy to work with Postgres [and Linux and others open > source projects]. I'm not very happy with to have to resolve this > issue on database level. Postgres (and Linux, etc) is great because lots of people had each their own small need, and they pushed to see that need fulfilled. It is not made great by people that just expect that it already solves all their problems. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
2017-09-27 13:53 GMT-03:00 Carlos Martinez <camarti@gmail.com>:
>
> Hi.
>
> On Wed, Sep 27, 2017 at 9:55 AM, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> > Carlos Martinez wrote:
> >> Hi.
> >>
> >> I know that Postgres 10 is not yet stable. The migration will take
> >> around 3 or 4 months. I will expect by then, the stable version.
> >> I've reading about FDW and tds_fdw (library for MS SQL), but it says:
> >> "The current version does not yet support WHERE clause push-down,
> >> column push-down, JOIN push-down, or write operations."
> >
> > In other words, you have 3-4 months to poke the tds_fdw maintainer to
> > add support for that (or do it yourself, or convince someone else to do
> > it for you).
>
> Yes, this is an option. I will write to the mantainer of tds_fdw. If
> there is another alternative, it will be welcome.
>
Did you see the FDW wiki page [1] I sent to you before? There are an ODBC FDW... maybe it can help you!
Regards,
[1] https://wiki.postgresql. org/wiki/Foreign_data_wrappers
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento