[GENERAL] record-based log shipping

2011-08-21 Thread Dondi Michael Stroma
Hello, I have a question about log shipping. The documentation from PostgreSQL 8.4, in section 24.4.4, describes how to archive partial WAL files by using the pg_xlogfile_name_offset() function, which it calls record-based log shipping. Although it seems that this section of documentation has

Re: [GENERAL] record-based log shipping

2011-08-21 Thread Magnus Hagander
On Sun, Aug 21, 2011 at 08:23, Dondi Michael Stroma dstr...@gmail.com wrote: Hello, I have a question about log shipping. The documentation from PostgreSQL 8.4, in section 24.4.4, describes how to archive partial WAL files by using the pg_xlogfile_name_offset() function, which it calls

[GENERAL] Streaming replication without hot standby

2011-08-21 Thread alexondi
Hi! If I use streaming replication must I setup hot stanby mode on my slave-server? If not then this server would not accept any connections? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-replication-without-hot-standby-tp4719918p4719918.html Sent from the

[GENERAL] How to apply Postgresql Patch

2011-08-21 Thread AI Rumman
Hi, I want to learn how to apply patch in Postgresql? Recently, I got the docs http://archives.postgresql.org/pgsql-hackers/2011-08/msg00581.php. I want to apply the patch. Any guideline please?

Re: [GENERAL] Streaming replication without hot standby

2011-08-21 Thread Guillaume Lelarge
On Sun, 2011-08-21 at 00:19 -0700, alexondi wrote: Hi! If I use streaming replication must I setup hot stanby mode on my slave-server? No, you don't have to. If not then this server would not accept any connections? Exactly. Except the streaming one. -- Guillaume

Re: [GENERAL] Streaming replication without hot standby

2011-08-21 Thread alexondi
So, how can I check is the slave-server up and properly work (recovery is in progress) in this case? Check the log for some messages? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-replication-without-hot-standby-tp4719918p4720156.html Sent from the PostgreSQL

Re: [GENERAL] record-based log shipping

2011-08-21 Thread Simon Riggs
On Sun, Aug 21, 2011 at 7:23 AM, Dondi Michael Stroma dstr...@gmail.com wrote: Hello, I have a question about log shipping. The documentation from PostgreSQL 8.4, in section 24.4.4, describes how to archive partial WAL files by using the pg_xlogfile_name_offset() function, which it calls

Re: [GENERAL] Streaming replication without hot standby

2011-08-21 Thread Simon Riggs
On Sun, Aug 21, 2011 at 11:12 AM, alexondi alexo...@rambler.ru wrote: So, how can I check is the slave-server up and properly work (recovery is in progress) in this case? Check the log for some messages? It's certainly more tricky... --  Simon Riggs  

Re: [GENERAL] Streaming replication without hot standby

2011-08-21 Thread alexondi
But still, how to do it (check server state) in this case? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-replication-without-hot-standby-tp4719918p4720634.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general

[GENERAL] record-based log shipping

2011-08-21 Thread Dondi Michael Stroma
Hello, I have a question about log shipping. The documentation from PostgreSQL 8.4, in section 24.4.4, describes how to archive partial WAL files by using the pg_xlogfile_name_offset() function, which it calls record-based log shipping. Although it seems that this section of documentation has

Re: [GENERAL] How to apply Postgresql Patch

2011-08-21 Thread Scott Marlowe
On Sun, Aug 21, 2011 at 2:05 AM, AI Rumman rumman...@gmail.com wrote: Hi, I want  to learn how to apply patch in Postgresql? Recently, I got the docs http://archives.postgresql.org/pgsql-hackers/2011-08/msg00581.php. I want to apply the patch. Any guideline please? Applying the patch

Re: [GENERAL] Streaming replication without hot standby

2011-08-21 Thread Guillaume Lelarge
On Sun, 2011-08-21 at 08:04 -0700, alexondi wrote: But still, how to do it (check server state) in this case? pg_controldata is probably a good solution. Or checking process titles with ps -ef. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via

Re: [GENERAL] record-based log shipping

2011-08-21 Thread Dondi Michael Stroma
On Sun, Aug 21, 2011 at 3:14 AM, Magnus Hagander mag...@hagander.net wrote: On Sun, Aug 21, 2011 at 08:23, Dondi Michael Stroma dstr...@gmail.com wrote: So how would one feed incrementally copied partial WAL file data to a standby Pad it with zeroes up to the normal segment limit (16Mb), and

Re: [GENERAL] idle in transaction process

2011-08-21 Thread tamanna madaan
Can anyone please suggest me on this . Thanks.. Tamanna On Thu, Aug 18, 2011 at 2:47 PM, tamanna madaan tamanna.mad...@globallogic.com wrote: Hi Yes , restarting the slon resolves the issue. But. there are other processes also in my application which connect to postgres . Those processes

Re: [GENERAL] idle in transaction process

2011-08-21 Thread John R Pierce
On 08/18/11 2:17 AM, tamanna madaan wrote: Yes , restarting the slon resolves the issue. But. there are other processes also in my application which connect to postgres . Those processes can also cause idle in transaction postgres connection . So, I was wondering if I can make use of

Re: [GENERAL] idle in transaction process

2011-08-21 Thread Scott Marlowe
On Sun, Aug 21, 2011 at 10:52 PM, tamanna madaan tamanna.mad...@globallogic.com wrote: Can anyone please suggest me on this . Both the PostgreSQL and Slony versions you are running have known bugs that cause problems. Update them first and see if your problem goes away. -- Sent via