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 am...@amutu.com 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

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 t...@sss.pgh.pa.us wrote: Jon Nelson jnelson+pg...@jamponi.net writes: On Sun, Feb 23, 2014 at 9:49 PM, Tom Lane t...@sss.pgh.pa.us wrote: If memory serves, the inode should get removed during the next checkpoint. I was moments away from commenting

[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

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 jnelson+pg...@jamponi.net wrote: Here is an example. % time seconds usecs/call callserrors syscall -- --- --- - - 99.953.2076814182 767 ftruncate 0.05

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 version

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 sfr...@snowman.net 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?

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 sfr...@snowman.net 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

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 sfr...@snowman.net 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

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 would

[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: