Re: [GENERAL] Server stops responding in every week

2011-01-22 Thread Andrus Moor
Andy, How to automatically re-start postgres service in every night ? Or is it better to switch to 32bit server? Neither. You need to fix the problem. How to configure postgres so that freeze issue can addressed ? E.q. if query runs more that 60 seconds, postgres dumps its status and long

Re: [GENERAL] Read problem from Bytea column

2011-01-22 Thread Francisco Figueiredo Jr.
Francisco Figueiredo Jr Sent from my Android phone. Em 21/01/2011 13:50, "orgilhp" escreveu: > > Hello, Hello! > I have postgresql 8.3.9 database. Now I am working on reading file > from bytea data and save to filesystem. > I am using Npgsql.dll on c#.net. > Which version of Npgsql are you us

Re: [GENERAL] Using copy for WAL archiving on Windows

2011-01-22 Thread Harald Armin Massa
Christian, > Should PostgreSQL maybe provide its own file-copy utility for Windows that > meets the requirements for safe WAL archiving? > > Microsoft does provide an enterprise-ready webscale copy program ... it is called robocopy and part of the Windows Server Resource Kit Tools. Would you min

Re: [GENERAL] Server stops responding in every week

2011-01-22 Thread Andy Colson
On 01/22/2011 03:00 AM, Andrus Moor wrote: Andy, How to automatically re-start postgres service in every night ? Or is it better to switch to 32bit server? Neither. You need to fix the problem. How to configure postgres so that freeze issue can addressed ? E.q. if query runs more that 60 se

Re: [GENERAL] Using copy for WAL archiving on Windows

2011-01-22 Thread Christian Ullrich
* Harald Armin Massa wrote: Should PostgreSQL maybe provide its own file-copy utility for Windows that meets the requirements for safe WAL archiving? Microsoft does provide an enterprise-ready webscale copy program ... it is called robocopy and part of the Windows Server Resource Kit T

Re: [GENERAL] SHMMAX and SHMALL question

2011-01-22 Thread Greg Smith
DM wrote: RAM = 16GB, what value should i set for shmall? Given that PostgreSQL rarely sees increasing improvement as shared_buffers goes over 50% of RAM, I just use that figure for the shmall and then compute shmmax based on the page size to match it. I use the attached script to do all th

Re: [GENERAL] Server stops responding in every week

2011-01-22 Thread Andrus Moor
Andy, Then answer these questions: Does ram using increase over the week? Server was re-started yesterday and there was little use after restart. server is idle. Task Manager shows now PF Usage 1.22 GB Physical Memory (K) Total 4191872 Avail 348 (last 4 vary) System cache 35676xx (last

Re: [GENERAL] Server stops responding in every week

2011-01-22 Thread Scott Marlowe
I know you're running windows, but if you can get bash working on it, here's a simple bash script I wrote that when it detects too many people connected creates a table called pg_stat_bk_20110120140634 (i.e. date and time) so I can then look over what was in pg_stat_activity when things were acting

Re: [GENERAL] SHMMAX and SHMALL question

2011-01-22 Thread D M
Thank you so much for the script. ~deepak On Jan 22, 2011, at 10:18 AM, Greg Smith wrote: > DM wrote: >> RAM = 16GB, what value should i set for shmall? > > Given that PostgreSQL rarely sees increasing improvement as shared_buffers > goes over 50% of RAM, I just use that figure for the shmal

Re: [GENERAL] Subquery for column names of tablefunc crosstab queries

2011-01-22 Thread Joe Conway
On 01/21/2011 09:34 AM, Julia Jacobson wrote: > Two further problems are the fact that the names of columns are not > allowed to begin with a number and every entry in the table definition > list must not only contain the name of the column but of course also a > data type (always the same - int).