pgbadger
SFTPGo
pgbadger | SFTPGo | |
---|---|---|
6 | 236 | |
3,386 | 8,151 | |
- | - | |
7.9 | 9.5 | |
2 months ago | 6 days ago | |
Perl | Go | |
PostgreSQL License | GNU Affero General Public License v3.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pgbadger
-
Site down due hosted on digitalocean
It might also help to use pgbadger or something similar to process your postgres logs and see whether some event is aligned with your outages.
-
SQL: 2023 Has Been Released
Interestingly, when a place does get to the point where the single instance has capacity issues (after upgrading to EPYC and lots of flash drives) then other non-obvious stuff shows up too.
For example, at one place just over a year ago they were well into this territory. One of weird problems for them was with pgBadger's memory usage (https://github.com/darold/pgbadger). That's written in perl, which doesn't seem to go garbage collection well. So even on a reporting node with a few hundred GB's of ram, it could take more than 24 hours to do a "monthly" reporting run.
There wasn't a solution in place at the time I left, so they're probably still having the issue... ;)
- Moving from Oracle to Postgres, what should I know?
-
What are the top 3 most useful things that you have hosted over the years?
First of all I used a profiler (pgbadger and netdata) to figure out where the lags were coming from. I then tried the usual stuff (increasing shared_buffers, max_wal_size, min_wal_size from their ultra low defaults), but the biggest performance gain came from moving the database from eMMC to a mechanical hard drive :-D
-
Best way to find queries that might benefit from indexes.
Look into PgBadger (a log parser/analyser): https://github.com/darold/pgbadger
SFTPGo
-
What you guys are hosting instead of Nextcloud? I'm sick of it.
EDIT: Thanks for the recommendations from all of you!! I've chose to use the below: - Files: sftpgo - Calendar: baikal - Notes: memos (But beware, it sends opt-out telemetry) - Network folder: webdav on sftpgo
-
FTP Server on Linux
Give a try to SFTPGo
-
HashiCorp Did It Backwards
> Even these projects have gotten to a level of sophistication that it would implode without big tech support.
The worst thing is that all this FAANG or VC backed companies make a lot of people believe that they are the only viable way.
> Why do you think you don't see any interesting oss tech from hobbyists is these days?
Actually not true, just an example, https://github.com/drakkan/sftpgo. But there are plenty of them.
-
Running an FTP server WITHOUT admin priveleges
This is possible using SFTPGo. The default Windows installer register SFTPGo as a Windows service. You can download the portable version and run it manually or install SFTPGo from the Scoop packages. You can use the built-in SFTPGo virtual permissions to only allow uploads. SFTPGo uses virtual users, no system users are required.
-
Do you have individuals that access a Public-Facing SFTP Server - how can you lock down the SFTP Server?
I suggest contacting your SFTP server vendor. I guess they have an auto blocking policy like this
-
Was the move to AES 256 really necessary?
Basically it's a file storage managed over HTTPS. Nextcloud is pretty heavy, that's the reason why I using just a single statically compiled cross-platform binary SFTPgo
- A lightweight nextcloud alternative
-
Simple read only ftp server
Using SFTPGo you can easily configure read-only accounts. SFTPGo uses virtual users and virtual permissions. So you don't need to create system users for your SFTPGo users and you don't need to use chmod to make folders read-only (but the system user that SFTPGo runs as needs file system level permission to access the files/folders you want to share)
-
Sftp or Sharepoint links- security
SFTPGo provides SFTP, FTP/S and HTTP/S so you can share the same files using different protocols and thus meet the different needs of your business partners. Allowed protocols can be enabled/disabled per-user
-
Pre-made solution for allowing a client to upload a file to my web hosting (via browser, not FTP client)?
You could check out SFTPGo, it may meet your needs.
What are some alternatives?
pgaudit_analyze - PostgreSQL Audit Analyzer
minio - The Object Store for AI Data Infrastructure
Mailcow - mailcow: dockerized - 🐮 + 🐋 = 💕
OpenMediaVault - openmediavault is the next generation network attached storage (NAS) solution based on Debian Linux. Thanks to the modular design of the framework it can be enhanced via plugins. openmediavault is primarily designed to be used in home environments or small home offices.
minion - :octopus: Perl high performance job queue
traefik - The Cloud Native Application Proxy
postgresqltuner - Simple script to analyse your PostgreSQL database configuration, and give tuning advice
Filestash - 🦄 A modern web client for SFTP, S3, FTP, WebDAV, Git, Minio, LDAP, CalDAV, CardDAV, Mysql, Backblaze, ...
Octopussy - Octopussy - Open Source Log Management Solution
nginx-prometheus - Turn Nginx logs into Prometheus metrics
apache2buddy - apache2buddy
nextcloud-in-docker-recipe - My cnfiguration files to run NextCloud in Docker behind Traefik