On 11/10/10 6:08 PM, Devrim GÜNDÜZ wrote:
On Wed, 2010-11-10 at 09:30 -0800, Jason wrote:
Is 8.2.3 still available anywhere on the PostgreSQL site? I couldn't
find it.
Please check ftp-archives.postgresql.org
ah, its back up now
ftp://ftp-archives.postgresql.org/pub/source/v8.2.3/
--
Se
On Wed, 2010-11-10 at 09:30 -0800, Jason wrote:
>
> Is 8.2.3 still available anywhere on the PostgreSQL site? I couldn't
> find it.
Please check ftp-archives.postgresql.org
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpm
On 10 Nov 2010, at 18:30, Jason wrote:
> Thanks for the replies.
>
> Yes - we're aware that there are newer versions of PostgreSQL out there. If
> it were completely up to us we would be using 8.2.18 or even 8.4. The
> problem is - we need to install on a network that has a rather involved
> ap
Jason writes:
> Yes - we're aware that there are newer versions of PostgreSQL out there. If
> it were completely up to us we would be using 8.2.18 or even 8.4. The
> problem is - we need to install on a network that has a rather involved
> approval process for all software tools that are introdu
On 10 November 2010 17:30, Jason wrote:
>
> Thanks for the replies.
>
> Yes - we're aware that there are newer versions of PostgreSQL out there. If
> it were completely up to us we would be using 8.2.18 or even 8.4. The
> problem is - we need to install on a network that has a rather involved
>
On 11/10/10 9:30 AM, Jason wrote:
Thanks for the replies.
Yes - we're aware that there are newer versions of PostgreSQL out there. If
it were completely up to us we would be using 8.2.18 or even 8.4. The
problem is - we need to install on a network that has a rather involved
approval process f
On 10/11/2010 17:30, Jason wrote:
Thanks for the replies.
Yes - we're aware that there are newer versions of PostgreSQL out there. If
it were completely up to us we would be using 8.2.18 or even 8.4. The
problem is - we need to install on a network that has a rather involved
approval process
On Wed, Nov 10, 2010 at 09:30:46AM -0800, Jason wrote:
>
> Thanks for the replies.
>
> Yes - we're aware that there are newer versions of PostgreSQL out there. If
> it were completely up to us we would be using 8.2.18 or even 8.4. The
> problem is - we need to install on a network that has a ra
Thanks for the replies.
Yes - we're aware that there are newer versions of PostgreSQL out there. If
it were completely up to us we would be using 8.2.18 or even 8.4. The
problem is - we need to install on a network that has a rather involved
approval process for all software tools that are intr
Raymond O'Donnell wrote:
> On 10/11/2010 16:31, Jason wrote:
>>
>> Hi - I'm trying to find where I can download PostgreSQL 8.2.3.
>>
>> I've looked on the PostgreSQL website but I do not see version 8.2.3
>> specifically.
>
> I'm sure you're going to get a tonne of replies pointing out that you
On 11/10/10 8:31 AM, Jason wrote:
Hi - I'm trying to find where I can download PostgreSQL 8.2.3.
I've looked on the PostgreSQL website but I do not see version 8.2.3
specifically.
Any help would be appreciated.
thats a rather old (feb 2007) and fairly buggy release. 8.2.18 is the
current 8
On 10/11/2010 16:31, Jason wrote:
Hi - I'm trying to find where I can download PostgreSQL 8.2.3.
I've looked on the PostgreSQL website but I do not see version 8.2.3
specifically.
I'm sure you're going to get a tonne of replies pointing out that you
should use 8.2.18, which is 15 releases' w
Hi - I'm trying to find where I can download PostgreSQL 8.2.3.
I've looked on the PostgreSQL website but I do not see version 8.2.3
specifically.
Any help would be appreciated.
Thanks,
Jason
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-8-2-3-tp3258962p32
Hi Tom & Alvaro,
> Hey,
>
> > > They are all under 200 million
> >
> > Weird
> >
> > Could you fetch from pg_stat_activity the table it's processing, and its
> > pg_class row and that of its toast table (if any)?
>
> Sorry for the delay. Required details are at
> http://pastebin.com/pastebin.php?d
Hey,
> > They are all under 200 million
>
> Weird
>
> Could you fetch from pg_stat_activity the table it's processing, and its
> pg_class row and that of its toast table (if any)?
Sorry for the delay. Required details are at
http://pastebin.com/pastebin.php?dl=fd699fbb
Let me know if you need
Hi,
Tom Lane sss.pgh.pa.us> writes:
> Dushyanth gmail.com> writes:
> >> Tom Lane sss.pgh.pa.us> writes:
> >> Then the only other possibility is that autovacuum is being launched to
> >> prevent XID wraparound. Are there any tables in that database with
> >> particularly old relfrozenxid?
>
>
Dushyanth <[EMAIL PROTECTED]> writes:
>> Tom Lane sss.pgh.pa.us> writes:
>> Then the only other possibility is that autovacuum is being launched to
>> prevent XID wraparound. Are there any tables in that database with
>> particularly old relfrozenxid?
> Below are the unique age(relfrozenxid) val
Dushyanth escribió:
> Below are the unique age(relfrozenxid) values that i see from the above query
>
> # psql -U postgres -d dbname -c "select relname, age(relfrozenxid) from
> pg_class
> where relkind in ( 'r', 't') order by 2 desc;" | awk '{print $3}' | sort |
> uniq
>
> 140835139
> 1509457
Hey,
> Tom Lane sss.pgh.pa.us> writes:
> > Dushyanth gmail.com> writes:
> >> Does "show autovacuum" confirm that it's off?
>
> > Yes.
>
> > # show autovacuum;
> > autovacuum
> >
> > off
> > (1 row)
>
> Then the only other possibility is that autovacuum is being launched to
> pr
Dushyanth <[EMAIL PROTECTED]> writes:
>> Does "show autovacuum" confirm that it's off?
> Yes.
> # show autovacuum;
> autovacuum
>
> off
> (1 row)
Then the only other possibility is that autovacuum is being launched to
prevent XID wraparound. Are there any tables in that database
Hi,
Tom Lane sss.pgh.pa.us> writes:
> dushy gmail.com> writes:
> > On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver comcast.net>
wrote:
> >> One question? Did you do pg_ctl reload after changing the config file?
>
> > I did not change any config yet - autovacuum was always disabled since
> > th
dushy <[EMAIL PROTECTED]> writes:
> On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote:
>> One question? Did you do pg_ctl reload after changing the config file?
> I did not change any config yet - autovacuum was always disabled since
> the day PG was set up.
A mistake here
Hey,
There is only one autovacuum process when it starts up. Below is the
correct output from one of the logs
Good.
Do you have entries in the pg_autovacuum table in this database?
No. Its empty.
TIA
Dushyanth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
dushy escribió:
> My bad - I messed up the above. I grepped for autovacuum in my process
> logs and included all matches.
Ah, ok -- that makes more sense.
> There is only one autovacuum process when it starts up. Below is the
> correct output from one of the logs
Good.
Do you have entries in t
Hey,
>> # autovacuum processes
>>
>> postgres 16508 9.2 0.1 2310836 37984 ? Ds 09:58 0:09 \_ postgres:
>> autovacuum process db1
>> postgres 19626 7.2 0.0 2289524 27704 ? Ds 10:09 0:03 \_ postgres:
>> autovacuum process db1
>> postgres 20861 7.8 0.0 2298844 31028 ?
Hey,
On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote:
>
> Am forwarding back to list.
> One question? Did you do pg_ctl reload after changing the config file?
I did not change any config yet - autovacuum was always disabled since
the day PG was set up.
Thanks
Dushyanth
Dushyanth escribió:
> # autovacuum processes
>
> postgres 16508 9.2 0.1 2310836 37984 ? Ds 09:58 0:09 \_ postgres:
> autovacuum process db1
> postgres 19626 7.2 0.0 2289524 27704 ? Ds 10:09 0:03 \_ postgres:
> autovacuum process db1
> postgres 20861 7.8 0.0 2298844 310
-- Forwarded Message --
Subject: Re: [GENERAL] [Postgresql 8.2.3] autovacuum starting up even after
disabling ?
Date: Friday 04 July 2008 9:51 am
From: dushy <[EMAIL PROTECTED]>
To: "Adrian Klaver" <[EMAIL PROTECTED]>
Hey,
Thanks for the quick r
On Friday 04 July 2008 7:51 am, Dushyanth wrote:
> Hey all,
>
> Iam using PostgreSQL 8.2.3 on RHEL4 (Linux 2.6.20.3-custom #4 SMP x86_64
> x86_64 x86_64 GNU/Linux).
>
> I have autovacuum tunrned off in the config, but it still seems to start up
> once everyday. What could be the cause of this ?
>
>
Hey all,
Iam using PostgreSQL 8.2.3 on RHEL4 (Linux 2.6.20.3-custom #4 SMP x86_64 x86_64
x86_64 GNU/Linux).
I have autovacuum tunrned off in the config, but it still seems to start up once
everyday. What could be the cause of this ?
TIA
Dushyanth
$ psql -U postgres
postgres=# show autovacuum;
On Fri, Mar 16, 2007 at 07:06:57PM -, Bruce McAlister wrote:
> Okay, I'm getting a little further now. I'm about to create entries in the
> pg_autovacuum system tables. However, I'm a little confused as to how I go
> about finding out the OID value of the tables. The pg_autovacuum table
> re
On Mar 16, 2007, at 2:06 PM, Bruce McAlister wrote:
Hi All,
Okay, I'm getting a little further now. I'm about to create entries
in the
pg_autovacuum system tables. However, I'm a little confused as to
how I go
about finding out the OID value of the tables. The pg_autovacuum table
requires
Hi All,
Okay, I'm getting a little further now. I'm about to create entries in the
pg_autovacuum system tables. However, I'm a little confused as to how I go
about finding out the OID value of the tables. The pg_autovacuum table
requires the OID of the table you want to create settings for (vac
Hi,
Have tried putting the JDBC driver in $JBOSS_HOME/server//lib, that is where the I always put jdbc drivers (The default
Hypersonic driver is also in this directory).
Cheers,
Andy
On 28/02/07, Andrew Madu <[EMAIL PROTECTED]> wrote:
Hi,
i've just upgraded from posgreSQL 8.1 to 8.2.3. I pla
On Wed, 28 Feb 2007, Andrew Madu wrote:
i've just upgraded from posgreSQL 8.1 to 8.2.3. I placed
postgresql-8.2-504.jdbc4 in /deploy/ejb3.deployer, restarted jboss and the
proces breaks when it gets to detecting what postgresql driver is being
used! I remove the jdbc4 driver and replace it wit
Hi,
i've just upgraded from posgreSQL 8.1 to 8.2.3. I placed
postgresql-8.2-504.jdbc4 in /deploy/ejb3.deployer, restarted jboss and the
proces breaks when it gets to detecting what postgresql driver is being
used! I remove the jdbc4 driver and replace it with, my original driver,
postgresql-8.1-40
36 matches
Mail list logo
