[BUGS] BUG #7493: Postmaster messages are unreadable in a Windows console

2012-08-14 Thread exclusion
The following bug has been logged on the website: Bug reference: 7493 Logged by: Alexander LAW Email address: exclus...@gmail.com PostgreSQL version: 9.1.4 Operating system: Windows Description: When I disable logging collector and try to run postmaster in a command l

Re: [BUGS] BUG #7493: Postmaster messages are unreadable in a Windows console

2012-08-14 Thread Alexander Law
Hello, while trying to set consistent log encoding (following the discussion http://archives.postgresql.org/message-id/5006D340.4000808%40gmail.com), I discovered a few bugs, that IMHO should be fixed before. When I disable logging collector and try to run postmaster in a command line, I get no

Re: [BUGS] BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows

2012-08-14 Thread Rikard Pavelic
On 8.8.2012. 13:30, Craig Ringer wrote: > On 08/08/2012 06:24 PM, rikard.pave...@zg.htnet.hr wrote: >> The following bug has been logged on the website: >> >> Bug reference: 7485 >> Logged by: Rikard Pavelic >> Email address: rikard.pave...@zg.htnet.hr >> PostgreSQL version: Unsu

[BUGS] Possible memory leak/memory issue in pg_dump

2012-08-14 Thread Joe Tennant
While browsing the code, "pg_dump.c" the following block *appears* to be problematic. Additionally, there *appears* to be a malloc without a free (return or assignment) in the function "getBlobs(Archive *AH)" (pg_dump.c lines 2169 thru 2188 v9.1.4). /* * Each large object has its own BLOB archive

Re: [BUGS] BUG #6150: commit_delay should have unit ms

2012-08-14 Thread Bruce Momjian
On Thu, Aug 4, 2011 at 09:30:35PM +, Christoph Anton Mitterer wrote: > > The following bug has been logged online: > > Bug reference: 6150 > Logged by: Christoph Anton Mitterer > Email address: cales...@scientia.net > PostgreSQL version: 0.9 > Operating system: Debian si

Re: [BUGS] BUG #6150: commit_delay should have unit ms

2012-08-14 Thread Bruce Momjian
On Tue, Aug 14, 2012 at 04:18:40PM -0400, Bruce Momjian wrote: > On Thu, Aug 4, 2011 at 09:30:35PM +, Christoph Anton Mitterer wrote: > > > > The following bug has been logged online: > > > > Bug reference: 6150 > > Logged by: Christoph Anton Mitterer > > Email address: ca

[BUGS] ERROR - Upgrading Postgresql 8.4.3 to Postgressql 9.1.4

2012-08-14 Thread Freddie Burgess
We are trying to upgrade our production postgres database instance that is approximately 4TB in size and it contains various table partition structures.; a separate tablespace for each partition. We were initially successful in performing the upgrade using pg_upgrade with both the link and copy o

Re: [BUGS] ERROR - Upgrading Postgresql 8.4.3 to Postgressql 9.1.4

2012-08-14 Thread Bruce Momjian
On Tue, Aug 14, 2012 at 04:27:45PM -0400, Freddie Burgess wrote: > We are trying to upgrade our production postgres database instance that is > approximately 4TB in size and it contains various table partition structures.; > a separate tablespace for each partition. We were initially successful i

Re: [BUGS] BUG #6150: commit_delay should have unit ms

2012-08-14 Thread Tom Lane
Bruce Momjian writes: > Opps, turns out the units are microseconds (as pointed out to me by > Magnus), and we don't have a microsecond designation in that file, so I > reverted that and just added a C comment about why it has no units. Is it worth adding support for microseconds in there? Not su

Re: [BUGS] BUG #6150: commit_delay should have unit ms

2012-08-14 Thread Bruce Momjian
On Tue, Aug 14, 2012 at 05:26:39PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > Opps, turns out the units are microseconds (as pointed out to me by > > Magnus), and we don't have a microsecond designation in that file, so I > > reverted that and just added a C comment about why it has no uni

Re: [BUGS] Possible memory leak/memory issue in pg_dump

2012-08-14 Thread Tom Lane
Joe Tennant writes: > While browsing the code, "pg_dump.c" the following block *appears* to > be problematic. Additionally, there *appears* to be a malloc without a > free (return or assignment) in the function "getBlobs(Archive *AH)" > (pg_dump.c lines 2169 thru 2188 v9.1.4). All those data stru

Re: [BUGS] BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows

2012-08-14 Thread Craig Ringer
On 08/14/2012 11:42 PM, Rikard Pavelic wrote: On 8.8.2012. 13:30, Craig Ringer wrote: On 08/08/2012 06:24 PM, rikard.pave...@zg.htnet.hr wrote: The following bug has been logged on the website: Bug reference: 7485 Logged by: Rikard Pavelic Email address: rikard.pave...@zg.ht

[BUGS] ERROR - CREATE GIST INDEX on 9.2 beta3

2012-08-14 Thread Zdeněk Jílovec
Hello, I use PostgreSQL 9.2beta3 with PostGIS 2.0.1 and if I try create GIST index on column geometry(Point,2065) I get error: test=> CREATE INDEX places_point ON places USING GIST(def_point); ERROR: failed to re-find parent for block 18097 It works on 9.1 I can send a table dump (43 MB - bzip

Re: [BUGS] ERROR - CREATE GIST INDEX on 9.2 beta3

2012-08-14 Thread Heikki Linnakangas
On 15.08.2012 01:02, Zdeněk Jílovec wrote: Hello, I use PostgreSQL 9.2beta3 with PostGIS 2.0.1 and if I try create GIST index on column geometry(Point,2065) I get error: test=> CREATE INDEX places_point ON places USING GIST(def_point); ERROR: failed to re-find parent for block 18097 It works