Traza: • postgresql

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:28] – kasandrapostgresql [2024/10/17 20:58] (actual) – kasandra
Línea 96: Línea 96:
  
     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 130: 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