[ADMIN] Re: Delay in completion of aggregation inserts when run in a single commit - PG 9.1.2

2012-07-05 Thread Akash
2147483647 pg_toast_33085_index | 2147483647 pg_toast_32135_index | 2147483647 pg_toast_33120_index | 2147483647 .. There are many more. Regards, Akash. -- View this message in context: http://postgresql.1045698.n5.

[ADMIN] Delay in completion of aggregation inserts when run in a single commit - PG 9.1.2

2012-07-04 Thread Akash Kodibail
f remains untouched, except for log writing which has been made to "all". Any info greatly appreciated. Thanks in advance, Akash. DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for

[ADMIN] SET search path

2011-10-31 Thread Akash Kodibail
, however, when I do so, the search_path is set only for that session, it is not a permanent change that is done. Can you please guide me as to how to make it permanent. After I do a set search_path, pg_user view does not show any entry in the column "useconfig" for the same being set. Rega

Re: [ADMIN] Postgres Server crashed

2011-10-11 Thread Akash Kodibail
or all the support. Next destination postgres documentation. :-) Many thanks and Regards, Akash. -Original Message----- From: Akash Kodibail Sent: Tuesday, October 11, 2011 1:02 AM To: 'Scott Marlowe' Cc: Kevin Grittner; pgsql-admin@postgresql.org Subject: RE: [ADMIN] Postgres Server c

Re: [ADMIN] Postgres Server crashed

2011-10-10 Thread Akash Kodibail
might have to be set for pg_resetxlog. Backing up is still in progress, so will try my luck with pg_resetxlog. Regards, Akash. -Original Message- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Tuesday, October 11, 2011 12:41 AM To: Akash Kodibail Cc: Kevin Grittner; pgsql

Re: [ADMIN] Postgres Server crashed

2011-10-10 Thread Akash Kodibail
I was hopeful of restoring the data from data files in $PGDATA path. I read this article about PITR using the recovery.conf, But I am not aware of the pre-requisites and not entirely sure about the concept beneath this. Would it not be possible? Regards, Akash. -Original Message- From

Re: [ADMIN] Postgres Server crashed

2011-10-10 Thread Akash Kodibail
nt sure has taught me a lesson. pg_clog and pg_xlog are untouched. Thanks and Regards, Akash. -Original Message- From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] Sent: Monday, October 10, 2011 10:47 PM To: Akash Kodibail; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres

[ADMIN] Postgres Server crashed

2011-10-10 Thread Akash Kodibail
d the DATAPATH still says 163 GB is utilized. When trying to take a pg_dump, it says : pg_dump: schema with OID 29257 does not exist, this OID is there in pg_type, but not there in any other catalog tables. Please help me!! Regards, Akash. DISCLAIMER: The inform