Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-20 Thread Bhushan Pathak
Have not faced any issues with the rhel6 RPMs. Thanks for your time & help. Regards Bhushan Pathak On Tue, Jun 10, 2014 at 4:00 PM, Bhushan Pathak wrote: > I will try the the RPMs from the rhel 6 link & post updates. > > Thanks > Bhushan Pathak > > > On Mon, J

Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-10 Thread Bhushan Pathak
I will try the the RPMs from the rhel 6 link & post updates. Thanks Bhushan Pathak On Mon, Jun 9, 2014 at 8:06 PM, Adrian Klaver wrote: > On 06/09/2014 01:53 AM, Bhushan Pathak wrote: > >> >> I do not have any earlier versions of postgres installed, neither a >> p

Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-09 Thread Bhushan Pathak
the debuginfo package for 9.2.4 version. Will it be OK to use the latest debuginfo package with the rest being on version 9.2.4? Or I will have to use all the latest RPM packages? Thanks Bhushan Pathak On Mon, Jun 9, 2014 at 3:34 PM, Devrim Gündüz wrote: > > Hi, > > On Mon, 2014-06-0

Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-09 Thread Bhushan Pathak
Bhushan Pathak On Fri, Jun 6, 2014 at 8:09 PM, Tom Lane wrote: > Bhushan Pathak writes: > >>> Stopping postgresql service: [ OK ] > >>> Starting postgresql service: [FAILED] > >>>

Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-06 Thread Bhushan Pathak
g_ctl commands work. Thanks Bhushan Pathak On Fri, Jun 6, 2014 at 5:48 AM, Adrian Klaver wrote: > On 06/05/2014 09:11 AM, Bhushan Pathak wrote: > >> It did create the data directory as well pg_log directory. I ran the >> initdb again with -d option, but it still printed the same

Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-05 Thread Bhushan Pathak
han log file 0001 DEBUG: SlruScanDirectory invoking callback on pg_subtrans/ LOG: database system is shut down DEBUG: proc_exit(0): 3 callbacks to make DEBUG: exit(0) DEBUG: shmem_exit(-1): 0 callbacks to make DEBUG: proc_exit(-1): 0 callbacks to make ok initializing pg_a

[GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-04 Thread Bhushan Pathak
t; command, it gets stuck for 5-10 minutes & then says failed. The pgstartup.log file has only 1 line - Segmentation fault (core dumped) Any idea what is going wrong? How to fix it? I'm open to try multiple installation attempts [as it is a VM & I can re-install as needed] Thanks Bhushan Pathak

Re: [GENERAL] Postgresql 9.2.4 - timezone error

2014-05-29 Thread Bhushan Pathak
ork -> /etc/localtime I deleted both the links, updated the TZ rpm package & restarted the server. That solved the issue. Thanks for your help. Bhushan On Fri, May 30, 2014 at 1:06 AM, rob stone wrote: > > > > On Thu, 2014-05-29 at 20:22 +0530, Bhushan Pathak wrote: > &g

[GENERAL] Postgresql 9.2.4 - timezone error

2014-05-29 Thread Bhushan Pathak
#x27;; ERROR: could not stat "/usr/share/zoneinfo/America/New_York": Too many levels of symbolic links What does this really mean? Why is postgresql complaining for symbolic links? Any ideas what has gone wrong? Any thing that needs checking? Thanks Bhushan Pathak

Re: [GENERAL] PostgreSQL 9.2.4 using large amount of memory

2014-01-29 Thread Bhushan Pathak
Is there any way to set max memory a postgres connection can use in postgres or linux[centOS 5.6 64bit]? Thanks Bhushan On Wed, Jan 29, 2014 at 8:39 PM, Bhushan Pathak wrote: > Bruce - > Will go through the blog posts. Thanks for the info. > > Raghav - > I have not executed an

Re: [GENERAL] PostgreSQL 9.2.4 using large amount of memory

2014-01-29 Thread Bhushan Pathak
Bruce - Will go through the blog posts. Thanks for the info. Raghav - I have not executed analyze after the upgrade. -- Bhushan On Wed, Jan 29, 2014 at 7:49 AM, Raghavendra < raghavendra@enterprisedb.com> wrote: > Thanks > > On 27 Jan 2014 22:35, "Bhushan Pathak&qu

[GENERAL] PostgreSQL 9.2.4 using large amount of memory

2014-01-27 Thread Bhushan Pathak
Hello, We have recently shifted to postgresql version 9.2.4 from 9.1.3. After the migration, we observed that some of our delete queries on single table [which have triggers, which in turn call other functions] have started consuming large amounts of memory. In 9.1.3, this usage was upto 25MB wit