Re: [ADMIN] about shared_buffer and kernel.shmmax

2012-06-20 Thread Craig Ringer
On 06/21/2012 11:38 AM, wangqi wrote: > Hi everybody, > shared_buffer maximum limit is ? > I set shared_buffer more than 250G, I got error at startup pg. > http://www.postgresql.org/docs/9.1/static/kernel-resources.html#SYSVIPC http://www.postgresql.org/docs/9.1/static/runtime-config-resource.ht

[ADMIN] about shared_buffer and kernel.shmmax

2012-06-20 Thread wangqi
Hi everybody, shared_buffer maximum limit is ? I set shared_buffer more than 250G, I got error at startup pg. This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parame

Re: [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-20 Thread Lonni J Friedman
On Wed, Jun 20, 2012 at 6:56 AM, Welty, Richard wrote: > Lonni J Friedman writes: > >>I'm not using SSL. > > ummm, ssh uses ssl. > Sure, although I thought that Simon was referring to the database itself. However, I don't think ssh is the problem, as I can scp a file from the server and the load

Re: [ADMIN] View as front-end to function

2012-06-20 Thread Misa Simic
Hi Greg, I think it is Foreign Data Wrapper feature what already exist in Postgres http://wiki.postgresql.org/wiki/Foreign_data_wrappers So basically, you would need to write your own sourse fdw... Kind Regards, Misa 2012/6/20 Greg Spiegelberg > Hi list, > > I've done some research on the s

Re: [HACKERS] [ADMIN] PANIC while doing failover (streaming replication)

2012-06-20 Thread Matheus Ricardo Espanhol
Hi, Any news on this issue? My slave server is not trusted, all the warnings below are related to indexes of the main tables: 2012-06-14 11:46:23 BRT [18654]: [34603-1] user=,db= LOG: recovery restart point at 435/4E899CE8 2012-06-14 11:46:23 BRT [18654]: [34604-1] user=,db= DETAIL: last comple

[ADMIN] View as front-end to function

2012-06-20 Thread Greg Spiegelberg
Hi list, I've done some research on the subject and found only some dated threads on this topic. Wondering if anything has changed. What I am looking for is a way to create a VIEW that is a front-end to a function. Any conditions in the WHERE clause would be passed as parameters to the function

Re: [ADMIN] Issue in save and retreive file in postgres

2012-06-20 Thread Craig Ringer
On 06/15/2012 09:16 PM, Vishwas Dwivedi wrote: Greetings, I am a software programmer and working on a .net web application(ASP.NET 4.0, c# ). I am new to postgres and for my current project I am using postgres as database. In this need functionality to upload a pdf file t

Re: [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-20 Thread Welty, Richard
Lonni J Friedman writes: >I'm not using SSL. ummm, ssh uses ssl. richard

Re: [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-20 Thread Lonni J Friedman
On Wed, Jun 20, 2012 at 5:02 AM, Simon Riggs wrote: > On 13 June 2012 02:39, Magnus Hagander wrote: > >>> I'm running the following, which gets piped over ssh to a remote >>> server (at gigabit ethernet speed): >>> pg_basebackup -v -D - -x -Ft -U postgres >>> >>> One thing that I've discovered is

Re: [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-20 Thread Simon Riggs
On 13 June 2012 02:39, Magnus Hagander wrote: >> I'm running the following, which gets piped over ssh to a remote >> server (at gigabit ethernet speed): >> pg_basebackup -v -D - -x -Ft -U postgres >> >> One thing that I've discovered is that if I throttle back the speed of >> what is getting pipe

[ADMIN] Issue in save and retreive file in postgres

2012-06-20 Thread Vishwas Dwivedi
Greetings, I am a software programmer and working on a .net web application(ASP.NET4.0, c# ). I am new to postgres and for my current project I am using postgres as database. In this need functionality to upload a pdf file to database and then retrieve it again from database. I have taken byte