[Pgpool-general] Parallel Query Mode - SELECT, Phppgadmin, Psql]]]

[calimlimvl at nationalbookstore.com.ph]

Hello,

Oh, so that would be 3 in my list that are so far not working:

1. PHP PDO bindParam when doing INSERTs
2. COPY table FROM csvfile
3. JDBC

What could possibly be the fastest way to migrate data from MySQL to
Pgpool-II Server(PostgreSQL) in our case then? Anyone please? Thank you.

Regards,
Viril Calimlim

> we had similar problem but with JDBC. pgpool parallel mode does not
> support extended protocol (PREPARE/BIND ..) of this driver which is what
> I think you are rely on as well. with JDBC I'd get mirroring instead of
> partitioning, however when I do the same insert from the cli/psql -
> partitioning rules are applied properly and data is partitioned as
> expected one backend node only. my setup is two nodes running
> pgsql-8.3.3 single table inserts, partitioning on bigint. we had to
> re-consider using pgpool II because of this issue.
> V.
>
> calimlimvl at nationalbookstore.com.ph wrote:
>> Hello again,
>>
>>
>>>> Hi.
>>>>
>>>>
>>>>
>>>>>>> It's now working in pgpool-II 2.1 RC1. No more problems. And yes I
>>>>>>>
>>>>> use
>>>>>
>>>>>>> PHP
>>>>>>> PDO and AdoDB. My previous post has more details. So what's the
>>>>>>> replicate_def table and replicate_select for? Thanks again. :)
>>>>>>>
>>
>>
>>>>> --- snipped ---
>>>>>
>>
>> Sorry. I take it back. It works with direct PDO INSERT statement
>> (without
>> prepare, just execute the query string directly) but not with PDO
>> bindParam wherein I first PREPARE the statement and do multiple inserts
>> with a loop because I'm trying to migrate the records from MySQL to
>> PostgreSQL. Instead of partitioning the data, it copies the inserted row
>> to all nodes and when I browse the pgpool-II server, it displays 3
>> copies
>> of the row inserted! Can anyone explain to me what had just happened
>> please? Thanks.
>>
>> Regards,
>> Viril
>>
>> _______________________________________________
>> Pgpool-general mailing list
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>
>>
>
>