Re: [GENERAL] pg_stop_backup running for 10h?

2014-01-12 Thread Magnus Hagander
On Sat, Jan 11, 2014 at 11:26 PM, François Beausoleil wrote: > Hi all, > > I'm using OmniPITR to build a new slave. According to pg_stat_activity, > pg_stop_backup has been running for nearly 11 hours. The WAL archive > command is running just fine and reporting "Segment X successfully sent to > a

[GENERAL] PG 924, Windows 2012, error code 487

2014-01-12 Thread Abraham, Danny
Hi, Since moving to PG 9.2.4 we are facing many connection refusals from PG Mainly on Windows 8, Server 2012 and Server2012R2. Error ... could not fork new process for connection: A blocking operation was interrupted by a call to WSACancelBlockingCall Sometimes it even fails the AUTOVACUM proc

Re: [GENERAL] pg_stop_backup running for 10h?

2014-01-12 Thread François Beausoleil
Le 2014-01-12 à 05:38, Magnus Hagander a écrit : > > On Sat, Jan 11, 2014 at 11:26 PM, François Beausoleil > wrote: > Hi all, > > I'm using OmniPITR to build a new slave. According to pg_stat_activity, > pg_stop_backup has been running for nearly 11 hours. The WAL archive command > is runni

[GENERAL] DB Authentication Design

2014-01-12 Thread François Beausoleil
Hi all, I'm thinking that all apps that connect to the database should have their own user. For example, the web application process is one user, then a report builder process should have another user, and a different process that imports data should have his own too, and so on. Would you gener

Re: [GENERAL] DB Authentication Design

2014-01-12 Thread Szymon Guz
On 12 January 2014 15:30, François Beausoleil wrote: > Hi all, > > I'm thinking that all apps that connect to the database should have their > own user. For example, the web application process is one user, then a > report builder process should have another user, and a different process > that i

Re: [GENERAL] Setting server log messages to fr_FR (or any non-English)

2014-01-12 Thread Dariusz Suchojad
On 01/11/2014 10:51 PM, Tom Lane wrote: > It looks like you set the locale settings properly. I'm guessing that > the build lacks localization support. Check the output of > "pg_config --configure" to see if --enable-nls is mentioned. If it > isn't, you need to rebuild with that configuration o

Re: [GENERAL] PG 924, Windows 2012, error code 487

2014-01-12 Thread Adrian Klaver
On 01/12/2014 06:07 AM, Abraham, Danny wrote: Hi, Since moving to PG 9.2.4 we are facing many connection refusals from PG Mainly on Windows 8, Server 2012 and Server2012R2. Error … could not fork new process for connection: A blocking operation was interrupted by a call to WSACancelBlockingCa

Re: [GENERAL] DB Authentication Design

2014-01-12 Thread Sameer Kumar
On 12 Jan 2014 22:31, "François Beausoleil" wrote: > > Hi all, > > I'm thinking that all apps that connect to the database should have their own user. For example, the web application process is one user, then a report builder process should have another user, and a different process that imports

Re: [GENERAL] DB Authentication Design

2014-01-12 Thread Chris Travers
On Sun, Jan 12, 2014 at 6:30 AM, François Beausoleil wrote: > Hi all, > > I'm thinking that all apps that connect to the database should have their > own user. For example, the web application process is one user, then a > report builder process should have another user, and a different process >

Re: [GENERAL] How to specify/mock the statistic data of tables in PostgreSQL

2014-01-12 Thread Felix . 徐
I see, thanks. I'm looking into the source code of statistic part now, and I'm a little confused about the column "staop" presented in table pg_statistic, in the pg_statisitc.h, the comment says: /* * To allow keeping statistics on different kinds of datatypes, * we do not hard