From: Devrim GÜNDÜZ
To: Piotr Kublicki
Cc: pgsql-general@postgresql.org
Date: 28/05/2010 09:36
Subject:Re: [GENERAL] Download
On Fri, 2010-05-28 at 08:37 +0100, Piotr Kublicki wrote:
> And here:
>
http://pgfoundry.org/docman/view.php/148/1338/PostgreS
Faiyaz,
You can start from here:
http://www.postgresonline.com/journal/index.php?/archives/144-An-almost-idiots-guide-to-Install-and-Upgrade-to-PostgreSQL-8.4-with-Yum.html
Section titled "Installing PostgreSQL 8.4.1 from Yum repository"
And here:
http://pgfoundry.org/docman/view.php/148/133
Guillaume Lelarge wrote on 28/04/2010 15:04:07:
> > In such case the new created start-up script postgresql2 should not be
> > modified in the following line:
> >
> > # Override defaults from /etc/sysconfig/pgsql if file is present
> > [ -f /etc/sysconfig/pgsql/${NAME} ] && . /etc/sysconfig/pgsql
I had a similar problem: older versions of Postgres have IP addressing in
one column and subnetting/mask in the next one. 8.4 uses CIDR expression in
one column - applying CIDR notation solved my problem. I think it's
advisable to manually correct the pg_hba.conf file instead of replacing it
with t
Merci!
Pete
From: Guillaume Lelarge
To: Piotr Kublicki , pgsql-general
Date: 28/04/2010 15:04
Subject:Re: [GENERAL] Start-up script for few clusters: just add water?
Le 28/04/2010 14:05, Piotr Kublicki a écrit :
> Hi Guillaume,
>
> Excellent point:
>
Hi Guillaume,
Excellent point:
> Suppose I have a second cluster. I'll have to do this :
>
cd /etc/init.d
cp postgresql postgresql2
cd /etc/sysconfig/pgsql
cp postgresql postgresql2
$EDITOR postgresql2
In $EDITOR, I'll change the different environment values I want. For
example:
>PGPORT=5567
>P
Dears,
Sorry to be a royal pain, but I cannot find it anywhere in the
documentation: how many threads/CPU cores Postgres v. 8.4 can utilise?
We're thinking about installing Postgres on a virtual machine (RedHat 5
64-bits), however not sure how many CPUs can be wisely assigned, without
wasting of
