Abdellah SABIR sabirab2
pixeline
/ mirror_remote_directory_to_local_directory
Last active
May 21, 2024 19:36
Bash script using lftp to mirror remote directory to local directory, thus keeping the local directory synchronized with the remote one.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| # @author: Alexandre Plennevaux | |
| # @description: MIRROR DISTANT FOLDER TO LOCAL FOLDER VIA FTP | |
| # | |
| # FTP LOGIN | |
| HOST='sftp://ftp.domain.com' | |
| USER='ftpusername' | |
| PASSWORD='ftppassword' | |
| # DISTANT DIRECTORY |
rgreenjr
/ postgres_queries_and_commands.sql
Last active
May 8, 2025 09:19
Useful PostgreSQL Queries and Commands
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |