pgloader

pgloader copied to clipboard

invalid input syntax for type timestamp from SQLite to Postgres

2

Followed #1177 suggestion: build from latest sources Still having `invalid input syntax for type timestamp` error Tried both versions pgloader version "3.6.3~devel" compiled with SBCL 2.1.1.debian pgloader version "3.6.a94a0a3" compiled...

AruMoon

pgloader 10 fell through ECASE expression

30

**pgloader** ``` pgloader --version pgloader version "3.6.2" compiled with SBCL 1.4.0-1.el7 ``` ``` LOAD database from mysql://user1:_{blabla}[email protected]:3306/hshub_epg_dev into postgresql://user2:_{password}[email protected]:9999/dbhula_hb AFTER LOAD DO $$ alter schema dbhula_hb_dev rename to dbhula_hb; $$...

alexsysm

Sqlite to postgres load killed

2

I am using pgloader version "3.6.1" compiled with SBCL 1.4.0-1.el7 to import the [Who's On First postcode sqlite database](https://data.geocode.earth/wof/dist/sqlite/whosonfirst-data-postalcode-latest.db.bz2) which is stored locally into "PostgreSQL 11.7 on x86_64-pc-linux-gnu, compiled by...

poshest

- [ ] pgloader --version ``` 3.6.a94a0a3 ``` - [ ] did you test a fresh compile from the source tree? yes - [ ] did you search for other...

kingwilly71

Fix broken compilation on M1 macs - sbcl is loading libcrypto in unsafe way

3

```bash Last 15 lines from /Users/patryk/Library/Logs/Homebrew/pgloader/01.make: --load local-projects/pgloader-3.6.2/src/hooks.lisp \ --load-system pgloader \ --eval '(setf pgloader.params::*version-string* "3.6.2")' \ --entry pgloader:main \ --dynamic-space-size 4096 \ --compress-core \ --output bin/pgloader.tmp ;; loading system...

memegauste

An unhandled error condition has been signalled: At end of input

4

Hi Dimitri, I am new to this pgloader, I have successfully tested the migration of mysql to postgresql with some of the examples presented. Similiarly, I am testing out the...

gvijay07

Pgloader - MSSQL to Postgres (YB) throwing TDS_MAX_CONN error

5

Thanks for contributing to [pgloader](https://pgloader.io) by reporting an issue! Reporting an issue is the only way we can solve problems, fix bugs, and improve both the software and its user...

seethb

Thanks for contributing to [pgloader](https://pgloader.io) by reporting an issue! Reporting an issue is the only way we can solve problems, fix bugs, and improve both the software and its user...

persank

Wondering how I can get around having pgloader handle whitespace, trying to quote {{VAR}} doesn't seem possible.

nwmcsween

Hi Dimitri, I'm currently evaluating PGLoader 3.6.3 on : Oracle Linux 8.5 I am trying to migrate a MS SQL Server to postgres. I first ran ./bootstrapCentos7.sh that installed all...

CyrusII