Обсуждение: [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

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