Re: [HACKERS] add sha256 files to releases

2013-04-14 Thread Tom Lane
Peter Eisentraut writes: > Could we generated sha256 files for the release tarballs, instead of the > md5 files that are currently generated? The packaging systems that I > surveyed that verify the checksum of the tarball (FreeBSD ports and the > like) don't use md5 anymore, so a sha256 file woul

Re: [HACKERS] PROPOSAL: tracking aggregated numbers from pg_stat_database

2013-04-14 Thread Robert Haas
On Sat, Apr 13, 2013 at 9:01 AM, Peter Eisentraut wrote: > On Sat, 2013-04-06 at 21:51 +0200, Tomas Vondra wrote: >> This more or less works in stable environments, but once you start >> dropping databases (think of hosting with shared DB server) it gets >> unusable because after DROP DATABASE the

[HACKERS] add sha256 files to releases

2013-04-14 Thread Peter Eisentraut
Could we generated sha256 files for the release tarballs, instead of the md5 files that are currently generated? The packaging systems that I surveyed that verify the checksum of the tarball (FreeBSD ports and the like) don't use md5 anymore, so a sha256 file would be much more useful for direct v

Re: [HACKERS] Inconsistent DB data in Streaming Replication

2013-04-14 Thread Hannu Krosing
On 04/14/2013 05:56 PM, Fujii Masao wrote: On Fri, Apr 12, 2013 at 7:57 PM, Andres Freund wrote: On 2013-04-12 02:29:01 +0900, Fujii Masao wrote: On Thu, Apr 11, 2013 at 10:25 PM, Hannu Krosing wrote: You just shut down the old master and let the standby catch up (takas a few microseconds ;)

Re: [HACKERS] Inconsistent DB data in Streaming Replication

2013-04-14 Thread Fujii Masao
On Fri, Apr 12, 2013 at 7:57 PM, Andres Freund wrote: > On 2013-04-12 02:29:01 +0900, Fujii Masao wrote: >> On Thu, Apr 11, 2013 at 10:25 PM, Hannu Krosing >> wrote: >> > >> > You just shut down the old master and let the standby catch >> > up (takas a few microseconds ;) ) before you promote it

Re: [HACKERS] Inconsistent DB data in Streaming Replication

2013-04-14 Thread Fujii Masao
On Fri, Apr 12, 2013 at 5:53 PM, Hannu Krosing wrote: > On 04/11/2013 07:29 PM, Fujii Masao wrote: >> >> On Thu, Apr 11, 2013 at 10:25 PM, Hannu Krosing >> wrote: >>> >>> You just shut down the old master and let the standby catch >>> up (takas a few microseconds ;) ) before you promote it. >>> >

Re: [HACKERS] [PATCH] pg_regress and non-default unix socket path

2013-04-14 Thread Christoph Berg
Re: Tom Lane 2013-04-12 <20318.1365786...@sss.pgh.pa.us> > Robert Haas writes: > > The hunk that changes the messages might need some thought so that it > > doesn't cause a translation regression. But in general I see no > > reason not to do this before we release beta1. It seems safe enough, >