Due to Hard disk space issue on the WAL partition, database was down , When I
am going to start postgres again ,got following error message
This DB is grater than 1 TB restore will take long time , any other way
other than pg_resetxlog ?
Nov 14 04:32:41 dbname postgres[4384]: [2-1] 2011-11-14
2011/11/13 Jean-Armel Luce :
> Hi Jerry and Kevin,
>
> Thanks for your answers.
>
> Jerry, I tried as you said with the parameter recovery_target_timeline =
> 'latest' and it works.
>
> I tried on a smaller test database (only 15MB) with PG9.1.1 and only 1
> slave.
>
> My switchover procedure was :
Hi all,
I am migrating a database with tables that contain over 5M rows. These tables
are truncated and filled each day in a batch process. There are scripts that
simply don't run within 24hrs if the statistics are incorrect.
The current procedure is to run the process until it fails, then anal
Hi,
I tried many times with different options of rsync :
with rsync -a as explained in the wiki (
http://www.postgresql.org/docs/9.0/interactive/warm-standby.html#STANDBY-SERVER-SETUP),
it takes 1h40 for each distant slave and quite all data files are
transferred
with -c (checksum) or -z (compress
On Nov 14, 2011, at 10:59 AM, Jean-Armel Luce wrote:
> just for the value : rsync --checksum is the option to use to prevent
> copying of identical files
No, that's not what it's used for. It already avoids sending identical blocks
by using checksums. --checksum forces a checksum on files that h
I think there have been two similar threads recently, and I want to be sure I'm
not confusing them. So:
- How large is the db? By which I mean how much disk space does the data
directory occupy?
- What's the bandwidth of the network connection to the distant slave?
- What's the CPU & disk on e
Hi folks,
My server has a daily routine to import a dump file, however its taking
long time to finish it.
The original db has around 200 MB and takes 3~4 minutes to export (there
are many blob fields), however it takes 4 hours to import using pg_restore.
What can I do to tune this database to spe
