Erro ao executar script que cria backup do postgresql no ubuntu 14.04

fernando.ti
(usa Outra)

Enviado em 06/11/2016 - 13:49h

#!/bin/sh



# Script para backup dos bancos de dados



# Formata data para adicionar ao nome dos arquivos

t=`/bin/date +%d%m%y`

tt=`/bin/date +%H%M%S`







# Define o destino dos arquivos

DST="/home/fernandounix/f/$t"



# Cria o diretório do dia se ele não existir

if [ -d /home/fernandounix/f/$t ]; then

  cd /home/fernandounix/f/$t

else

`mkdir /home/fernandounix/f/$t`

fi



# Define permissoes de leitura e gravacao para o diretorio

`chown -R postgres /home/fernandounix/f/`

`chown -R postgres /home/fernandounix/f/$t`

`chmod 0777 /home/fernandounix/f/$t`



# variáveis

export PGPASSWORD="toor"



# Loop para gerar arquivos dump

for i in `psql -l -U postgres | cut -f 2 -d " " -s`; do

    if [ $i != template1 -a $i != template0 -a $i != "rows)" -a $i != postgres ]; then

         /usr/bin/pg_dump -h localhost -U postgres /$t/$i"_"$t"_"$tt.bkp;



    fi

done 

fernandounix@Host-0000:~/Escritorio$ ./backupPostgreSQL.sh

chown: cambiando el propietario de «/home/fernandounix/f/061116»: Operación no permitida

chown: cambiando el propietario de «/home/fernandounix/f/»: Operación no permitida

chown: cambiando el propietario de «/home/fernandounix/f/061116»: Operación no permitida

pg_dump: [archiver (db)] connection to database "/061116/ExcelTest_061116_134016.bkp" failed: FATAL:  database "/061116/ExcelTest_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/ProjetoVeiculos_061116_134016.bkp" failed: FATAL:  database "/061116/ProjetoVeiculos_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/aula_061116_134016.bkp" failed: FATAL:  database "/061116/aula_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/fazenda_061116_134016.bkp" failed: FATAL:  database "/061116/fazenda_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/jcsmsexpressdb_061116_134016.bkp" failed: FATAL:  database "/061116/jcsmsexpressdb_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/teste_061116_134016.bkp" failed: FATAL:  database "/061116/teste_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/teste_jsf_html5_061116_134016.bkp" failed: FATAL:  database "/061116/teste_jsf_html5_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/vendas_produto_061116_134016.bkp" failed: FATAL:  database "/061116/vendas_produto_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/webservice_061116_134016.bkp" failed: FATAL:  database "/061116/webservice_061116_134016.bkp" does not exist

 

msoliver
(usa Debian)

Enviado em 06/11/2016 - 15:58h

#!/bin/sh



# Script para backup dos bancos de dados



# Formata data para adicionar ao nome dos arquivos

t=`/bin/date +%d%m%y`

tt=`/bin/date +%H%M%S`







# Define o destino dos arquivos

DST="/home/fernandounix/f/$t"



# Cria o diretório do dia se ele não existir

if [ -d /home/fernandounix/f/$t ]; then

  cd /home/fernandounix/f/$t

else

`mkdir /home/fernandounix/f/$t`

fi



# Define permissoes de leitura e gravacao para o diretorio

`chown -R postgres /home/fernandounix/f/`

`chown -R postgres /home/fernandounix/f/$t`

`chmod 0777 /home/fernandounix/f/$t`



# variáveis

export PGPASSWORD="toor"



# Loop para gerar arquivos dump

for i in `psql -l -U postgres | cut -f 2 -d " " -s`; do

    if [ $i != template1 -a $i != template0 -a $i != "rows)" -a $i != postgres ]; then

         /usr/bin/pg_dump -h localhost -U postgres /$t/$i"_"$t"_"$tt.bkp;



    fi

done 

fernandounix@Host-0000:~/Escritorio$ ./backupPostgreSQL.sh

chown: cambiando el propietario de «/home/fernandounix/f/061116»: Operación no permitida

chown: cambiando el propietario de «/home/fernandounix/f/»: Operación no permitida

chown: cambiando el propietario de «/home/fernandounix/f/061116»: Operación no permitida

pg_dump: [archiver (db)] connection to database "/061116/ExcelTest_061116_134016.bkp" failed: FATAL:  database "/061116/ExcelTest_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/ProjetoVeiculos_061116_134016.bkp" failed: FATAL:  database "/061116/ProjetoVeiculos_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/aula_061116_134016.bkp" failed: FATAL:  database "/061116/aula_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/fazenda_061116_134016.bkp" failed: FATAL:  database "/061116/fazenda_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/jcsmsexpressdb_061116_134016.bkp" failed: FATAL:  database "/061116/jcsmsexpressdb_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/teste_061116_134016.bkp" failed: FATAL:  database "/061116/teste_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/teste_jsf_html5_061116_134016.bkp" failed: FATAL:  database "/061116/teste_jsf_html5_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/vendas_produto_061116_134016.bkp" failed: FATAL:  database "/061116/vendas_produto_061116_134016.bkp" does not exist

pg_dump: [archiver (db)] connection to database "/061116/webservice_061116_134016.bkp" failed: FATAL:  database "/061116/webservice_061116_134016.bkp" does not exist