Skip to content

Instantly share code, notes, and snippets.

@damaya

damaya/postgre inyect

Created February 14, 2017 12:51
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save damaya/5760bc8ef9793258b8e07a72b36f41ba to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save damaya/5760bc8ef9793258b8e07a72b36f41ba to your computer and use it in GitHub Desktop.
Download ZIP
Operaciones postgre
Raw
postgre inyect
1. Log into postgre: sudo su - postgres
2. create db: createdb newdb
3. Inyect db psql worlddb < world.sql
---
Ingres to specific db, specific user
psql --username=awx --password --dbname=awx
Dumb database
pg_dump --username=awx --password --dbname=awx > /tmp/awx-tower.sql
@damaya

damaya commented Sep 6, 2017

Copy link
Copy Markdown
Author

IMPORTANTE: Cuando se vaya a inyectar una DB en un tower actualizado, se usa:

  1. Ubicar el .tar.gz de la DB backupeada
  2. Ejecutar: sudo ./setup.sh -r

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment