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 <rvillanu...@ucera.org> wrote: > wow thanks > > On Tue, Dec 17, 2019 at 11:45 AM Kaxil Naik <kaxiln...@gmail.com> 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 <rvillanu...@ucera.org> >> 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/>
