Re: [ADMIN] pg_dump on Postgres 9.1

2012-08-01 Thread Alanoly Andrews
, at least for binaries created from it for AIX (6.1). Regards. Alanoly. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Friday, July 27, 2012 12:13 PM To: Alanoly Andrews Cc: 'pgsql-admin@postgresql.org' Subject: Re: [ADMIN] pg_dump on Postgres 9.1 Alanoly Andrews alano

[ADMIN] pg_dump on Postgres 9.1

2012-07-27 Thread Alanoly Andrews
Hello, Is there any reported bug with pg_dump in Postgres 9.1, on AIX ? The following command hangs for ever and has to be interrupted. It creates a zero-length file. pg_dump -Fc alan1 alan1.dmp If I run the command in the verbose mode, I see that it stops at saving database definition.

[ADMIN] WAL archiving to two locations in warm standby

2011-07-18 Thread Alanoly Andrews
if the failure was in the remote copy. Is there a way to achive this through the archive_command or otherwise? Thanks. Alanoly Andrews (alano...@invera.com) This e-mail may be privileged and/or confidential, and the sender does not waive any related

[ADMIN] Warm Standby on 8.4.7

2011-04-13 Thread Alanoly Andrews
Hello, Is it possible to set up a warm standby pair of postgres instances without using the pg_standby utility? The PG manuals appear to say it is possible. But I don't see the details of how to set this up. How do you keep the standby instance in permanent recovery mode? Thanks. Alanoly.

[ADMIN] Out of memory during index creation

2011-04-11 Thread Alanoly Andrews
tablespace defined (with the temp_tablespaces) parameter. The disk area for this tablespace had about 2GB of free space available. But the sort does not seem to have used it. Thanks. Alanoly Andrews. This e-mail may be privileged

[ADMIN] Bidirectional index traversal

2010-09-16 Thread Alanoly Andrews
Hello, I'd like to know whether Postgres (8.4) supports bidirectional traversal of indexes. Thanks. Alanoly. This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any

Re: [ADMIN] Bidirectional index traversal

2010-09-16 Thread Alanoly Andrews
: Thursday, September 16, 2010 10:57 AM To: Alanoly Andrews Cc: 'pgsql-admin@postgresql.org' Subject: Re: [ADMIN] Bidirectional index traversal Alanoly Andrews alano...@invera.com writes: I'd like to know whether Postgres (8.4) supports bidirectional traversal of indexes. If you defined exactly

Re: [ADMIN] [HACKERS] HS/SR on AIX

2010-08-27 Thread Alanoly Andrews
, 2010 1:44 AM To: Steve Singer Cc: Tom Lane; PostgreSQL-development Hackers; Alanoly Andrews Subject: Re: [HACKERS] HS/SR on AIX On Thu, Aug 26, 2010 at 12:45 AM, Steve Singer ssin...@ca.afilias.info wrote: A clean build from the beta4 source tarball where I'm careful to install into a clean (ie

Re: [HACKERS] [ADMIN] postgres 9.0 crash when bringing up hot standby

2010-08-11 Thread Alanoly Andrews
the compilation: --without-readline --without-zlib--enable-debug --enable-cassert --enable-thread-safety Thanks. Alanoly. -Original Message- From: Robert Haas [mailto:robertmh...@gmail.com] Sent: Wednesday, August 11, 2010 10:13 AM To: Heikki Linnakangas Cc: Alanoly Andrews

[ADMIN] postgres 9.0 crash when bringing up hot standby

2010-08-06 Thread Alanoly Andrews
will be much appreciated. Thanks. Alanoly Andrews (alano...@invera.commailto:alano...@invera.com) Senior Software Engineer Invera Inc. Montreal, QC This e-mail may be privileged and/or confidential, and the sender does not waive any related rights

Re: [ADMIN] postgres 9.0 crash when bringing up hot standby

2010-08-06 Thread Alanoly Andrews
Thanks. Yes, the LOAD command does work, on another database cluster on the same AIX machine. -Original Message- From: Fujii Masao [mailto:masao.fu...@gmail.com] Sent: Friday, August 06, 2010 10:31 AM To: Alanoly Andrews Cc: pgsql-admin@postgresql.org; PostgreSQL-development Subject: Re