This file contains 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
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 |
This file contains 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/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 |