I just mounted and configured my brand new LSI 3008-8i. This server had 1 SAS
expander connected to 2 backplanes (8 disks to the first backplane and no disks
connected to the second backplane). After some testing I found the SAS expander
was a bottleneck, so I removed it and connected the first
Hi Rick,
You Always have a doubt, if backup is full and done.
In my case, I have one Client using a large database, and the base in mysql, an
when we stop traffic about 8:00PM start a lot of routines. I have about 2hours
of Exclusive lock.
For solve one problem like these in this Client. We
May you please share what types of check if there to guarantee the backup is
trustworthy.
Regards,
Dinesh Chandra
|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.
From: l...@laurent-hasson.com [mailto:l...@laurent-hasson.com]
Sent: 02 March, 2017 9:57 PM
To: Rick Otten ; Dinesh Ch
It'd be so nice to have some checks to guarantee the backup is trustworthy.
Restoring the db is imho not a very good option in general:
- large databases are a problem. My db is about 3TB. Time plus disk space is a
big blocker.
- also, what if the backup is incomplete? Just restoring the db suc
Dear Rick,
Thanks for your valuable reply.
But the daily restoration of backup to another database is really so time
consuming because our databases size is greater than 2TB.
Regards,
Dinesh Chandra
|Database administrator (Oracle/PostgreSQL)|
From: Rick Otten [mailto:rottenwindf...@gmail.com]
This reminds me - I have had a case where the exit code for pg_dump was
successful, but the backup was still corrupted on disk. By all means check
the exit code, but I strong encourage a second validation, such as the
index listing, to increase your confidence that the backup was successful.
The
Hi,
When I issue the bleow command
> ./bin >pg_dump -U dummy_user dummy_database; echo $?
I checked with Linux TOP command on the same server, it was showing COPY
database.
What exactly it doing ??
Regards,
Dinesh Chandra
-Original Message-
From: vinny [mailto:vi...@xs4all.nl]
Sent:
