[HACKERS] pg_migrator issue with contrib

2009-06-05 Thread Brad Nicholson
/home/postgres/pg_migrator_dump_db.sql --dbname template1 /dev/null pg_migrator exits leaving me with a corrupted 8.3 instance. At the very least, a mention in the documentation of incompatible contrib module(s) would be nice. Even better would be a sanity check added to prevent this. -- Brad

Re: [HACKERS] pg_migrator issue with contrib

2009-06-05 Thread Brad Nicholson
On Fri, 2009-06-05 at 15:50 -0400, Bruce Momjian wrote: Brad Nicholson wrote: I've been kicking the tires on this a bit, and I've found an issue when dealing with contrib/ (specifically dblink, although I haven't looked around anymore). dblink_current_query() is not in the 8.4 version

Re: [HACKERS] Enabling archive_mode without restart

2008-10-31 Thread Brad Nicholson
, in the minds of many people. I put my hand up as one of those people. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] Garbled postgres logs

2007-04-03 Thread Brad Nicholson
the difference is caused by a difference in where the postmaster's stderr originally pointed --- was this postmaster started in a different fashion than the others? No. Standard init script was used to start all clusters. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp

Re: [HACKERS] Index corruption

2006-06-30 Thread Brad Nicholson
-archive/linux-kernel/msg05313.html http://lkml.org/lkml/2006/3/1/381 I don't know the kernel nearly well enough to guess if these are related ... It may or may not be the same issue, but for what it's worth, we've seen the same sl_log_1 corruption on AIX 5.1 and 5.3 -- Brad Nicholson 416-673

Re: [HACKERS] Index corruption

2006-06-30 Thread Brad Nicholson
Brad Nicholson wrote: Tom Lane wrote: Marc Munro [EMAIL PROTECTED] writes: I'll get back to you with kernel build information tomorrow. We'll also try to talk to some kernel hackers about this. Some googling turned up recent discussions about race conditions in Linux NFS code: http

Re: [HACKERS] Index corruption

2006-06-30 Thread Brad Nicholson
Tom Lane wrote: Brad Nicholson [EMAIL PROTECTED] writes: It may or may not be the same issue, but for what it's worth, we've seen the same sl_log_1 corruption on AIX 5.1 and 5.3 Hm, on what filesystem, and what PG version(s)? I'm not completely satisfied by the its-a-kernel-bug theory

[HACKERS] Vacuum Blocking A Deleteion - Why?

2006-01-04 Thread Brad Nicholson
) at main.c:214 #21 0x1204 in __start () (gdb) quit The program is running. Quit anyway (and detach it)? (y or n) y Detaching from program: , process 1425438 -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp. ---(end of broadcast

Re: Learning curves and such (was Re: [HACKERS] pgFoundry)

2005-05-18 Thread Brad Nicholson
Oleg Bartunov wrote: Joshua, does RT has full support of PostgreSQL ? It support's Postgres, but it uses a dynamic query builder that is pretty brain dead. It only implements features that are cross DB compatible. It comes up with some pretty ugly queries. -- Brad Nicholson 416-673-4106

[HACKERS] Port Report: Linux SuSE Enterprise Server 9 (x86_64)

2005-01-13 Thread Brad Nicholson
./configure --enable-debug --with-perl == All 96 tests passed. == uname -a Linux richard 2.6.5-7.111.19-smp #1 SMP Fri Dec 10 15:10:58 UTC 2004 x86_64 x86_64 x86_64 GNU/Linux -- Brad Nicholson Database Administrator, Afilias Canada Corp

[HACKERS] V8.0rc1 On AIX.

2004-12-14 Thread Brad Nicholson
AIX 5.1 I applied Bruce's patch, configured with --enable-thread-safety and everything went smoothly. == All 96 tests passed. == Brad. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to

[HACKERS] V8 Beta 5 on AIX

2004-12-06 Thread Brad Nicholson
I tried compliling v8 beta 5 (grabbed from cvs on Friday) on AIX 5.1. It fails during the make make[4]: Entering directory `/opt/OXRS/Sources/pgsql-HEAD/src/interfaces/libpq' make[4]: Nothing to be done for `all'. make[4]: Leaving directory `/opt/OXRS/Sources/pgsql-HEAD/src/interfaces/libpq'

Re: [HACKERS] V8 Beta 5 on AIX

2004-12-06 Thread Brad Nicholson
Bruce Momjian wrote: Brad Nicholson wrote: I tried compliling v8 beta 5 (grabbed from cvs on Friday) on AIX 5.1. It fails during the make make[4]: Entering directory `/opt/OXRS/Sources/pgsql-HEAD/src/interfaces/libpq' make[4]: Nothing to be done for `all'. make[4]: Leaving directory `/opt

Re: [HACKERS] V8 Beta 5 on AIX

2004-12-06 Thread Brad Nicholson
Bruce Momjian wrote: Brad Nicholson wrote: OK, I assume you used --enable-thread-safety in configure. Correct. This should have added some PTHREAD link flags to your libpq build, and those settings should have followed the libpq library into your pg_ctl link line. Would you look

[HACKERS] AIX and V8 beta 3

2004-09-30 Thread Brad Nicholson
Tried to install this on AIX 5.1, no luck (compiles fine without --enable-thread-safety though) . AIX 5.1 gcc 3.3.2 ./configure --prefix=/opt/dbs/pgsql800b3-AIX51-2004-09-30