I seemed to have walked into a "spirited" debate at work today, so I'm turning
to the authorities to get it resolved. Why would one choose -Ft over -Fc (or
vice-versa) when doing pg_dump? Is there truly any difference of note
(outside the formats themselves)?
Thanks
--
Douglas
to choose it without a specific need to. I think it has some
> other limitations too, but those are two that I recall immediately.
Excellent. Pretty much closes the debate here. Thx Tom
--
Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778
http://doug.hunley.homeip.net
"She&
gt; ** **
>
> Marc
>
http://www.postgresql.org/docs/9.2/static/functions-matching.html
--
Douglas J Hunley (doug.hun...@gmail.com)
Twitter: @hunleyd Web:
douglasjhunley.com
G+: http://goo.gl/sajR3
On Tue, Apr 2, 2013 at 10:29 AM, David Guyot (English) <
david.gu...@europecamions-interactive.com> wrote:
> restore_command = 'rsync -av 192.168.0.80:/var/lib/postgresql/WAL/%f %p'
>
You're telling the recovery process to get the files off the (now dead)
master her
for the day-to-day standby service?
If you're going to do WAL shipping, your 'archive_command' on the master
needs to be copying over to the standby (rsync or whatever). Then the
standby's recovery.conf would be a simple 'cp /path/to/wal-archive' type of
command.
this line useless for the day-to-day standby service?
>
This might help (just stop before the cascade stuff)
http://bartek.im/blog/2012/12/04/postgresql-92-streaming-primer.html
--
Douglas J Hunley (doug.hun...@gmail.com)
Twitter: @hunleyd Web:
dou
