Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Focus > Postgres > Flashcards

Postgres Flashcards

1
Q

Crear una base datos postgres
Eliminar una base datos postgres

A

createdb
dropdb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Crear un usuario
Eliminar un usuario

A

createuser
dropuser

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Backup de una bbdd concreta

A

pg-dump nombrebbdd>fichero.bkp

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Backup de todas las BBDD

A

pg-dumpall>fichero.bkp

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Copia remota

A

pg-dump -U (user) -h (host) -p (port) nombrebbdd>fichero.bkp

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Restauración backup

A

pg-restore
psql nombrebbdd<fichero.bkp (si es formato SQL)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Limpiar y analizar una BBDD

A

vacuumdb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly

Focus (38 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions