postgres_to_redshift

postgres_to_redshift copied to clipboard

Bumps [nokogiri](https://github.com/sparklemotion/nokogiri) from 1.6.6.2 to 1.13.9. Release notes Sourced from nokogiri's releases. 1.13.9 / 2022-10-18 Security [CRuby] Vendored libxml2 is updated to address CVE-2022-2309, CVE-2022-40304, and CVE-2022-40303. See GHSA-2qc6-mcvw-92cw for...

dependabot[bot]

murtyk

Updates the requirements on [rake](https://github.com/ruby/rake) to permit the latest version. Changelog *Sourced from [rake's changelog](https://github.com/ruby/rake/blob/master/History.rdoc).* > === 13.0.1 > > ==== Bug fixes > > * Fixed bug: Reenabled task...

dependabot[bot]

Hi, I noticed a few missing datatypes and the fact that my Floats were being rounded. This helped me, I thought others might benefit from it too.

wheller

add a few more cast types using character varying

1

add a few more types.

nas887

Version 0.1.2 We have been using PostgresToRedshift.update_tables method to copy tables from PG to Redshift every day since August 2017 and never had a problem. Suddenly we got this error:...

murtyk

Zlib::GzipFile::Error: closed gzip stream here is the stack trace ```/home/deploy/apps/vydia/shared/bundle/ruby/2.1.0/bundler/gems/postgres_to_redshift-1cf00b46e712/lib/postgres_to_redshift.rb:121:in `close' /home/deploy/apps/vydia/shared/bundle/ruby/2.1.0/bundler/gems/postgres_to_redshift-1cf00b46e712/lib/postgres_to_redshift.rb:121:in `ensure in copy_table' /home/deploy/apps/vydia/shared/bundle/ruby/2.1.0/bundler/gems/postgres_to_redshift-1cf00b46e712/lib/postgres_to_redshift.rb:122:in `copy_table' /home/deploy/apps/vydia/shared/bundle/ruby/2.1.0/bundler/gems/postgres_to_redshift-1cf00b46e712/lib/postgres_to_redshift.rb:27:in `block in update_tables' /home/deploy/apps/vydia/shared/bundle/ruby/2.1.0/bundler/gems/postgres_to_redshift-1cf00b46e712/lib/postgres_to_redshift.rb:24:in `each' /home/deploy/apps/vydia/shared/bundle/ruby/2.1.0/bundler/gems/postgres_to_redshift-1cf00b46e712/lib/postgres_to_redshift.rb:24:in `update_tables'``` on ruby 2.1.9 directly using...

dingn1

print Redshift loading error

7

#3 - [x] print Redshift loading error as applicable. - [x] fix a few lints (single quote etc) according to rubocop. - [x] expose an optional flag to ignore error...

jhuangtw

handle PG::InternalError in input.

1

select last load error from redshift from stl_load_errors

toothrot

Invalid connection! (PG::Error)

2

I get the error `Invalid connection! (PG::Error)` from the Postgres source database with a large table that is about 33GB. After about 40 minutes, it gives the following error: ```...

ashawley