On Jul 19, 2012, at 9:03 PM, Sergey Konoplev wrote:
> On Fri, Jul 20, 2012 at 1:02 AM, David Kerr wrote:
>> I was looking into this last month and some nice folks on the list pointed
>> me to this formula
>> for calculating lag. (to be run on the slave) simila
On Jul 19, 2012, at 8:17 AM, Ali Pouya wrote:
> Hi,
> I am using a master and a replica with PostgreSQL 9.1.3.
> I would like to measure the replication lag between my servers (in time
> units).
>
> On the replica I can use the function pg_last_xact_replay_timestamp().
> But on the master I onl
On 03/06/2012 02:03 PM, Todd Hunt wrote:
Hi,
First let me state that I'm not a DBA, but a developer. I know enough
about databases to be dangerous, but not enough to make any money at
it. ;-)
We are using large objects with OIDs as part of our data model. One
of our processes is to backup th
On 03/07/2012 07:39 AM, Ray Stell wrote:
how I can differentiate these:
oamp=# \z public.c3*
Access privileges
Schema | Name | Type | Access privileges | Column access
privileges
+---+---+---
On Wed, Jul 14, 2010 at 05:30:17PM -0400, Burgholzer, Robert (DEQ) wrote:
- >. The options I suggested be turned off just for the load process
- > ...
- > not safe if the other databases are in the same PostgreSQL Cluster
-
- They are, so I won't --- thanks for the heads up on that too.
-
- Jus
On Wed, Jul 14, 2010 at 01:07:48PM -0400, Burgholzer, Robert (DEQ) wrote:
- That said, the time to restore is explainable, but is there something in
- my tuning that is causing all of my memory to be eaten?
-
- We seem to have some undiagnosed issue whereby opening and closing large
- files on the
