Search Postgresql Archives

Archive command seem to be working.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi, hoping someone can tell me how to get this running again.
 
I have pitr running and noticed that the slave is far out of date with wal logs.
 
Upon investigation I see that on the master that /data/pgsql/backups/wal_logs has over 6000 logs that haven't been moved
to the /var/lib/pgsql/backups/wal_arch/ folder.
 
The root partition that has /var had been full and logs may have been removed, and it may have run some time in this condition until someone corrected it.
 
postgresql.conf file.
test ! -f /data/pgsql/backups/wal_arch/%f.gz && cp %p  /var/lib/pgsql/backups/wal_arch/%f
 
Is there a way to restart a service without taking the database down/up?
 
Any help would be appreciated.
 
Cheers,
 
Chris Barnes


Windows Live: Make it easier for your friends to see what you’re up to on Facebook.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux