Diferencia entre revisiones de «Sysadmin»

De Furilo
Ir a la navegación Ir a la búsqueda
Línea 2: Línea 2:
  
 
mysqldump -u USER -p your_database_name  | gzip >  your_database_name.sql
 
mysqldump -u USER -p your_database_name  | gzip >  your_database_name.sql
 +
 +
== Postgresql ==
 +
 +
* Start server in OS X: pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
 +
* Stop: pg_ctl -D /usr/local/var/postgres stop -s -m fast
 +
* Create user: createuser USER
  
 
== Rails in production ==  
 
== Rails in production ==  

Revisión del 18:16 4 mar 2015

MySQL backups

mysqldump -u USER -p your_database_name | gzip > your_database_name.sql

Postgresql

  • Start server in OS X: pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
  • Stop: pg_ctl -D /usr/local/var/postgres stop -s -m fast
  • Create user: createuser USER

Rails in production

SSH

Change default SSH port + Prevent root user from loging in via SSH

vi /etc/ssh/sshd_config
PermitRootLogin no
Port 50683
/etc/init.d/ssh restart
ssh [email protected] -p 50683

Problems installing gems in Mac OS X

If error:

clang: error: unknown argument: '-multiply_definedsuppress' [-Wunused-command-line-argument-hard-error-in-future]


Solution

ARCHFLAGS=-Wno-error=unused-command-line-argument-hard-error-in-future gem install ...