Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    mase - meat popsicle
    @mase_nocturnal_twitter
    I am not really sure how to proceed from here
    can anyone give any guideance ?
    mase - meat popsicle
    @mase_nocturnal_twitter
    @mcgri Yes, I'm currently battling another issue, but I got past that stage
    is it possible for me to choose which mssql (src) columns I want to include ?
    mase - meat popsicle
    @mase_nocturnal_twitter
    anyone.... ?
    Dario Frongillo
    @esoni
    HI All
    @dimitri i love your postgres book :D
    hey guys .. i m reading a field of a csv that have this format 999999999D99 and it use as thousand separator the char , and for decimal the point
    is there a way to transform it in number during an import csv ?
    Dario Frongillo
    @esoni
    hi all, someone can help me in this issue dimitri/pgloader#1192 ?
    Keerthikan Ratnarajah
    @Keerthikan
    is this active?
    Benjamin David
    @benmod_gitlab
    Hey! I'm having this error "there is no unique constraint matching given keys for referenced table" when trying to load form SQLite to Postgres
    but there is the proper constraint in sqlite
    so I dont understand
    Benjamin David
    @benmod_gitlab
    It seems that the primary keys are not migrated
    hence causing the issues
    or the Unique constraint of the primary key is not passed
    is there any wya to force that?
    I looked over the whole doc and cant find it
    Benjamin David
    @benmod_gitlab
    here's my empty DB
    just migrating the schema fails
    whereas its pretty straightforward
    Rekha
    @rkhandha
    Hi I am trying to load data from MS SQL server to Postgres, both password have special characters, for postgres I am using PGPASSWORD environment variable , what is the environment variable for MSSQL server password it tried PWD, PASSWORD it does not work
    Manoj Jadhav
    @manorajjadhav_twitter

    HI All,

    I am facing this issue?

    29: (SB-THREAD::CALL-WITH-MUTEX #<CLOSURE (FLET SB-THREAD::WITH-MUTEX-THUNK :IN SB-THREAD::INITIAL-THREAD-FUNCTION-TRAMPOLINE) {7FFFF4DAED4B}> #<SB-THREAD:MUTEX "thread result lock" owner: #<SB-THREAD:THREAD "lparallel" RUNNING {1008920D03}>> NIL T NIL)
    30: (SB-THREAD::INITIAL-THREAD-FUNCTION-TRAMPOLINE #<SB-THREAD:THREAD "lparallel" RUNNING {1008920D03}> NIL #<CLOSURE (LAMBDA NIL :IN BORDEAUX-THREADS::BINDING-DEFAULT-SPECIALS) {1008920CAB}> NIL)
    31: ("foreign function: call_into_lisp")
    can any one guide me here?
    ariel yosef
    @arielyosef4_twitter
    hello everyone
    so i'v tried use pgloader and i have problem that mysql wont let me pass the password Visible
    any suggestion on how to pass the password without be Visible?
    duconja
    @duconja
    is there a way to load mysql dump to postgresql with pgloader?
    Wagner Caixeta
    @platbr
    Hi, I have a messed table, some rows were inserted using latin1 and others were windows-1252. How can i apply my pgsql function for each varchar/text columns on import?
    CREATE OR REPLACE FUNCTION fix_text_encoding(text) returns text AS 
    $$
    BEGIN
      RETURN convert_from(convert_to($1, 'latin1'), 'utf8');
    EXCEPTION
        WHEN sqlstate '22P05' THEN
      RETURN convert_from(convert_to($1, 'windows-1252'), 'utf8');
    END;
    $$
    language plpgsql immutable;
    Is possible to use this fix_text_encoding? Or do I need to convert it to LISP? I know nothing about LISP =)
    Chr3is
    @Chr3is
    Hey, when trying to execute pgloader to migrate a mariadb to posgres I receive following error: "ERROR Database error 42703: column "adsrc" does not exist" I'm using pgloader v3.6.1 - PostgreSQL 13.2
    Tatzlwurm Eads
    @tatzlwurm2:matrix.org
    [m]
    Hi, I have lots of columns that are like this "is_nonconcurrent character varying(1),", they are boolean but can't seem to get pgloader syntax right. I can workaround by altering columns post migration like : alter table acq.qrtz2_job_details alter is_durable type boolean using is_durable::boolean;
    Tatzlwurm Eads
    @tatzlwurm2:matrix.org
    [m]
    Sorry trying to migrate mysql -> postgresql.
    Tatzlwurm Eads
    @tatzlwurm2:matrix.org
    [m]
    nm figured out:CAST type varchar when (= precision 1) to boolean drop typemod
    pgloader
    @pgloader
    I was trying to build pgloader-3.6.2 on RHEL 7 and got following errors

    mkdir -p build
    curl -o build/quicklisp.lisp http://beta.quicklisp.org/quicklisp.lisp
    % Total % Received % Xferd Average Speed Time Time Time Current
    Dload Upload Total Spent Left Speed
    100 3628 100 3628 0 0 521k 0 --:--:-- --:--:-- --:--:-- 708k
    sbcl --noinform --no-sysinit --no-userinit --load build/quicklisp.lisp \
    --load src/getenv.lisp \
    --eval '(quicklisp-quickstart:install :path "build/quicklisp" :proxy (getenv "http_proxy"))' \
    --eval '(quit)'
    While evaluating the form starting at line 1, column 0
    of #P"/var/opt/mwang/pgloader/pgloader-3.6.2/build/quicklisp.lisp":

    debugger invoked on a UNBOUND-VARIABLE in thread

    <THREAD "main thread" RUNNING {9461061}>:

    The variable <!DOCTYPE is unbound.

    Type HELP for debugger help, or (SB-EXT:EXIT) to exit from SBCL.

    restarts (invokable by number or by possibly-abbreviated name):
    0: [RETRY ] Retry EVAL of current toplevel form.
    1: [CONTINUE] Ignore error and continue loading file "/var/opt/mwang/pgloader/pgloader-3.6.2/build/quicklisp.lisp".
    2: [ABORT ] Abort loading file "/var/opt/mwang/pgloader/pgloader-3.6.2/build/quicklisp.lisp".
    3: Ignore runtime option --load "build/quicklisp.lisp".
    4: Skip rest of --eval and --load options.
    5: Skip to toplevel READ/EVAL/PRINT loop.
    6: [EXIT ] Exit SBCL (calling #'EXIT, killing the process).

    (SB-INT:SIMPLE-EVAL-IN-LEXENV <!DOCTYPE #<NULL-LEXENV>)
    0]

    What could be wrong?
    avnxxi
    @avnxxi

    Hi! I'm trying to migrate from one PostgreSQL DB to another with simple script:

    LOAD database
    FROM postgresql://user:password@psql/db1
    INTO postgresql://user:password@psql/db2
    CAST type mchar to char,
    type mvarchar to text drop typemod
    ALTER SCHEMA 'public' RENAME TO 'db1'
    ;

    Error dropped:

    {10066D8CB3}>
    KABOOM!
    FATAL error: The value
    NIL
    is not of type
    PGLOADER.CATALOG:COLUMN
    An unhandled error condition has been signalled:
    The value
    NIL
    is not of type
    PGLOADER.CATALOG:COLUMN

    What I am doing here?

    The value
    NIL
    is not of type
    PGLOADER.CATALOG:COLUMN

    Linux OpenSuse pgloader 3.6.2
    PostgreSQL 10.6
    6322 tables were created as I see.

    Sicheng Hao
    @sichenghao_gitlab
    Does anyone know how can I use pgloader to load a list of tables? I was thinking of writing a loop but not sure how to do that with pgloader. Thanks!
    Aaron William West
    @tallpeak
    ..can I use pgloader to load a list of tables? ..
    my last config file for pgloader has a list of statements like this:
    INCLUDING ONLY TABLE NAMES LIKE 'tbl_dma_regions' IN SCHEMA 'dbo'
    INCLUDING ONLY TABLE NAMES LIKE 'tbl_Plan_Contacts' IN SCHEMA 'dbo'
    ..
    hainantao
    @hainantao
    not finding that in the documentation, can anyone tell me if an after load EXECUTE sql script can contain SQL block such as DO begin...end; begin ... end;? or only straight SQL only?
    the script script containing the SQL block works by itself at the psql command line.
    alewmt
    @alewmt
    Hi! is it possible to just create migration script with schema only without applying it to destination database?