[GENERAL] Adding a non-null column without noticeable downtime

2014-02-24 Thread Zev Benjamin
Hi all, I'm sure this has been answered somewhere, but I was not able to find anything in the list archives. I'm conceptually trying to do ALTER TABLE "foo" ADD COLUMN "bar" boolean NOT NULL DEFAULT False; without taking any noticeable downtime. I know I can divide the query up like so: A

Re: [GENERAL] plans for plpython in RDS?

2014-02-24 Thread Bruce Momjian
On Tue, Feb 18, 2014 at 05:08:43PM -0800, Reece Hart wrote: > Does anyone know if there are plans to support plpython in Amazon's RDS? I > (approximately) understand the issue, but I don't know if there's any effort > to > remedy the problem or, rather, I shouldn't bother hoping. I think you woul

Re: [GENERAL] GSSAPI/SSPI and mismatched user names

2014-02-24 Thread Brian Crowell
On Mon, Feb 24, 2014 at 1:06 PM, Stephen Frost wrote: > I'm afraid you're going to need to try harder to find out how to get the > Windows GSSAPI/SSPI code to give you the princ. I was actually pretty > sure that GSSAPI defined a way, but I don't know the Windows side of it > or if they decided t

Re: [GENERAL] GSSAPI/SSPI and mismatched user names

2014-02-24 Thread Stephen Frost
* Brian Crowell (br...@fluggo.com) wrote: > On Mon, Feb 24, 2014 at 12:55 PM, Stephen Frost wrote: > > * Brian Crowell (br...@fluggo.com) wrote: > >> https://github.com/npgsql/Npgsql/issues/162#issuecomment-35916650 > > > > Reading through this- can't you use GSSAPI to get the Kerberos princ > > f

Re: [GENERAL] GSSAPI/SSPI and mismatched user names

2014-02-24 Thread Brian Crowell
On Mon, Feb 24, 2014 at 12:55 PM, Stephen Frost wrote: > * Brian Crowell (br...@fluggo.com) wrote: >> https://github.com/npgsql/Npgsql/issues/162#issuecomment-35916650 > > Reading through this- can't you use GSSAPI to get the Kerberos princ > found the ticket which is constructed? I'm pretty sure

Re: [GENERAL] GSSAPI/SSPI and mismatched user names

2014-02-24 Thread Stephen Frost
* Brian Crowell (br...@fluggo.com) wrote: > https://github.com/npgsql/Npgsql/issues/162#issuecomment-35916650 Reading through this- can't you use GSSAPI to get the Kerberos princ found the ticket which is constructed? I'm pretty sure the MIT libraries support that, at least... > The short versio

[GENERAL] GSSAPI/SSPI and mismatched user names

2014-02-24 Thread Brian Crowell
I'm going to file this as a bug as well, but I guess I'm hoping to catch some developers here for discussion. I'm working with the Npgsql group on getting integrated security to "just work" in the same way SQL Server's does. I wrote a workaround for one issue, only to find out that I need more wor

Re: [GENERAL] Why does PostgreSQL ftruncate before unlink?

2014-02-24 Thread Francisco Olarte
On Mon, Feb 24, 2014 at 6:38 PM, Jon Nelson wrote: > Here is an example. > > % time seconds usecs/call callserrors syscall > -- --- --- - - > 99.953.2076814182 767 ftruncate > 0.050.001579

Re: [GENERAL] Why does PostgreSQL ftruncate before unlink?

2014-02-24 Thread Jon Nelson
On Sun, Feb 23, 2014 at 10:07 PM, Tom Lane wrote: > Jon Nelson writes: >> On Sun, Feb 23, 2014 at 9:49 PM, Tom Lane wrote: >>> If memory serves, the inode should get removed during the next checkpoint. > >> I was moments away from commenting to say that I had traced the flow >> of the code to md

Re: [GENERAL] stand by is starting until I do some work in the primary

2014-02-24 Thread Magnus Hagander
On Sun, Feb 23, 2014 at 8:25 AM, Jov wrote: > Sure.Before the restart,I have login in the slave many times. > some more info ,but I don't think related: > centOS 6 ,amd64,128GB memory,24 core, pgsql-9.3.3,master and slave in the > same host. > > this is my first instance of 9.3,I don't exprence t