pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddblink_tds or similar for PostgreSQL 10
7+ messages / 3 participants
[nested] [flat]
* dblink_tds or similar for PostgreSQL 10
@ 2017-09-27 07:02 Carlos Martinez <camarti@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Carlos Martinez @ 2017-09-27 07:02 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: dblink_tds or similar for PostgreSQL 10
@ 2017-09-27 13:57 Fabrízio de Royes Mello <fabrizio@timbira.com.br>
parent: Carlos Martinez <camarti@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Fabrízio de Royes Mello @ 2017-09-27 13:57 UTC (permalink / raw)
To: 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].
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: dblink_tds or similar for PostgreSQL 10
@ 2017-09-27 14:45 Carlos Martinez <camarti@gmail.com>
parent: Fabrízio de Royes Mello <fabrizio@timbira.com.br>
0 siblings, 1 reply; 7+ messages in thread
From: Carlos Martinez @ 2017-09-27 14:45 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: dblink_tds or similar for PostgreSQL 10
@ 2017-09-27 14:55 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: Carlos Martinez <camarti@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Alvaro Herrera @ 2017-09-27 14:55 UTC (permalink / raw)
To: Carlos Martinez <camarti@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: dblink_tds or similar for PostgreSQL 10
@ 2017-09-27 16:53 Carlos Martinez <camarti@gmail.com>
parent: Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 2 replies; 7+ messages in thread
From: Carlos Martinez @ 2017-09-27 16:53 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: dblink_tds or similar for PostgreSQL 10
@ 2017-09-27 17:03 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: Carlos Martinez <camarti@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Alvaro Herrera @ 2017-09-27 17:03 UTC (permalink / raw)
To: Carlos Martinez <camarti@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: dblink_tds or similar for PostgreSQL 10
@ 2017-09-27 17:42 Fabrízio de Royes Mello <fabrizio@timbira.com.br>
parent: Carlos Martinez <camarti@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Fabrízio de Royes Mello @ 2017-09-27 17:42 UTC (permalink / raw)
To: Carlos Martinez <camarti@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2017-09-27 17:42 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-09-27 07:02 dblink_tds or similar for PostgreSQL 10 Carlos Martinez <camarti@gmail.com>
2017-09-27 13:57 ` Fabrízio de Royes Mello <fabrizio@timbira.com.br>
2017-09-27 14:45 ` Carlos Martinez <camarti@gmail.com>
2017-09-27 14:55 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2017-09-27 16:53 ` Carlos Martinez <camarti@gmail.com>
2017-09-27 17:03 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2017-09-27 17:42 ` Fabrízio de Royes Mello <fabrizio@timbira.com.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox