Diferencia entre revisiones de «Usuario:Lmorillas/postgresql»
De WikiEducator
(Página creada con '{{MiTitulo|Intro Postgreql}} {{Conocimiento previo|Title=Primeros pasos| * http://www.postgresql.org.es/documentacion sudo apt-get install postgresql pgadmin3 sudo -u po…') |
|||
| Línea 10: | Línea 10: | ||
/password | /password | ||
| + | |||
| + | postgres=# alter user postgres with password ‘nueva contraseña’; | ||
}} | }} | ||
| + | |||
| + | |||
| + | sudo -u postgres createuser myusername | ||
| + | Shall the new role be a superuser? (y/n) y | ||
| + | |||
| + | createdb book | ||
| + | |||
| + | psql book -c "CREATE EXTENSION tablefunc" | ||
| + | ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/tablefunc.control": No such file or directory | ||
| + | |||
| + | sudo apt-get install postgresql-contrib | ||
| + | |||
| + | psql book -c "CREATE EXTENSION tablefunc" | ||
| + | psql book -c "CREATE EXTENSION fuzzystrmatch" | ||
| + | psql book -c "CREATE EXTENSION pg_trgm" | ||
| + | psql book -c "CREATE EXTENSION cube" | ||
| + | psql book -c "CREATE EXTENSION dict_xsyn" | ||
Revisión de 19:31 27 nov 2012
| {{{1}}} |
sudo -u postgres createuser myusername Shall the new role be a superuser? (y/n) y createdb book
psql book -c "CREATE EXTENSION tablefunc" ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/tablefunc.control": No such file or directory
sudo apt-get install postgresql-contrib
psql book -c "CREATE EXTENSION tablefunc" psql book -c "CREATE EXTENSION fuzzystrmatch" psql book -c "CREATE EXTENSION pg_trgm" psql book -c "CREATE EXTENSION cube" psql book -c "CREATE EXTENSION dict_xsyn"
