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

2010-08-11 Thread Robert Haas
On Fri, Aug 6, 2010 at 3:53 PM, Heikki Linnakangas wrote: > So, loading libpqwalreceiver library crashes. It looks like it might be > pthread-related. Perhaps something wrong with our makefiles, causing > libpqwalreceiver to be built with wrong flags? Does contrib/dblink work? If > you look at the

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

2010-08-11 Thread Robert Haas
On Wed, Aug 11, 2010 at 10:20 AM, Alanoly Andrews wrote: > Ok..in response to the questions from Heikki, > > 1. Yes, "contrib/dblink" does work. Here's the output from the command used > to "make" dblink: >      postgres:thimar> /usr/bin/gmake -C contrib/dblink install >      gmake: Entering dire

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

2010-08-11 Thread Alanoly Andrews
Ok..in response to the questions from Heikki, 1. Yes, "contrib/dblink" does work. Here's the output from the command used to "make" dblink: postgres:thimar> /usr/bin/gmake -C contrib/dblink install gmake: Entering directory `/dinabkp/faouzis/postgresql-9.0beta1/contrib/dblink'

Re: [ADMIN] Autovacuum daemon internal handling

2010-08-11 Thread Alvaro Herrera
Excerpts from Gnanakumar's message of mié ago 11 01:07:08 -0400 2010: Hi, > 1. Does autovacuum daemon works with one table at a time or does it work > with multiple tables at the same time? Only one. > Reason to ask this question is, let's say I've "autovacuum_naptime" set to 1 > minute, and t

Re: [ADMIN] Autovacuum daemon internal handling

2010-08-11 Thread Kevin Grittner
"Gnanakumar" wrote: > Our production server is running PostgreSQL v8.2.3 There are a lot of bug fixes and security fixes you're missing by not using a recent minor release: http://www.postgresql.org/support/versioning http://www.postgresql.org/docs/8.2/static/release.html -Kevin -- Sen

[ADMIN] how do i query the type of an object?

2010-08-11 Thread Mark Rostron
Is there some way to query the data-type of ''?

Re: [ADMIN] how do i query the type of an object?

2010-08-11 Thread Tom Lane
Mark Rostron writes: > Is there some way to query the data-type of ''? There's a SQL-standard construct called IS OF, and a function called pg_typeof, but it's not real clear whether either of those would help you. regards, tom lane -- Sent via pgsql-admin mailing list

Re: [ADMIN] Autovacuum daemon internal handling

2010-08-11 Thread Gnanakumar
> in 8.2 "naptime" means "time to sleep after we finish a job". So even > if the previous task takes an hour, it will still sleep a minute before > doing another round. (Note that this setting has a different meaning in > later releases). I couldn’t understand the difference in meaning of "autov