Tom Lane wrote:
>
> Joseph Shraibman <jks@selectacast.net> writes:
> > Could a command be added that locks all the files, quickly tars them
> > up, then releases the lock?
>
> pg_ctl stop
> tar cfz - $PGDATA >someplace
> pg_ctl start
>
But that would mean I would have to have all my programs detect that the
database went down and make new connections. I would rather that
postgres just lock all the files and do the tar.
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com