I will install, configure, and optimize your postgresql database
About this Gig
Are you setting up a new PostgreSQL database and want it done right from day one?
A poorly configured database can lead to slow queries, security vulnerabilities, and data loss. I am Guillermo, a Senior Database Administrator specialized in Linux environments (Ubuntu/CentOS) and robust data architectures. I will ensure your PostgreSQL instance (v11 to v17) is secure, highly performant, and ready to scale.
What can I do for you in this Gig?
- Clean Installation: Setup of PostgreSQL on your Linux server.
- Security Configuration: Setup of pg_hba.conf, firewall rules, and secure user roles/permissions to keep your data safe.
- Performance Tuning: Custom configuration of postgresql.conf based on your hardware resources (RAM, CPU, storage) and expected workload.
- Backup Strategy: Implementation of automated backups. For enterprise setups, I configure Barman for robust Disaster Recovery.
- Monitoring Setup: (Premium Package) Integration with Prometheus, Grafana, or Monit so you have full visibility of your server's health.
Why choose me? I don't just click "next". I have deep expertise handling mission-critical environments, large-scale migrations (handling terabytes of data), and complex archite
Database type:
Relational database
FAQ
Do you support any specific Linux distributions?
Yes, I specialize in Ubuntu and CentOS environments, but I can work with most major Linux distributions.
Can you help me migrate data from an old database?
Yes! I have extensive experience in data migrations (including legacy systems like Informix to PostgreSQL and logical replication between Postgres versions). However, data migration is a separate service. Please send me a message for a custom quote!
How do you handle backups in the Premium package?
I implement Barman (Backup and Recovery Manager), which is an enterprise-grade tool for disaster recovery, ensuring your data is backed up safely and can be restored precisely.
