Re: [ADMIN] parallel option in pg_restore

2010-06-23 Thread Glyn Astill
--- On Tue, 22/6/10, Kevin Grittner wrote: > Glyn Astill > wrote: > > > so far I can only get the same error with large dump > files. > > "Large" being a relative term -- > ever see it on a file smaller than 2GB? > Good point. No I've not seen it on a file smaller than 2GB, but the test I

Re: [ADMIN] Unable to start Statistics Collector

2010-06-23 Thread sivakumar krishnamurthy
> > 2010-04-08 17:30:41 ISTLOG: could not receive test message on socket for > statistics collector: Connection refused > 2010-04-08 17:30:41 ISTLOG: disabling statistics collector for lack of > working socket > > I remember having the same problem last week and after debugging found that my loop

Re: [ADMIN] db recovery after raid5 failure

2010-06-23 Thread Kevin Grittner
Balkrishna Sharma wrote: >> average about two drive failures a month > You must be having a real huge postgres setup with several hundreds > of drives to have such high frequency of failure. About 100 database servers with over 1000 drives spinning 24/7. Also probably significant, managemen

Re: [ADMIN] Unable to start Statistics Collector

2010-06-23 Thread Senthil Kumar G
Hi I executed follows. I am able to ping. >ping 127.0.0.1 PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data. 64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.052 ms 64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.057 ms 64 bytes from 127.0.0.1: icmp_seq=3 ttl=64 time=0.059 ms Plea

Re: [ADMIN] Unable to start Statistics Collector

2010-06-23 Thread Kevin Grittner
"Senthil Kumar G" wrote: > sivakumar krishnamurthy wrote: >>> 2010-04-08 17:30:41 ISTLOG: could not receive test message on >>> socket for statistics collector: Connection refused >>> 2010-04-08 17:30:41 ISTLOG: disabling statistics collector for >>> lack of working socket >> >> I remember h

Re: [ADMIN] parallel option in pg_restore

2010-06-23 Thread Tom Lane
Glyn Astill writes: > Good point. No I've not seen it on a file smaller than 2GB, but the test I > did was pretty basic - I just trimmed down the size of all of my tables to > create a dump that was only 50Mb or so. It looks like Igor has a > reproduceable case now though, so hopefully Tom ca

Re: [ADMIN] parallel option in pg_restore

2010-06-23 Thread Glyn Astill
--- On Wed, 23/6/10, Tom Lane wrote: > Glyn Astill > writes: > > Good point.  No I've not seen it on a file > smaller than 2GB, but the test I did was pretty basic - I > just trimmed down the size of all of my tables to create a > dump that was only 50Mb or so.  It looks like Igor has > a reprodu

R: [ADMIN] Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

2010-06-23 Thread Cassiano, Marco
Thank you Bruce, I applied the patch and found two things you might want to take in consideration : 1) dump.c Line 25 should be : SYSTEMQUOTE, ctx->new.bindir, ctx->old.port, ctx->user, ctx->output_dir); And not SYSTEMQUOTE, ctx->new.bindir, ctx->old.port, ctx->user, ctx->cwd); (sorry, I'm

Re: [ADMIN] Unable to start Statistics Collector

2010-06-23 Thread Alvaro Herrera
Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400 2010: > Hi > > > > I executed follows. I am able to ping. > > >ping 127.0.0.1 So can you ping localhost? -- Álvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Develop

Re: [ADMIN] Unable to start Statistics Collector

2010-06-23 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Senthil Kumar G's message of mié jun 23 07:59:26 -0400 2010: >> I executed follows. I am able to ping. >> ping 127.0.0.1 > So can you ping localhost? I'm betting the problem is kernel-level filter rules that let through ping packets but not the stats colle

Re: [TESTERS] R: [ADMIN] Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

2010-06-23 Thread Bruce Momjian
Cassiano, Marco wrote: > Thank you Bruce, > > I applied the patch and found two things you might want to take in > consideration : > > 1) dump.c Line 25 should be : > > SYSTEMQUOTE, ctx->new.bindir, ctx->old.port, ctx->user, ctx->output_dir); > > And not > > SYSTEMQUOTE, ctx->new.bindir, ct

Re: [ADMIN] Need recommendation for PostgreSQL core developer/PostgreSQL admin

2010-06-23 Thread Bruce Momjian
Vineet Jain wrote: > Hi, > > Can someone recommend a PostgreSQL core developer/or experienced admin who > does some on demand consulting. I would like to purchase a 10-20 hours of > support and get support with implementation/questions/best practices on > replication/table space layout/performance

Re: [ADMIN] redhat and postgresql management

2010-06-23 Thread David Bear
Thank you all. This group is amazingly helpful. The combinations of emails and the document linked below did the trick. On Fri, Jun 18, 2010 at 10:40 AM, Greg Smith wrote: > David Bear wrote: > >> I have RHEL 5.4 (64bit) that has a postgresql-lib 8.1 installed to satisfy >> dependancy for a doze

Re: [ADMIN] Unable to start Statistics Collector

2010-06-23 Thread rafael
Rtt BlackBerry de movistar, allí donde estés está tu oficin@ -Original Message- From: Alvaro Herrera Sender: pgsql-admin-ow...@postgresql.org Date: Wed, 23 Jun 2010 13:11:44 To: Senthil Kumar G Cc: sivakumar krishnamurthy; Kevin Grittner; pgsql-admin Subject: Re: [ADMIN] Unable to start

Re: [ADMIN] Unable to start Statistics Collector

2010-06-23 Thread rafael
Rrtrtt BlackBerry de movistar, allí donde estés está tu oficin@ -Original Message- From: Alvaro Herrera Sender: pgsql-admin-ow...@postgresql.org Date: Wed, 23 Jun 2010 13:11:44 To: Senthil Kumar G Cc: sivakumar krishnamurthy; Kevin Grittner; pgsql-admin Subject: Re: [ADMIN] Unable to st

Re: [ADMIN] Unable to start Statistics Collector

2010-06-23 Thread Senthil Kumar G
Hi I am able to ping localhost also. ping localhost PING localhost (127.0.0.1) 56(84) bytes of data. 64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.037 ms 64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.026 ms 64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 ti