To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
From: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
Message-ID: <559FC1A4.10302@exxoss.com>
Date: Fri, 10 Jul 2015 14:59:16 +0200
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0)
 Gecko/20100101 Thunderbird/38.0.1
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Automatic restore corruption problem
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi all,

I have a script for restoring a database every night to an other 
postgresql database

root@p2prddnmdbc:~# cat /var/admin/script/restoredb.sh
#/bin/bash
/etc/init.d/postgresql stop
mv /var/log/postgresql/postgresql-9.3-main.log 
/var/log/postgresql/postgresql-9.3-main.log.old
cd /var/lib/postgresql/9.3/main
psql --host=p2prddnmdbm --username=replicator postgres -c "SELECT 
pg_start_backup('sync');"
rsync -av --delete root@10.10.11.1:/var/lib/postgresql/9.3/main/* 
/var/lib/postgresql/9.3/main/
rm backup_label
chown -R postgres:postgres *
psql --host=p2prddnmdbm --username=replicator postgres -c "SELECT 
pg_stop_backup();"
/etc/init.d/postgresql start
chmod 777 /var/log/postgresql/postgresql-9.3-main.log
psql -U postgres -c "ALTER USER xxxx WITH PASSWORD 'XXXX';"
psql -U postgres xxxx -c "CREATE EXTENSION dblink;"
root@p2prddnmdbc:~#


But during the day when the user are using the new database we got error 
like this :

2015-06-25 16:20:58 CEST ERROR:  could not read block 257985 in file 
"base/16386/14064061.1": read only 0 of 8192 bytes
2015-06-22 15:21:11 CEST ERROR:  could not read block 256801 in file 
"base/16386/14064061.1": read only 0 of 8192 bytes

I have check the : filesystem on the vm, on the HW SAN,...

Any idea to fix this problem?

Thanks

Matthieu


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin