Re: [ADMIN] pg_dump on Postgres 9.1

2012-08-01 Thread Alanoly Andrews
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 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
ation succeeded and to NOT re-try 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/o

[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
rnal sort)? I have a temporaray 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

Re: [ADMIN] Bidirectional index traversal

2010-09-16 Thread Alanoly Andrews
o:t...@sss.pgh.pa.us] Sent: Thursday, September 16, 2010 10:57 AM To: Alanoly Andrews Cc: 'pgsql-admin@postgresql.org' Subject: Re: [ADMIN] Bidirectional index traversal Alanoly Andrews writes: > I'd like to know whether Postgres (8.4) supports bidirectional traversal of >

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

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

2010-08-27 Thread Alanoly Andrews
1391 in "postmaster.c" ServerLoop(), line 1391 in "postmaster.c" PostmasterMain(argc = 1, argv = 0x0001102aa4b0), line 1092 in "postmaster.c" main(argc = 1, argv = 0x0001102aa4b0), line 188 in "main.c" Alanoly. -Original Message- From: Steve Si

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

2010-08-27 Thread Alanoly Andrews
August 26, 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 wrote: > A clean build from the beta4 source tarball where I'm careful to install > into a clean (ie n

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

2010-08-11 Thread Alanoly Andrews
ular make files supplied along with the postgres source code. The following flags were added during the compilation: --without-readline --without-zlib--enable-debug --enable-cassert --enable-thread-safety Thanks. Alanoly. -Original Message- From: Robert Haas [mailto:robertmh...@gma

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

[ADMIN] postgres 9.0 crash when bringing up hot standby

2010-08-06 Thread Alanoly Andrews
t; PostmasterMain(argc = 1, argv = 0x0001102aa4b0), line 1092 in "postmaster.c" main(argc = 1, argv = 0x0001102aa4b0), line 188 in "main.c" Any pointers on how to resolve the issue will be much appreciated. Thanks. Alanoly Andrews (alano...@invera.com<mailto:alano...