Traza:

Diferencias

Muestra las diferencias entre dos versiones de la página.

Enlace a la vista de comparación

Ambos lados, revisión anteriorRevisión previa
Próxima revisión		Revisión previa
postgresql [2024/08/29 19:34] – [a. Cambiar el dueno de unas tablas] kasandrapostgresql [2024/10/17 20:58] (actual) – kasandra
Línea 95: Línea 95:
 Use la siguiente sentencia: Use la siguiente sentencia:
  
-    for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" orfeodb` ; do\\ +    for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" orfeodb` ; do 
-    echo "psql -c alter table $tbl owner to orfeousr orfeodb"\\ +      echo "psql -c alter table $tbl owner to orfeousr orfeodb" 
-    psql -c "alter table $tbl owner to orfeousr" orfeodb\\+      psql -c "alter table $tbl owner to orfeousr" orfeodb
     done\\     done\\
-    for tbl in `psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" orfeodb` ; do\\ +    for tbl in `psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" orfeodb` ; do 
-    echo "psql -c alter table $tbl owner to orfeousr orfeodb "\\ +      echo "psql -c alter table $tbl owner to orfeousr orfeodb " 
-    psql -c "alter table $tbl owner to orfeousr" orfeodb\\+      psql -c "alter table $tbl owner to orfeousr" orfeodb
     done\\     done\\
-    for tbl in `psql -qAt -c "select table_name from information_schema.views where table_schema = 'public';" orfeodb` ; do\\ +      for tbl in `psql -qAt -c "select table_name from information_schema.views where table_schema = 'public';" orfeodb` ; do 
-    echo  "psql -c alter table $tbl owner to orfeousr orfeodb"\\ +      echo  "psql -c alter table $tbl owner to orfeousr orfeodb" 
-    psql -c "alter table $tbl owner to orfeousr" orfeodb\\+      psql -c "alter table $tbl owner to orfeousr" orfeodb
     done\\     done\\
-  
  
 ==== b. Crear usuario Read/Only  ==== ==== b. Crear usuario Read/Only  ====
Línea 126: Línea 125:
 https://www.hostinger.com/tutorials/how-to-install-postgresql-on-centos-7/\\ https://www.hostinger.com/tutorials/how-to-install-postgresql-on-centos-7/\\
  
-==== c. Instalacion versiones viejas Ubutu ====+==== c. Instalacion versiones viejas Ubuntu ==== 
 + 
 +En esencia .. descargue y compile 
 + 
 +Las instrucciones 
 +https://stackoverflow.com/questions/39737568/install-older-versions-of-postgres7-x-or-8-x-in-ubuntu 
 + 
 +Los fuentes 
 +https://ftp.postgresql.org/pub/source/ 
 + 
 +==== d. Restore un dump binario ==== 
 + 
 +    pg_restore --clean --no-acl --no-owner -d <database> -U <user> <filename.dump>
  
  
Volver arriba