Hi,
i have the option to upgrade to a new dedicated database server with 8 GB Ram
i want to run on debian linux 32bit because i had some trouble the last time i
used 64bit with iptables which did not work (i guess it was a year ago...)
8GB are addressable as far as i know with a bigmem kernel.
Dear list member:
I have small problem,
below is the output from ls -larth command for listing WAL segments.
As far as my understanding every new WAL segment created is numerically greater
than the previous one,but below out show the WAL 13 is created after wal
14,15,16,17,18,19 checked by creat
On Sun, 06 Jan 2008, Chuck wrote:
> Sort order, and specifically setting LC_COLLATE and LC_CTYPE was less of a
> concern. (I still need to read and learn more.)
It should be, as it is not only sort order. Try for example this:
select upper('ąŧäɣ');
- these are
polish a_ogonek, t stroke, g
On Mon, Jan 07, 2008 at 10:32:26AM +0100, [EMAIL PROTECTED] wrote:
> So assuming i could choose between 4 GB RAM and 8 GB RAM and 32bit debian and
> 64bit debian. Which option would you choose?
Always go for more RAM, whether you use 64 or 32-bit is really
orthoginal to that, whatever memory you
Hello,
I have defined some functions to manage advisory locks in a more
restrictive way than the default usage.
here my requirements:
- a session cannot stack write locks
- a session cannot aquire a shared lock if it already holds the write
locks
- there is a maximum allowed shared loc
Am Montag, 7. Januar 2008 11:48 schrieb Martijn van Oosterhout:
> On Mon, Jan 07, 2008 at 10:32:26AM +0100, [EMAIL PROTECTED] wrote:
> > So assuming i could choose between 4 GB RAM and 8 GB RAM and 32bit debian
> > and 64bit debian. Which option would you choose?
>
> Always go for more RAM, whether
> Or would you rather vote for 64bit because there are no problems
> anymore and postgresql runs fine on 64bit debian.
We haven't run into any trouble with iptables on Debian etch, running
on amd64 hardware. But we use only fairly standard iptables
functionality.
--
Florian Weimer
Dear PostgreSQL community,
we're looking for a freelancer with PostgreSQL experience in the area of
Zürich, Switzerland. The task will be to maintain and improve the
database for a quite large web application based on Apache Cocoon and
PostgreSQL (e.g. configuration of connection pools and ind
Am Montag, 7. Januar 2008 12:56 schrieb Florian Weimer:
> > Or would you rather vote for 64bit because there are no problems
> > anymore and postgresql runs fine on 64bit debian.
>
> We haven't run into any trouble with iptables on Debian etch, running
> on amd64 hardware. But we use only fairly s
[EMAIL PROTECTED] wrote:
Am Montag, 7. Januar 2008 12:56 schrieb Florian Weimer:
Or would you rather vote for 64bit because there are no problems
anymore and postgresql runs fine on 64bit debian.
We haven't run into any trouble with iptables on Debian etch, running
on amd64 hardware. But we us
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Hannes Dorbath <[EMAIL PROTECTED]> writes:
>> hannes=> CREATE INDEX CONCURRENTLY "ts_fts_tsv" ON "public"."fts" USING gin
>> ("tsv");
>> ERROR: item pointer (0,1) alreadt exists
>
>> I was able to reproduce that error a few times, but not always. It seems
Why are hash indexes "obviously" best? In an ideal world with a good
implementation maybe, but postgresql b-trees are really quite good.
Because doing normal queries on a table where there are large text
blocks is unlikely to be a good idea. E.g.,:
SELECT * FROM table WHERE textcol = 'a 4k
Sorry for my post to the wrong list, I re-posted the mail to the jobs list.
-- Andreas
Andreas Hartmann schrieb:
Dear PostgreSQL community,
we're looking for a freelancer with PostgreSQL experience in the area of
Zürich, Switzerland. The task will be to maintain and improve the
database for
Hello,
I need to write a stored procedure that does look something like this:
CREATE FUNCTION foo() RETURNS SETOF BIGINT LANGUAGE plpgsql AS $$
DECLARE
result RECORD;
BEGIN
EXECUTE 'CREATE TEMP TABLE foo (id int,...)';
-- Insert something into foo depending on contents of the database
"Tom Lane" <[EMAIL PROTECTED]> writes:
> I didn't have any luck reproducing either of these behaviors --- maybe
> it's data-dependent. Can you extract a test case?
I haven't been able to reproduce this either but I produced an entirely
different problem:
postgres=# create index concurrently dg5
i wanted to move my database from a 32bit machine to 64bit machine with rsync
like it is explained here
http://www.postgresql.org/docs/8.1/interactive/backup-file.html
I did an inital rsync while database was running. then shutdown, rsync again,
starting 64bit database says:
/var/lib/postgres
On Tue, Jan 08, 2008 at 01:49:53AM +1100, Naz Gassiep wrote:
> Because doing normal queries on a table where there are large text
> blocks is unlikely to be a good idea. E.g.,:
>
> SELECT * FROM table WHERE textcol = 'a 4kb block of text';
I suggest you look at the tsearch stuff instead.
> I wo
On Tue, Jan 08, 2008 at 01:49:53AM +1100, Naz Gassiep wrote:
> I would assume that hash indexes have inbuilt mechanisms for collision
> checking before returning the row as a match. Am I correct in this
> assumption?
Well, they do in the sense that it does the equivalent of:
SELECT * FROM table
On Tue, Jan 08, 2008 at 01:49:53AM +1100, Naz Gassiep wrote:
> >You could always do something like:
> >
> >CREATE INDEX foo ON table((md5(textcol)));
> >
> >Then it will get used in queries like:
> >SELECT * FROM table WHERE md5(textcol) = md5('text');
>
> That's exactly what I was considering doi
Hi,
On Montag, 7. Januar 2008, [EMAIL PROTECTED] wrote:
| i wanted to move my database from a 32bit machine to 64bit machine with
| rsync like it is explained here
[...]
| i guess that rsyncing all database files from 32bit to 64bit does not work.
Yes, you are right; 32bit and 64bit formats are i
On Jan 7, 2008 1:28 AM, Chuck <[EMAIL PROTECTED]> wrote:
> Since I had sent this email, I contacted my web host for help. They
> said that I could '-E UTF8 --no-locale' to the initdb call within
> /etc/init.db/postgresql. I stopped postgres, deleted the data
> directory and restarted postgres. My c
Dear friends,
I am reviewing some of PhpBB 3.x queries.
This allows me to learn more about PostgreSQL.
The thread can be read here:
http://area51.phpbb.com/phpBB/viewtopic.php?f=3&t=29260
Do not hesitate to post your review there.
In pg_tables, I saw that there was an extensive use of sequentia
Quoting Tom Lane <[EMAIL PROTECTED]>:
"Eric D. Nielsen" <[EMAIL PROTECTED]> writes:
I've confirmed from the commandline using
psql -h -p -U database
"psql: could not connect to server: Connection refused
That's not a Postgres problem. You do not have network-level
connectivity --- I'm bet
On Jan 7, 2008 11:06 AM, Jean-Michel Pouré <[EMAIL PROTECTED]> wrote:
> Dear friends,
>
> I am reviewing some of PhpBB 3.x queries.
> This allows me to learn more about PostgreSQL.
>
> The thread can be read here:
> http://area51.phpbb.com/phpBB/viewtopic.php?f=3&t=29260
>
> Do not hesitate to post
Dear Friends,
I am running a phpBB forum with more than 400.000 messages.
I would like to make sure that all indexes fit in shared memory.
How can I calculate the needed space of all indexes?
I remember this was part of VACUUM FULL ANALYSE or the like.
Kind regards,
Jean-Michel
---
Hi List,
I have multiple objects to which I'd like to associate comments. I'd
like this to be a many to one relationship, so that each object can have
many different comments. The issue is how to have one comment table.
One method that has been proposed is to have a third table which stores
- Original Message
> From: Jean-Michel Pouré <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Sent: Monday, January 7, 2008 11:06:09 AM
> Subject: [GENERAL] PhpBB 3.x query review
>
>
> I set indexes on ban_email, ban_userid and ban_ip.
> But the query plan is still the same.
>
Jean-Michel Pouré wrote:
Dear friends,
I am reviewing some of PhpBB 3.x queries.
This allows me to learn more about PostgreSQL.
The thread can be read here:
http://area51.phpbb.com/phpBB/viewtopic.php?f=3&t=29260
Do not hesitate to post your review there.
In pg_tables, I saw that there was an
I want to announce PostgreSQL RPM Buildfarm today.
PostgreSQL RPM Buildfarm is a set of Xen instances which includes all
combinations of RHEL/CentOS 3,4,5 and Fedora 7,8 with 32 and 64 bit
architectures, as well as all PostgreSQL major releases. More will come
later. RPM users will be able to fi
2008/1/7, Scott Marlowe <[EMAIL PROTECTED]>:
> On Jan 6, 2008 1:46 PM, Clodoaldo <[EMAIL PROTECTED]> wrote:
> > 2008/1/6, Scott Marlowe <[EMAIL PROTECTED]>:
> >
> > > On Jan 6, 2008 5:06 AM, Clodoaldo <[EMAIL PROTECTED]> wrote:
> > > >
> > > > Then I rebuilt and reinstalled postgresql with the xlog
I mean I re-create the function with the same signature but
different body, and when the application invokes that function
again, it starts getting those errors.
Alex.
On Fri, 2008-01-04 at 15:36 -0500, Tom Lane wrote:
> Alex Vinogradovs <[EMAIL PROTECTED]> writes:
> > I've got an application t
Kevin Hunter wrote:
Hi List,
I have multiple objects to which I'd like to associate comments. I'd
like this to be a many to one relationship, so that each object can have
many different comments. The issue is how to have one comment table.
One method that has been proposed is to have a thir
On Jan 7, 2008 12:57 PM, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
>
> I want to announce PostgreSQL RPM Buildfarm today.
This is very very very cool! Thanks you guys.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map sett
Alex Vinogradovs wrote:
> I mean I re-create the function with the same signature but
> different body, and when the application invokes that function
> again, it starts getting those errors.
Are you using CREATE OR REPLACE FUNCTION, or DROP FUNCTION followed by
CREATE FUNCTION?
--
Alvaro Herr
Yes, I'm using CREATE OR REPLACE.
Alex.
On Mon, 2008-01-07 at 16:17 -0300, Alvaro Herrera wrote:
> Alex Vinogradovs wrote:
> > I mean I re-create the function with the same signature but
> > different body, and when the application invokes that function
> > again, it starts getting those errors.
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Alex Vinogradovs wrote:
>> I mean I re-create the function with the same signature but
>> different body, and when the application invokes that function
>> again, it starts getting those errors.
> Are you using CREATE OR REPLACE FUNCTION, or DROP FUNCTI
On Mon, 7 Jan 2008, Jean-Michel Pour? wrote:
I am running a phpBB forum with more than 400.000 messages.
I would like to make sure that all indexes fit in shared memory.
How can I calculate the needed space of all indexes?
There's a useful commentary on finding the sizes of various objects,
i
At 2:09p -0500 on 07 Jan 2008, brian wrote:
Kevin Hunter wrote:
Is there a clever/clean way of having the comments foreign key into
the multiple tables?
If, by object, you mean that you have several tables, each row of which
should be associated with one or more comments, the best way would b
On Mon, 7 Jan 2008, Clodoaldo wrote:
I just did it. Built and installed 8.2.5. Copied the postgresql.conf
from the production. Issued an analyze and ran the insert query twice:
The second time it ran in 403 sec, half the production time.
OK, you're getting close now. What you should do now is
Tom Lane wrote:
I didn't have any luck reproducing either of these behaviors --- maybe
it's data-dependent. Can you extract a test case?
I will try to come up with a test case, but it might take until next
weekend, sorry.
The test data was an IRC log file, containing lots of color and
form
Ashish Karalkar <[EMAIL PROTECTED]> writes:
> As far as my understanding every new WAL segment created is numerically
> greater than the previous one,but below out show the WAL 13 is created after
> wal 14,15,16,17,18,19 checked by creation time.
You're in error to assume that the creation time
On Jan 7, 2008 11:29 AM, Jean-Michel Pouré <[EMAIL PROTECTED]> wrote:
> Dear Friends,
>
> I am running a phpBB forum with more than 400.000 messages.
> I would like to make sure that all indexes fit in shared memory.
You're kind of leaning towards tying to optimized things in postgresql
the way ot
Naz Gassiep <[EMAIL PROTECTED]> writes:
>> Why are hash indexes "obviously" best? In an ideal world with a good
>> implementation maybe, but postgresql b-trees are really quite good.
>>
> Because doing normal queries on a table where there are large text
> blocks is unlikely to be a good idea. E.
--- On Mon, 1/7/08, Kevin Hunter <[EMAIL PROTECTED]> wrote:
> :-( Yeah this is one method. I was hoping for something
> cleaner though.
> Something along the lines of
>
> CREATE TABLE o_1 ( id SERIAL ... );
> CREATE TABLE o_2 ( id SERIAL ... );
> CREATE TABLE o_3 ( id SERIAL ... );
> CREATE T
Scott Marlowe wrote:
On Jan 7, 2008 12:57 PM, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
I want to announce PostgreSQL RPM Buildfarm today.
This is very very very cool! Thanks you guys.
I'll second that, and I'm a Debian type of chap :-)
--
Richard Huxton
Archonet Ltd
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 07 Jan 2008 20:25:45 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Scott Marlowe wrote:
> > On Jan 7, 2008 12:57 PM, Devrim GÜNDÜZ <[EMAIL PROTECTED]>
> > wrote:
> >> I want to announce PostgreSQL RPM Buildfarm today.
> >
> > This is very
Devrim GÜNDÜZ wrote:
> I want to announce PostgreSQL RPM Buildfarm today.
Where is it?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archive
Greg Smith <[EMAIL PROTECTED]> writes:
> The only thing I noticed in your original explain plans that was different
> between the two was:
> 8.2:
> Merge Cond: ((ut.n_time = ui.n_time) AND
> ((ut.usuario)::text = "inner"."?column4?"))
> 8.3:
> Merge Cond: ((ut.n_tim
I want to announce that PostgreSQL RPM Yum repository is now available.
With this repository, you will be able to install your favorite
PostgreSQL version with the other compatible PostgreSQL related software
to your favorite OS . You don't have to stick to OS-supplied RPM
packages.
Please visit
Hi,
On Mon, 2008-01-07 at 22:59 +0100, Peter Eisentraut wrote:
> > I want to announce PostgreSQL RPM Buildfarm today.
>
> Where is it?
You mean the server? Here it is:
http://yum.pgsqlrpms.org/rpmbuildfarm.php
:-)
Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom De
On Jan 7, 2008 4:32 PM, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Mon, 2008-01-07 at 22:59 +0100, Peter Eisentraut wrote:
> > > I want to announce PostgreSQL RPM Buildfarm today.
> >
> > Where is it?
>
> You mean the server? Here it is:
>
> http://yum.pgsqlrpms.org/rpmbuildfarm.php
Ha!
On Mon, 07 Jan 2008 14:32:27 -0800
Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Mon, 2008-01-07 at 22:59 +0100, Peter Eisentraut wrote:
> > > I want to announce PostgreSQL RPM Buildfarm today.
> >
> > Where is it?
>
> You mean the server? Here it is:
>
> http://yum.pgsqlrpms.org/rpmbu
On Jan 7, 2008, at 2:22 PM, Richard Broersma Jr wrote:
CREATE TABLE comments (
id SERIAL,
obj_id INTEGER ...
FOREIGN KEY (obj_id)
REFERENCES ONE OF o(id);
Where are you guys getting this REFERENCES ONE OF stuff?
Erik Jones
DBA | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.29
On Monday 07 January 2008 15:03:52 Ivan Sergio Borgonovo wrote:
> On Mon, 07 Jan 2008 14:32:27 -0800
>
> Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > On Mon, 2008-01-07 at 22:59 +0100, Peter Eisentraut wrote:
> > > > I want to announce PostgreSQL RPM Buildfarm today.
> > >
> > > Where i
On Jan 7, 2008 5:03 PM, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> On Mon, 07 Jan 2008 14:32:27 -0800
> Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > On Mon, 2008-01-07 at 22:59 +0100, Peter Eisentraut wrote:
> > > > I want to announce PostgreSQL RPM Buildfarm today.
> > >
> >
On Jan 7, 2008 5:15 PM, Darcy Buskermolen <[EMAIL PROTECTED]> wrote:
> On Monday 07 January 2008 15:03:52 Ivan Sergio Borgonovo wrote:
> > On Mon, 07 Jan 2008 14:32:27 -0800
> >
> > Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > >
> > > On Mon, 2008-01-07 at 22:59 +0100, Peter Eisentraut wr
On Monday 07 January 2008 15:23:46 you wrote:
> On Jan 7, 2008 5:15 PM, Darcy Buskermolen <[EMAIL PROTECTED]> wrote:
> > On Monday 07 January 2008 15:03:52 Ivan Sergio Borgonovo wrote:
> > > On Mon, 07 Jan 2008 14:32:27 -0800
> > >
> > > Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> > > > Hi,
> > > >
--- On Mon, 1/7/08, Erik Jones <[EMAIL PROTECTED]> wrote:
> From: Erik Jones <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] many to one of many modeling question
> To: "Richard Broersma Jr" <[EMAIL PROTECTED]>
> Cc: "Postgres General List" , "Kevin Hunter"
> <[EMAIL PROTECTED]>, "Caktus Team" <[EMA
what is a botherboard?
M
- Original Message -
Wrom: SCRTNHGSWZIDREXCAXZOWCONEUQZAAFXISHJEXXIMQZUIV
To:
Sent: Monday, January 07, 2008 6:15 PM
Subject: Re: [GENERAL] Announcing PostgreSQL RPM Buildfarm
On Monday 07 January 2008 15:03:52 Ivan Sergio Borgonovo wrote:
> On Mon, 07 Jan 2008
Hi,
On Mon, 2008-01-07 at 19:12 -0500, [EMAIL PROTECTED] wrote:
> what is a botherboard?
Brotherboard -- motherboard is a bit old.
Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plP
Hi,
I'd like to know is there a column limitation for PostgreSQL? like
column size and maximum number of columns per table?
Thank you.
Kandy
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
--- On Mon, 1/7/08, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> wrote:
> > what is a botherboard?
>
> Brotherboard -- motherboard is a bit old.
Maybe a Freudian slip? ;)
---(end of broadcast)---
TIP 5: don't forget to increase your free space map s
On Mon, Jan 07, 2008 at 04:54:46PM -0800, Richard Broersma Jr wrote:
> > wrote:
> > > what is a botherboard?
> >
> > Brotherboard -- motherboard is a bit old.
>
> Maybe a Freudian slip? ;)
His brother is his mother?
Man... that's just weird.
--
"To the extent that we overreact, we proffer
Kandy Wong wrote:
Hi,
I'd like to know is there a column limitation for PostgreSQL? like
column size and maximum number of columns per table?
Thank you.
Kandy
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
http://www.postgres
2008/1/7, Greg Smith <[EMAIL PROTECTED]>:
> On Mon, 7 Jan 2008, Clodoaldo wrote:
>
> > I just did it. Built and installed 8.2.5. Copied the postgresql.conf
> > from the production. Issued an analyze and ran the insert query twice:
> > The second time it ran in 403 sec, half the production time.
>
>
Geoffrey wrote:
[EMAIL PROTECTED] wrote:
Am Montag, 7. Januar 2008 12:56 schrieb Florian Weimer:
Or would you rather vote for 64bit because there are no problems
anymore and postgresql runs fine on 64bit debian.
We haven't run into any trouble with iptables on Debian etch, running
on amd64 har
Clodoaldo escribió:
8.2:
> Trigger for constraint datas: time=14231.240 calls=880691
> Total runtime: 356862.302 ms
> (12 rows)
>
> Time: 357750.531 ms
8.3:
> Trigger for constraint datas: time=33179.197 calls=877895
> Total runtime: 9546878.520 ms
> (13 rows)
So what's this constraint an
Chris wrote:
Are there any other recommendations whether to use 64bit or 32bit OS
with postgresql? I just want to use 64bit if it as stable as 32bit.
I'm curious as to why you would run iptables on a database server. My
expectation would be that your database machine would be behind a
dedic
On Jan 7, 2008, at 6:00 PM, Richard Broersma Jr wrote:
--- On Mon, 1/7/08, Erik Jones <[EMAIL PROTECTED]> wrote:
From: Erik Jones <[EMAIL PROTECTED]>
Subject: Re: [GENERAL] many to one of many modeling question
To: "Richard Broersma Jr" <[EMAIL PROTECTED]>
Cc: "Postgres General List" , "Kevin
On Mon, 7 Jan 2008, Joshua D. Drake wrote:
Certainly and iptables gives you some flexibility in connection availability
"before" it hits the actual database but without having to jimmy the
production firewall.
It's worth emphasizing that in many environments, it's far more likely one
will ha
Greg Smith wrote:
On Mon, 7 Jan 2008, Joshua D. Drake wrote:
Certainly and iptables gives you some flexibility in connection
availability "before" it hits the actual database but without having
to jimmy the production firewall.
4) Funky tricks with things like port forwarding and filtering
Hi,
I'm using Postgres V 7.4.14 on HPUX 11.31 box. While doing a load test there
was a core generated not sure why. Can you please help.
Core was generated by `postgres'.
Program terminated with signal 6, Aborted.
#0 0x6000c0587970:0 in kill+0x30 () from /usr/lib/hpux32/libc.so.1
(gdb)
On Mon, 2008-01-07 at 13:13 -0600, Scott Marlowe wrote:
> On Jan 7, 2008 12:57 PM, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> >
> > I want to announce PostgreSQL RPM Buildfarm today.
>
> This is very very very cool! Thanks you guys.
Ultra Even. No more mucking about for RPMS and finally a ptop
"Rajaram J" <[EMAIL PROTECTED]> writes:
> I'm using Postgres V 7.4.14 on HPUX 11.31 box. While doing a load test there
> was a core generated not sure why. Can you please help.
What sort of "load test" were you doing exactly?
> #5 0x44f01b0:0 in s_lock_stuck () at s_lock.c:36
> #6 0x44f02b0:0
Hi,
On Tue, 2008-01-08 at 13:34 +0800, Ow Mun Heng wrote:
> finally a ptop in RPM form.
I packaged it last month, but did not announce it to public.:)
> Devrim, can you also package up pgpool-II-2.0.1? The .spec file you
> have in the tarball is destined for beta1 of pgpool and your website's
>
On Mon, 2008-01-07 at 21:54 -0800, Devrim GÜNDÜZ wrote:
> Hi,
>
> On Tue, 2008-01-08 at 13:34 +0800, Ow Mun Heng wrote:
> > finally a ptop in RPM form.
>
> I packaged it last month, but did not announce it to public.:)
Hmm.. can I find it in the same location as the pgpool rpms?
>
> > Devrim,
Hi,
On Tue, 2008-01-08 at 14:15 +0800, Ow Mun Heng wrote:
> > I packaged it last month, but did not announce it to public.:)
>
> Hmm.. can I find it in the same location as the pgpool rpms?
No, please wait until it appears in our yum repository.
Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Repli
Hi,
I have a database (8.1.10 via Ubuntu) that has started reporting:
<2008-01-08 08:51:14 EST|>ERROR: could not access status of
transaction 707406378
<2008-01-08 08:51:14 EST|>DETAIL: could not open file "pg_clog/02A2":
No such file or directory
when trying to do an autovacuum.
By vacuumin
Hi, all! Subj, as is. Any other pitfalls I should be aware of?
Thanks.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
79 matches
Mail list logo
