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
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
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
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?
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
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
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
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
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
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
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
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
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
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
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
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
16 matches
Mail list logo