Skip to content

Instantly share code, notes, and snippets.

Pablo Caro pcaro

Block or report user

Report or block pcaro

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@pcaro
pcaro / gist:4202916
Created Dec 4, 2012
Fabric posrgres tunning
View gist:4202916
def postgres_tunning(pgversion=9.1):
# Use postgres conservative values, for about 1GB RAM machine
# Following ideas from:
# * http://www.juancarlosmoral.es/postgresql-hardware-tunning
# * http://doc.nuxeo.com/display/ADMINDOC/Configuring+PostgreSQL#ConfiguringPostgreSQL-Performancetuning
# * http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server/es
fabtools.require.service.started("postgresql")
postgresql_conf = "/etc/postgresql/%s/main/postgresql.conf" % pgversion
View Better pg_dumpall (separated files)
#!/bin/bash
# Puedes ver la fecha de la fecha en la cabecera de los .sqlc:
# pg_restore -l backupu.sqlc | head -n 15
# Echo: "Ejecutar este script como usuario con permisos (postgres)"
BKPDIR=postgres-backup-${DATE}
RSTFILE=restore.README
USER=postgres
You can’t perform that action at this time.