How to manage WAL

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

 



Hi all

I would like to known what's best way to manage the WAL. 

Let's me explain : 

	at beginning I do something like

		psql -c "select pg_start_backup('complete');"
		rsync /pgsql backup_server:
		psql -c "select pg_stop_backup();"

and I backup /WAL directory but after sometime the /WAL directory 
become big. So can I do something like
	
	postgresql stop
	rm /WAL/*
	postgresql start
	psql -c "select pg_start_backup('complete');"
	rsync /pgsql backup_server:
	psql -c "select pg_stop_backup();"

and continu to backup /WAL ? 

Regards.

JAS
		
-- 
Albert SHIH
SIO batiment 15
Observatoire de Paris Meudon
5 Place Jules Janssen
92195 Meudon Cedex
Heure local/Local time:
Jeu 11 fév 2010 23:28:31 CET

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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux