Haha :D On Tue, Dec 17, 2019 at 10:02 PM Jarek Potiuk <[email protected]> wrote:
> Wow. Now I have a new name for you - "Kaxil Hawkeye". It took me a minute > or so looking at it and I could not see the difference between the two... > > Human mind plays weird tricks :). > > J. > > On Tue, Dec 17, 2019 at 10:47 PM Reed Villanueva <[email protected]> > wrote: > >> wow thanks >> >> On Tue, Dec 17, 2019 at 11:45 AM Kaxil Naik <[email protected]> wrote: >> >>> That is because you have a typo :) in your airflow.cfg file >>> >>> *Your have following:* >>> >>> sql_alchemy_conn = >>> postgresql+pyscopg2://airflow:mypassword@localhost:5432/airflow >>> >>> >>> *Update it to:* >>> >>> sql_alchemy_conn = >>> postgresql+psycopg2://airflow:mypassword@localhost:5432/airflow >>> >>> >>> Note the spelling of *pyscopg2* >>> >>> Regards, >>> Kaxil >>> >>> >>> On Tue, Dec 17, 2019 at 9:37 PM Reed Villanueva <[email protected]> >>> wrote: >>> >>>> Attempting to set up airflow (v1.10.5) in a centos7 machine to use >>>> LocalExecutor following the article here ( >>>> https://www.ryanmerlin.com/2019/07/apache-airflow-installation-on-ubuntu-18-04-18-10/), >>>> so have settings... >>>> >>>> [airflow@airflowetl airflow]$ rpm -q postgresql-server postgresql >>>> postgresql-devel >>>> postgresql-server-9.2.24-1.el7_5.x86_64 >>>> postgresql-9.2.24-1.el7_5.x86_64 >>>> postgresql-devel-9.2.24-1.el7_5.x86_64 >>>> >>>> [airflow@airflowetl airflow]$ pip3 freeze | grep sqlalchemy >>>> marshmallow-sqlalchemy==0.19.0[airflow@airflowetl airflow]$ pip3 freeze | >>>> grep psycopg2 >>>> psycopg2==2.8.4 >>>> >>>> >>>> [airflow@airflowetl airflow]$ psql airflow >>>> psql (9.2.24)Type "help" for help. >>>> >>>> airflow=> \l >>>> List of databases >>>> Name | Owner | Encoding | Collate | Ctype | Access >>>> privileges-----------+----------+----------+-------------+-------------+----------------------- >>>> airflow | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | >>>> =Tc/postgres + >>>> | | | | | >>>> postgres=CTc/postgres+ >>>> | | | | | >>>> airflow=CTc/postgres >>>> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | >>>> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres >>>> + >>>> | | | | | >>>> postgres=CTc/postgres >>>> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres >>>> + >>>> | | | | | >>>> postgres=CTc/postgres(4 rows) >>>> >>>> >>>> [root@airflowetl airflow]# cat /var/lib/pgsql/data/pg_hba.conf....# TYPE >>>> DATABASE USER ADDRESS METHOD >>>> # "local" is for Unix domain socket connections onlylocal all >>>> all peer# IPv4 local >>>> connections:#host all all 127.0.0.1/32 >>>> ident >>>> host all all 0.0.0.0/0 trust# >>>> IPv6 local connections: >>>> host all all ::1/128 ident# >>>> Allow replication connections from localhost, by a user with the# >>>> replication privilege.#local replication postgres >>>> peer#host replication postgres 127.0.0.1/32 >>>> ident#host replication postgres ::1/128 >>>> ident >>>> >>>> >>>> [root@airflowetl airflow]# cat /var/lib/pgsql/data/postgresql.conf....# — >>>> — — — — — — — — — — — — — — — — — — — — — — — — — — — — # CONNECTIONS AND >>>> AUTHENTICATION# — — — — — — — — — — — — — — — — — — — — — — — — — — — — — >>>> # — Connection Settings -#listen_addresses = ‘localhost’ # what IP >>>> address(es) to listen on; >>>> listen_addresses = ‘*’ # for Airflow connection >>>> >>>> >>>> [airflow@airflowetl airflow]$ cat airflow.cfg....[core]....# The executor >>>> class that airflow should use. Choices include >>>> >>>> > > -- > > Jarek Potiuk > Polidea <https://www.polidea.com/> | Principal Software Engineer > > M: +48 660 796 129 <+48660796129> > [image: Polidea] <https://www.polidea.com/> > >
