Re: [GENERAL] Pg_bulkload for PostgreSql 9.5

2016-07-13 Thread Devrim Gündüz
Hi, On Fri, 2016-06-17 at 13:29 +0200, Job wrote: > i have some problems about compiling pg_bulkload-3.1.8 on a CentOS 5 with > Postgresql 9.5. > If i use a previous version of Psql it compile and works. I just built and pushed 3.1.9 packages to yum repo for CentOS 5. They will sync to master re

Re: [GENERAL] Pg_bulkload for PostgreSql 9.5

2016-06-19 Thread Tatsuro Yamada
Hi Francesco, Could you try using pg_bulkload 3.1.9? PostgreSQL 9.5 is supported from this version. See Release Notes. https://github.com/ossc-db/pg_bulkload/releases Release Notes 3.1.9 *It adds support for PostgreSQL 9.5 and includes fix for possible unsafe behavior when used alongside o

Re: [GENERAL] Pg_bulkload for PostgreSql 9.5

2016-06-17 Thread Michael Paquier
On Fri, Jun 17, 2016 at 8:29 PM, Job wrote: > i have some problems about compiling pg_bulkload-3.1.8 on a CentOS 5 with > Postgresql 9.5. > If i use a previous version of Psql it compile and works. The project page states that 9.5 is supported with this version: https://github.com/ossc-db/pg_bul

[GENERAL] Pg_bulkload for PostgreSql 9.5

2016-06-17 Thread Job
Hello, i have some problems about compiling pg_bulkload-3.1.8 on a CentOS 5 with Postgresql 9.5. If i use a previous version of Psql it compile and works. Thank you if you can help me Francesco -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscr

Re: [GENERAL] pg_bulkload

2015-06-11 Thread Takashi Ohnishi
015 3:01 AM To: pgsql-general@postgresql.org Subject: [GENERAL] pg_bulkload I was wondering when pg_bulkload will be available for PostgresSQL 9.4 on Windows?  Thank you, Fawn Nguyen DBA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

[GENERAL] pg_bulkload

2015-06-11 Thread Nguyen, Phuonglan H.
I was wondering when pg_bulkload will be available for PostgresSQL 9.4 on Windows? Thank you, Fawn Nguyen DBA

Re: [GENERAL] Pg_bulkload and speed

2015-04-29 Thread Takashi Ohnishi
Hello, > Due to speed up loading of a table of about 4 fields with 10 millions of > record, are there some parameters to optimize? > In same machine it takes about 15 minutes, in other machines about one hour. > > Parallel mode is better than direct mode? > Other interesting things? Yes, parall

Re: [GENERAL] Pg_bulkload and speed

2015-04-29 Thread Jim Nasby
On 4/29/15 4:24 AM, Job wrote: Hello! Due to speed up loading of a table of about 4 fields with 10 millions of record, are there some parameters to optimize? In same machine it takes about 15 minutes, in other machines about one hour. There's a huge number of things that could account for thi

[GENERAL] Pg_bulkload and speed

2015-04-29 Thread Job
Hello! Due to speed up loading of a table of about 4 fields with 10 millions of record, are there some parameters to optimize? In same machine it takes about 15 minutes, in other machines about one hour. Parallel mode is better than direct mode? Other interesting things? Thank you in advance fo

Re: [GENERAL] pg_bulkload

2009-01-07 Thread Adrian Klaver
On Wednesday 07 January 2009 4:10:34 pm John Randall wrote: > Does anyone know if this utility can generate a log file of records that > for some reason do not load to a PostgreSQL database? I’m looking for > something like Oracle’s SQLLDR where an error is generated when a record > fails to load.

[GENERAL] pg_bulkload

2009-01-07 Thread John Randall
Does anyone know if this utility can generate a log file of records that for some reason do not load to a PostgreSQL database? I’m looking for something like Oracle’s SQLLDR where an error is generated when a record fails to load. If not pg_bulkload, perhaps there is some other like utility. Tha