Re: [HACKERS] Re: database system identifier differs between the primary and standby

2011-04-22 Thread Kevin Grittner
"Deka, Rajib IN MAA SL" wrote: > Finally I setup two machines for primary and backup using the > following link. > http://wiki.postgresql.org/wiki/Streaming_Replication > > But after starting the backup I got the following messages and > postgresql service doesn't start. > 2011-04-22 14:37:54

Re: [HACKERS] Re: database system identifier differs between the primary and standby

2011-04-22 Thread Deka, Rajib IN MAA SL
..@siemens.com -Original Message- From: Deka, Rajib IN MAA SL Sent: Friday, April 22, 2011 12:26 PM To: 'Cédric Villemain'; Robert Haas Cc: Simon Riggs; pgsql-hackers Subject: RE: [HACKERS] Re: database system identifier differs between the primary and standby Thanks a lot. I g

Re: [HACKERS] Re: database system identifier differs between the primary and standby

2011-04-22 Thread Deka, Rajib IN MAA SL
[mailto:cedric.villemain.deb...@gmail.com] Sent: Thursday, April 21, 2011 9:56 PM To: Robert Haas Cc: Simon Riggs; Deka, Rajib IN MAA SL; pgsql-hackers Subject: Re: [HACKERS] Re: database system identifier differs between the primary and standby 2011/4/21 Robert Haas : > On Thu, Apr 21, 2011 a

Re: [HACKERS] Re: database system identifier differs between the primary and standby

2011-04-21 Thread Deka, Rajib IN MAA SL
...@gmail.com] Sent: Thursday, April 21, 2011 8:39 PM To: Simon Riggs Cc: Deka, Rajib IN MAA SL; pgsql-hackers Subject: Re: [HACKERS] Re: database system identifier differs between the primary and standby On Thu, Apr 21, 2011 at 6:38 AM, Simon Riggs wrote: > On Thu, Apr 21, 2011 at 10:31 AM, raji

Re: [HACKERS] Re: database system identifier differs between the primary and standby

2011-04-21 Thread Cédric Villemain
2011/4/21 Robert Haas : > On Thu, Apr 21, 2011 at 6:38 AM, Simon Riggs wrote: >> On Thu, Apr 21, 2011 at 10:31 AM, rajibdk wrote: >>> What does that database system identifier means? Is it related to DB >>> transactions’ or unique to a version? >> >> Regrettably, it means you didn't follow the do

Re: [HACKERS] Re: database system identifier differs between the primary and standby

2011-04-21 Thread Robert Haas
On Thu, Apr 21, 2011 at 6:38 AM, Simon Riggs wrote: > On Thu, Apr 21, 2011 at 10:31 AM, rajibdk wrote: >> What does that database system identifier means? Is it related to DB >> transactions’ or unique to a version? > > Regrettably, it means you didn't follow the documented procedure. > > It isn'

Re: [HACKERS] Re: database system identifier differs between the primary and standby

2011-04-21 Thread Simon Riggs
On Thu, Apr 21, 2011 at 10:31 AM, rajibdk wrote: > What does that database system identifier means? Is it related to DB > transactions’ or unique to a version? Regrettably, it means you didn't follow the documented procedure. It isn't possible to do it any other way, so those questions are a di

Re: [HACKERS] Re: database system identifier differs between the primary and standby

2011-04-21 Thread Heikki Linnakangas
On 21.04.2011 12:31, rajibdk wrote: What does that database system identifier means? Is it related to DB transactions' or unique to a version? It's an identifier unique to each PostgreSQL database cluster. It's generated when you run initdb. -- Heikki Linnakangas EnterpriseDB http://w

[HACKERS] Re: database system identifier differs between the primary and standby

2011-04-21 Thread rajibdk
What does that database system identifier means? Is it related to DB transactions' or unique to a version? Rajib Deka SIEMENS Ltd. Robert V Chandran Tower, First Floor, West Wing, #149, Velechery Tambaram Main Road, Pallikaranai, Chennai-100, INDIA. www.siemens.com Mob: +