Re: [BUGS] BUG #8450: pg_basebackup blocks until WAL archiving successful

2013-09-25 Thread Stuart Bishop
at the moment so cannot rely on --xlog-method=stream. I agree that the current behavior is for most use cases better, and I think that the behavior I want should be explicitly enabled with an option. -- Stuart Bishop stu...@stuartbishop.net http://www.stuartbishop.net/ -- Sent via pgsql-bugs mailing

[BUGS] BUG #8450: pg_basebackup blocks until WAL archiving successful

2013-09-13 Thread stuart
The following bug has been logged on the website: Bug reference: 8450 Logged by: Stuart Bishop Email address: stu...@stuartbishop.net PostgreSQL version: 9.1.9 Operating system: all Description: Hi. pg_basebackup blocks until all necessary WAL files have been

Re: [BUGS] BUG #7651: Superfluous calls to functions used for indexing

2012-11-15 Thread Stuart Bishop
value. I think this is the same issue as was discussed here, dating from PostgreSQL 8.1: http://postgresql.1045698.n5.nabble.com/Slow-functional-indexes-td2059587.html -- Stuart Bishop stu...@stuartbishop.net http://www.stuartbishop.net/ -- Sent via pgsql-bugs mailing list (pgsql-bugs

[BUGS] BUG #7661: pgstattuple from unpackaged fails on old installation

2012-11-14 Thread stuart
The following bug has been logged on the website: Bug reference: 7661 Logged by: Stuart Bishop Email address: stu...@stuartbishop.net PostgreSQL version: 9.1.6 Operating system: Ubuntu 12.04 Description: The pgstattuple upgrade from unpackaged script expects

Re: [BUGS] BUG #7661: pgstattuple from unpackaged fails on old installation

2012-11-14 Thread Stuart Bishop
unpackaged' has failed in 66% of up updates. Is the real solution is for the foo--unpackaged--1.0.sql script to recreate missing objects before adding them to the extension? -- Stuart Bishop stu...@stuartbishop.net http://www.stuartbishop.net/ -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #7546: Backups on hot standby cancelled despite hot_standby_feedback=on

2012-09-19 Thread Stuart Bishop
On Wed, Sep 19, 2012 at 5:45 AM, Fujii Masao masao.fu...@gmail.com wrote: On Mon, Sep 17, 2012 at 7:28 PM, stu...@stuartbishop.net wrote: The following bug has been logged on the website: Bug reference: 7546 Logged by: Stuart Bishop Email address: stu...@stuartbishop.net

Re: [BUGS] BUG #7546: Backups on hot standby cancelled despite hot_standby_feedback=on

2012-09-19 Thread Stuart Bishop
the buffer pin error in isolation. -- Stuart Bishop stu...@stuartbishop.net http://www.stuartbishop.net/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #7546: Backups on hot standby cancelled despite hot_standby_feedback=on

2012-09-19 Thread Stuart Bishop
no DDL except for the creation and dropping of temporary tables. My parser is unfortunately grep and my eyeballs to filter out the noise. -- Stuart Bishop stu...@stuartbishop.net http://www.stuartbishop.net/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

[BUGS] BUG #7546: Backups on hot standby cancelled despite hot_standby=on

2012-09-17 Thread stuart
The following bug has been logged on the website: Bug reference: 7546 Logged by: Stuart Bishop Email address: stu...@stuartbishop.net PostgreSQL version: 9.1.5 Operating system: Ubuntu 12.10 Description: I have a primary and a hot standby using streaming replication

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-29 Thread Stuart Bishop
didn't have the disk space around to keep everything, and am attempting the rebuild again now. -- Stuart Bishop stu...@stuartbishop.net http://www.stuartbishop.net/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-29 Thread Stuart Bishop
On Wed, Aug 29, 2012 at 10:59 PM, Andres Freund and...@2ndquadrant.com wrote: On Wednesday, August 29, 2012 05:32:31 PM Stuart Bishop wrote: I believe I just hit this same issue, but with PG 9.1.3: @:32407 2012-08-29 10:02:09 UTC LOG: shutting down @:32407 2012-08-29 10:02:09 UTC LOG

[BUGS] BUG #6624: Tab completion of identifier containing single backslash triggers warnings

2012-05-02 Thread stuart
The following bug has been logged on the website: Bug reference: 6624 Logged by: Stuart Bishop Email address: stu...@stuartbishop.net PostgreSQL version: 9.1.3 Operating system: Ununtu Description: psql tab completion can emit WARNING messages

Re: [BUGS] BUG #6624: Tab completion of identifier containing single backslash triggers warnings

2012-05-02 Thread Stuart Bishop
bother reporting the issue, except for the chance that this bug might have deeper impact I hadn't thought of. -- Stuart Bishop stu...@stuartbishop.net http://www.stuartbishop.net/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

[BUGS] BUG #6532: pg_upgrade fails on Python stored procedures

2012-03-15 Thread stuart
The following bug has been logged on the website: Bug reference: 6532 Logged by: Stuart Bishop Email address: stu...@stuartbishop.net PostgreSQL version: 9.1.3 Operating system: Ubuntu Description: The 9.1.3 changelog states pg_upgrade's handing of plpython stored

Re: [BUGS] BUG #6532: pg_upgrade fails on Python stored procedures

2012-03-15 Thread Stuart Bishop
build a cluster and database myself. -- Stuart Bishop stu...@stuartbishop.net http://www.stuartbishop.net/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6532: pg_upgrade fails on Python stored procedures

