Hi All, Just adding the actual error again.
I run the the *dbt2-pgsql-build-db -w 1 * Output directory of data files: current directory *Generating data files for 1 warehouse(s)...* *Generating item table data...* *BEGIN* *ERROR: invalid byte sequence for encoding "UTF8": 0xf9* *CONTEXT: COPY item, line 1* *ROLLBACK* This pattern the above found many times. Please guide me through!!! Regards, Rohit Goyal On Tue, May 20, 2014 at 9:15 AM, Rohit Goyal <rhtgyl...@gmail.com> wrote: > Hi All, > > > > On Tue, May 13, 2014 at 9:44 PM, Peter Geoghegan <p...@heroku.com> wrote: > >> >> On Tue, May 13, 2014 at 12:36 PM, Rohit Goyal <rhtgyl...@gmail.com>wrote: >> >>> This pattern the above found many times. Please guide me through!!! >>> >> >> IIRC, people have been working around this by setting >> standard_conforming_strings to "off". It really ought to be fixed in a >> principled way, though -- the real issue here is that dbt2 has severe >> bit-rot. >> >> > Sorry for so asking so late. I thought the error is resolved. > > I changed standard_conforming_strings to "off" in *postgresql.conf.* and > then I run *dbt2-pgsql-build-db -w 1 script again. * > But, I am still facing the same error. Please tel me what else I can do to > resolve the issue. > > Regards, > Rohit Goyal > >> -- >> Peter Geoghegan >> > > > > -- > Regards, > Rohit Goyal > -- Regards, Rohit Goyal