[GENERAL] PANIC: could not create file "pg_xlog/xlogtemp.7884": No space left on device

2014-09-26 Thread Roopeshakumar Narayansa Shalgar (rshalgar)
Hi, I am using version 9.3.1 and see the "no space device error" even though there is enough space (99% free) on my disk. Error: PANIC: could not create file "pg_xlog/xlogtemp.7884": No space left on device I want to know whether this is a bug and if yes whether fix or workaround is availabl

Re: [GENERAL] PANIC: could not create file "pg_xlog/xlogtemp.7884": No space left on device

2014-09-28 Thread Roopeshakumar Narayansa Shalgar (rshalgar)
g wrong." 6. I am seeing this issue when I create around 60,000 to 70,000 files (each of size 4k) in the data base. Appreciate any quick help on this. -- Thanks and regards, Rupesh -Original Message- From: Raymond O'Donnell [mailto:r...@iol.ie] Sent: Friday, September 26, 2014

[GENERAL] Any postgres API available to get errorcode for PQerrorMessage

2014-10-15 Thread Roopeshakumar Narayansa Shalgar (rshalgar)
HI, PQerrorMessage pirints the error message like (no space available,etc). Does postgres provide any API which gives the error code listed in the below appendix; http://www.postgresql.org/docs/9.1/static/errcodes-appendix.html I need the exact error code so that I can shutdown my application

Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage

2014-10-15 Thread Roopeshakumar Narayansa Shalgar (rshalgar)
: Roopeshakumar Narayansa Shalgar (rshalgar) Cc: pgsql-...@postgresql.org; pgsql-general@postgresql.org Subject: Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage "Roopeshakumar Narayansa Shalgar (rshalgar)" writes: > HI, > PQerrorMessage pirints the e

Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage

2014-10-16 Thread Roopeshakumar Narayansa Shalgar (rshalgar)
Appreciate any replies on this. /rK -Original Message- From: Roopeshakumar Narayansa Shalgar (rshalgar) Sent: Wednesday, October 15, 2014 10:19 PM To: 'Tom Lane'; pgsql-...@postgresql.org; pgsql-general@postgresql.org Subject: RE: [GENERAL] Any postgres API available to get