2012-03-15 Thread Stuart Bishop
On Thu, Mar 15, 2012 at 9:01 PM, Stuart Bishop stu...@stuartbishop.net wrote: Yes, it is there. I can see the library with the new name of plpython2.so, not the old plpython.so from 8.4. createlang installs the language just fine if I build a cluster and database myself. As expected

[BUGS] BUG #6528: pglesslog still referenced in docs, but no 9.1 support

2012-03-13 Thread stuart . bishop
The following bug has been logged on the website: Bug reference: 6528 Logged by: Stuart Bishop Email address: stuart.bis...@canonical.com PostgreSQL version: 9.1.3 Operating system: Ubuntu Description: In section 24.3.5.1 of the docs on setting up continuous

[BUGS] BUG #5857: pg_restore --clean dropping type too soon

2011-01-31 Thread Stuart Bishop
The following bug has been logged online: Bug reference: 5857 Logged by: Stuart Bishop Email address: stu...@stuartbishop.net PostgreSQL version: 8.4.6 Operating system: Ubuntu 10.10 Description:pg_restore --clean dropping type too soon Details: pg_restore --clean

[BUGS] BUG #4539: to_char(to_timestamp('...','....')) returns the wrong result

2008-11-20 Thread Stuart Green
The following bug has been logged online: Bug reference: 4539 Logged by: Stuart Green Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.11 Operating system: Centos 5 Description:to_char(to_timestamp('...','')) returns the wrong result Details: The query

[BUGS] Nasty tsvector can make dumps unrestorable

2007-09-28 Thread Stuart Bishop
tested with PG 8.2.5 under Ubuntu Feisty so far, although we found the original problem under 8.2.4 on Ubuntu Dapper. Also reported in the Ubuntu bug tracker at: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.2/+bug/146382 -- Stuart Bishop [EMAIL PROTECTED] http://www.stuartbishop.net/ \i

[BUGS] Crash 8.2.5 backend using tsearch2

2007-09-25 Thread Stuart Bishop
I've only tried reproducing this with latest released Ubuntu packages (Feisty) for 8.2.5. Also reported in the Ubuntu bug tracker too: https://bugs.launchpad.net/ubuntu/+source/postgresql/+bug/144740 -- Stuart Bishop [EMAIL PROTECTED] http://www.stuartbishop.net/ signature.asc Description

[BUGS] Results of 8.0.0 beta 2 on Red Hat Advanced Server 2.1 x86

2004-09-10 Thread Stock, Stuart [TKY]
check All tests PASSED ./configure --enable-thread-safety --with-pam --with-java --with-openssl make make check All tests PASSED We use Postgresql daily, we store a database of over 12 million rows and everything hums along nicely. Keep up the good work. -- Stuart Stock Dresdner Kleinwort

[BUGS] timeofday()::timestamp - not casting

2002-11-28 Thread Henshall, Stuart - Design Print
representation 'Thu Nov 28 11:26:46.488000 2002 G MTST' dev=# select timeofday(); timeofday --- Thu Nov 28 11:26:59.454000 2002 GMTST (1 row) - Stuart

Re: [BUGS] timeofday()::timestamp - not casting

2002-11-28 Thread Henshall, Stuart - Design Print
Title: RE: [BUGS] timeofday()::timestamp - not casting Tom Lane wrote: Henshall, Stuart - Design Print [EMAIL PROTECTED] writes: dev=# select timeofday()::timestamp; ERROR: Bad timestamp external representation 'Thu Nov 28 11:26:46.488000 2002 GMTST' It works for me. Where

[BUGS] [SQL/BUGS] (possible) inconsistent behaviour of timestamp?

2002-11-26 Thread Rison, Stuart
row) testdb2=# select timestamp 'now'; timestamptz --- 2002-11-26 13:47:47.701731+00 (1 row) The first SELECT returns a 'timestamp', but the next two return a 'timestamptz' (presumably with timezone); is this inconsitent behaviour? Cheers, Stuart. Royal

[BUGS] Interval+tz-tz gives unexpected result

2002-11-11 Thread Henshall, Stuart - Design Print
-- PostgreSQL 7.2.3 on i686-pc-cygwin, compiled by GCC 2.95.3-5 (1 row) Thank you, - Stuart

Re: [CYGWIN] [BUGS] resource leak in 7.2

2002-02-05 Thread Henshall, Stuart - WCP
There was a cygwin postgresql 7.1.3-2 release to fix a file handle problem (init_rels() not closing pg_internal.init): http://archives.postgresql.org/pgsql-cygwin/2002-01/msg00034.php which refers to: http://archives.postgresql.org/pgsql-cygwin/2002-01/msg00029.php Maybe this is it? - Stuart

Re: [BUGS] After ~Crash Sequence not correct

2001-12-20 Thread Henshall, Stuart - WCP
No. I had fsync on. - Stuart -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 18:49 To: Mikheev, Vadim Cc: Henshall, Stuart - WCP; [EMAIL PROTECTED] Subject: Re: [BUGS] After ~Crash Sequence not correct Mikheev, Vadim [EMAIL PROTECTED] writes

[BUGS] After ~Crash Sequence not correct

2001-12-19 Thread Henshall, Stuart - WCP
with Primary keys based upon the sequence where present in the table. (I *think* it was a different table sequence last time). - Stuart ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster