Lang MengHow to load the CSV data to PostgreSQL via dbt (Data Build Tool)How to loading the data from CSV file to PostgreSQL on Ubuntu 20.04Jan 8, 2022Jan 8, 2022
Lang MengHow to import the data to PostgreSQL from CSV file (Upload by User in SFTP)Jan 7, 2022Jan 7, 2022
Lang MengHow to install Airflow on Ubuntu 20.04postgres@SecondaryDataUse:~$ FILE=/home/lang/Student_From_Lang.csv postgres@SecondaryDataUse:~$ if test -f “$FILE”; then echo “$FILE…Jan 6, 2022Jan 6, 2022
Lang MengThe Linux shell for copy the data from CSV to PostgreSQLpostgres@SecondaryDataUse:~$ FILE=/home/lang/Student_From_Lang.csv postgres@SecondaryDataUse:~$ if test -f “$FILE”; then echo “$FILE…Jan 6, 2022Jan 6, 2022
Lang MengHow to add User Postgres to Root group in Linus Ubuntu 20.4root@SecondaryDataUse:~# su — postgres postgres@SecondaryDataUse:~$ groups postgres ssl-cert postgres@SecondaryDataUse:~$ exit logout…Jan 6, 2022Jan 6, 2022
Lang MengInstall PostgreSQL in Linux Ubuntu20.04sudo sh -c ‘echo “deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main” > /etc/apt/sources.list.d/pgdg.list’ wget —…Jan 5, 2022Jan 5, 2022
Lang MengSetup SFTP Server UbuntuData security and credentials encryption are the thumb rules for a system administrator. FTP (File Transfer Protocol) is great for…Jan 5, 2022Jan 5, 2022