2014-08-11 5:33 GMT+02:00 John R Pierce :
>
> -
>
>> PERFORM pg_advisory_lock(#1 , 2 or 3 depending on the table#,id of the
>> stuff I want to upsert) ;
>> WITH stuff_to_upsert ()
>> ,updating AS (update returning id)
>> ,inserting AS (insert if not updated)
>> PERFORM pg_advisory_unlock(s
Today,our monitor report a pg slave instance'disk space usage reach 96%，I
login in to the machine，and find the pg_xlog dir take up more than
2TB，which is abnormal.
the number of WAL file in the pg_xlog dir is more than 130k,while we set
the wal keep number to 8192.
I think there is something stop t
hi, guys
does anyone have link to download pgagent binary distribution for centos ?
i tried on building the tar source but stuck on resolving the wxGTK
(wxWidget) dependencies.
many thanks
--
Disclaimer : This E-mail is intended only for the use of the individual or
entity named above and may c
Rémi Cura wrote:
> 2014-08-11 5:33 GMT+02:00 John R Pierce :
>> ah, you're releasing the lock before the insert is committed,
>> since this is all within a function call, its entirely within a
>> single transaction.
> Oh no I hoped it was something fixable
Well, it might be. Try using a trans
Hello ,
I specified correct method i got error/message at perl Makefile.PL
tar xzf pgcluu-2.0.tar.gz
-bash-4.1$ cd pgcluu-2.0
*-bash-4.1$ perl Makefile.PL*
Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains:
/usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl
/usr/s
type function is record (f1 NUMERIC,f2 NUMERIC..); this is in oracle
kindly tell me what is the substitute to use "is record " in postgres.
its urgent .
thanks and rgds
vpmm
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-referencing-and-creating-type
Hello
You must install the harness.pm module
You may do it via yum
yum install perl-Test-Harness
or downloaded the tar package and install it
http://search.cpan.org/~leont/Test-Harness-3.32/lib/Test/Harness.pm
I hope this help you.
David
On 08/11/2014 08:52 AM, Ramesh T wrote:
Hello ,
On Mon, Aug 11, 2014 at 9:49 AM, Kevin Grittner wrote:
> Rémi Cura wrote:
>
>> 2014-08-11 5:33 GMT+02:00 John R Pierce :
>
>>> ah, you're releasing the lock before the insert is committed,
>>> since this is all within a function call, its entirely within a
>>> single transaction.
>
>> Oh no I hop
On 08/10/2014 09:50 PM, Vaishali Maheshkar wrote:
SIR,
THANKS FOR YOUR REPLY ,
CCing list.
actually i m trying to create record type data in postgres , but i cant
declare it directly as in oracle my purpose is to create types of record
type in oracle it was done by creating a package and d
Hey,
as you (both?) suggested it works using advisory lock used at the beginning
and end of the transaction. This way there is no upsert at all if the
element is locked? (I used general advisory lockbut in the same way as
transactionnal lock)
The issue in this case is simple : I have to use about 1
Rémi Cura wrote:
> as you (both?) suggested it works using advisory lock used at the
> beginning and end of the transaction. This way there is no upsert
> at all if the element is locked? (I used general advisory lockbut
> in the same way as transactionnal lock)
This is too vague to comment on.
Hello All,
This is how i set up the db :
Slave using streaming replica.
We configure slave to run pg_dump which usually last for about 12 hours.
We have limited pg_xlog on slave.
Once the pg_xlog on slave is full while pg_dump still in progress.
2014-08-11 09:39:23.226 CDT,,,25779,,53d26b30.64b3,
On Tue, Aug 12, 2014 at 2:10 PM, Soni M wrote:
> This is how i set up the db :
> Slave using streaming replica.
> We configure slave to run pg_dump which usually last for about 12 hours.
> We have limited pg_xlog on slave.
> Once the pg_xlog on slave is full while pg_dump still in progress.
What i
On Tue, Aug 12, 2014 at 12:37 PM, Michael Paquier wrote:
> On Tue, Aug 12, 2014 at 2:10 PM, Soni M wrote:
> > This is how i set up the db :
> > Slave using streaming replica.
> > We configure slave to run pg_dump which usually last for about 12 hours.
> > We have limited pg_xlog on slave.
> > On
14 matches
Mail list logo
