thanks a lot. One final question on this.
if the streaming fails as in our case, we missed 4 days worth of data. We
archive the log files on the primary. if we were to restart , what should
be starting the point ?
Do we need to get all the archived logs to the pg_xlogs from the date ( in
our c
On Sat, Mar 9, 2013 at 4:05 PM, akp geek wrote:
> Appreciate your findings. taking your points and doing things now. We can
> upgrade. Which version is more stable 9.2 or 9.1
They're two entirely different branches. They should both be equally
stable. However, if you're looking for the most s
Appreciate your findings. taking your points and doing things now. We can
upgrade. Which version is more stable 9.2 or 9.1
We use GIST indexes quite a bit. and we gis also
I recently compiled postgres 9.2 ..
Regards
On Sat, Mar 9, 2013 at 5:09 PM, Lonni J Friedman wrote:
> On Sat, Mar 9,
On Sat, Mar 9, 2013 at 1:51 PM, akp geek wrote:
> thank you. As you mentioned, I understood that I am starting the streaming
> scratch which is not what I wanted to do.
>
> Here is what I am planning to .
>
> Our replication process was down since March5th.
>
> 1. Is it Ok to get all wals from Mar
thank you. As you mentioned, I understood that I am starting the streaming
scratch which is not what I wanted to do.
Here is what I am planning to .
Our replication process was down since March5th.
1. Is it Ok to get all wals from March5th till now to standby pg_xlog
2. take pg_basebackup
3. exp
That process merely sets up a new server, it doesn't start streaming,
unless the server has been configured correctly. You state that the
slave crashed after two hours. How did you make this determination?
All you seem to be doing is setting up the slave from scratch
repeatedly, and assuming tha
Hi all -
I am in desperate need of your help. The replication/streaming
stopped working on March5th. I followed the following procedure to restart
the streaming. After running it for couple of hours , the database is
crashing on the slave. This is on our production server. Thanks for yo
