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
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
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'
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
"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
Is there some way to query the data-type of ''?
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
> 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