thx
Sent from my Verizon Wireless 4G LTE smartphone
Kevin Grittner wrote:
Benjamin Krajmalnik wrote:
> It is ok if I am a little bit behind. What setting do
> I need to tweak to allow it to get further behind?
The relevant settings are described here:
http://www.postgresql.org/docs/9.0/int
Benjamin Krajmalnik wrote:
> It is ok if I am a little bit behind. What setting do
> I need to tweak to allow it to get further behind?
The relevant settings are described here:
http://www.postgresql.org/docs/9.0/interactive/runtime-config-wal.html#RUNTIME-CONFIG-REPLICATION
http://www.postgresq
It is ok if I am a little bit behind. What setting do I need to tweak to allow
it to get further behind?
-Original Message-
From: Kevin Grittner [mailto:kgri...@mail.com]
Sent: Thursday, January 17, 2013 4:32 PM
To: Benjamin Krajmalnik; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Q
Benjamin Krajmalnik wrote:
> I have 2 servers which are using streaming replication (pg 9.0.4).
>
> The secondary server is there primarily as a disaster recovery server,
> but we are also using it for reporting, so as not to place undue load on
> the primary server.
>
> As I review the logs on
Jerry Sievers writes:
> Does anyone know if one of the signals below can be sent to break out
> ,of this state *without* the postmaster sensing a crashed backend?
> I've seen several times in the past at other companies, backends that
> will not respond to cancel nor SIGTERM due to syscall that's
Vinod V wrote:
> Below were the error messages that we were getting ... (while
> restarting the server).
>
>
> 2013-01-10 01:58:46 PST LOG: could not bind IPv6 socket: No error
> 2013-01-10 01:58:46 PST HINT: Is another postmaster already running on port
> 5432? If not, wait a few seconds and r
Also, which version of postgres are you using?
PostgreSQL 9.2.1 on Ubuntu 12.04
Except in my case no number of restarts helped. You didn't say, were
you explicitly copying $PGDATA or using some other mechanism to
migrate the data elsewhere?
So we have a very large database (~5TB), so we u
Sorry, Initial response got blocked since I replied with the logs quoted
again.
Also, which version of postgres are you using?
PostgreSQL 9.2.1 on Ubuntu 12.04
Except in my case no number of restarts helped. You didn't say, were
you explicitly copying $PGDATA or using some other mechani
Hi Team,
We need to implement incremental backup (PITR) in our environment, since our
production database is in high risk.
We are running with PostgreSQL 9.1
We need to implement this on both Windows7 and Linux platforms.
We were able to get the WAL files generated on Windows platform but the
r
Does anyone know if one of the signals below can be sent to break out
,of this state *without* the postmaster sensing a crashed backend?
I've seen several times in the past at other companies, backends that
will not respond to cancel nor SIGTERM due to syscall that's blocked
on IO.
Quite often th
Hi,
On Thu, 2013-01-17 at 11:39 -0500, dx k9 wrote:
> Just wondering what different gcc compile options are used in the
> postgresql 9.1 centos RPM that we could copy in an effort to increase
> kernel performance, get higher TPS on pgbench.
http://svn.pgrpms.org/browser/rpm/redhat/9.1/postgr
I have 2 servers which are using streaming replication (pg 9.0.4).
The secondary server is there primarily as a disaster recovery server,
but we are also using it for reporting, so as not to place undue load on
the primary server.
As I review the logs on the secondary server, I frequently see the
On Jan 17, 2013, at 11:20 AM, Scott Whitney wrote:
> What I want to know is whether there's a situation in which my standby is
> running, the receiver process is running, but "something" is wrong.
I compare pg_controldata output from the two clusters periodically.
On Thu, Jan 17, 2013 at 11:39 AM, dx k9 wrote:
> Are there any compile options I should use when compiling(configure)
> posgresql-9.1.7 from source on a new centos 6.3 box? Just wondering what
> different gcc compile options are used in the postgresql 9.1 centos RPM
> that we could copy in an
Greetings, Are there any compile options I should use when compiling(configure)
posgresql-9.1.7 from source on a new centos 6.3 box? Just wondering what
different gcc compile options are used in the postgresql 9.1 centos RPM that we
could copy in an effort to increase kernel performance, g
I've got replication setup (streaming replication) between two 9.2.2 clusters.
Everything went just fine on that, and it's working as expected.
Now, obviously, I'll know if my primary goes down. I just monitor him as usual.
How do I tell whether the standby has gone out of sync for whatever re
Baptiste LHOSTE wrote:
> We are still trying to fix our issue and we found following logs :
>
> 2013-01-17 09:55:01 CET LOG: automatic vacuum of table
> "flows.public.agg_t1213_incoming_a6_dst_port_and_proto_f5": index scans: 1
> pages: 0 removed, 136547 remain
> tuples: 0 removed, 40
Hi,
We are still trying to fix our issue and we found following logs :
2013-01-17 09:55:01 CET LOG: automatic vacuum of table
"flows.public.agg_t1213_incoming_a6_dst_port_and_proto_f5": index scans: 1
pages: 0 removed, 136547 remain
tuples: 0 removed, 4044679 remain
syst
18 matches
Mail list logo
