Slony RPM issue

Hi,

On Wed, 5 Oct 2005, Philip Yarra wrote:

Hi Devrim, I ran into another RPM issue, this time with Slony.

:-)

I grabbed the RPM from
http://developer.postgresql.org/~devrim/slony/1.1.0/rpms/PG8.0.3/

Trying to run slon_start, I got errors such as:
$ slon_start --config /etc/slon_tools.conf 2
Invoke slon for node 2 - @@@/slon -s 1000 -d2 -g 80 replication 'host=dev2
dbname=booktown user=postgres port=5432' 2>&1

/var/log/slony/slony1/node2/booktown-2005-10-05_16:23:53.log &

sh: line 1: @@@/slon: No such file or directory
Slon failed to start for cluster replication, node node2

This turned out to be because /usr/lib/pgsql/slon-tools.pm contained several
un-expanded @@PGBINDIR@@ prefixes - once I replaced them with /usr/bin it all
ran just fine.

Hrrm.

It seems that I've installed wrong file in the spec :( However slon-tools
file is not updated by the Makefile, so I'll try to fix that, too.

Thanks for the report. It will fixed in CVS and all the RPM sets later
today. Always feel free to send me a patch if you want, I�can apply your
patch, too.

BTW, could you please report the possible Slony problems to
slony1-general@gborg.postgresql.org later?

Regards,
--
Devrim GUNDUZ
Kivi Bili�im Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org

From pgsql-hackers-owner@postgresql.org Wed Oct 5 11:57:21 2005

X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 69695DA215
for <pgsql-hackers-postgresql.org@localhost.postgresql.org>; Wed, 5 Oct 2005 11:55:24 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 83238-10
for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
Wed, 5 Oct 2005 14:55:19 +0000 (GMT)
Received: from presinet.com (presinet.com [209.53.156.1])
by svr1.postgresql.org (Postfix) with ESMTP id AC8B2DA20D
for <pgsql-hackers@postgresql.org>; Wed, 5 Oct 2005 11:55:20 -0300 (ADT)
Received: from [10.10.1.151] ([10.10.1.151]) by presinet.com with Microsoft SMTPSVC(6.0.3790.1830);
Wed, 5 Oct 2005 07:53:51 -0700
Message-ID: <4343E95D.5000007@PresiNET.com>
Date: Wed, 05 Oct 2005 07:55:25 -0700
From: Bricklen Anderson <BAnderson@PresiNET.com>
User-Agent: Debian Thunderbird 1.0.6 (X11/20050802)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Qingqing Zhou <zhouqq@cs.toronto.edu>
Cc: pgsql-hackers@postgresql.org
Subject: Re: prefix btree implementation
References: <Pine.LNX.4.58.0510042359110.15377@eon.cs>
In-Reply-To: <Pine.LNX.4.58.0510042359110.15377@eon.cs>
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 05 Oct 2005 14:53:51.0453 (UTC) FILETIME=[996588D0:01C5C9BC]
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.009 required=5 tests=[AWL=0.009]
X-Spam-Level:
X-Archive-Number: 200510/218
X-Sequence-Number: 74077

Qingqing Zhou wrote:

I am not sure if this idea was mentioned before.

The basic prefix btree idea is quite straightforward, i.e., try to
compress the key items within a data page by sharing the common prefix.
Thus the fanout of the page is increased and the benefits is obvious
theorectically.

<snip>

So together, there are basically four types of possible sharing:
column-wise (case 1), character-wise (case 2), column-character-wise (case
3), and byte-wise (case 4).

Oracle implements something similar called index compression, but I believe it
is only for common column values. I haven't checked in versions>9r1 so maybe
there are other options implemented by now.

Jonathan Lewis describes some pros and cons here:
http://www.jlcomp.demon.co.uk/faq/compress_ind.html

--
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________

On Wed, Oct 05, 2005 at 05:32:40PM +0300, Devrim GUNDUZ wrote:

Hi,

On Wed, 5 Oct 2005, Philip Yarra wrote:

Hi Devrim, I ran into another RPM issue, this time with Slony.

:-)

I grabbed the RPM from
http://developer.postgresql.org/~devrim/slony/1.1.0/rpms/PG8.0.3/

Trying to run slon_start, I got errors such as:
$ slon_start --config /etc/slon_tools.conf 2
Invoke slon for node 2 - @@@/slon -s 1000 -d2 -g 80 replication 'host=dev2
dbname=booktown user=postgres port=5432' 2>&1

/var/log/slony/slony1/node2/booktown-2005-10-05_16:23:53.log &

sh: line 1: @@@/slon: No such file or directory
Slon failed to start for cluster replication, node node2

This turned out to be because /usr/lib/pgsql/slon-tools.pm contained
several
un-expanded @@PGBINDIR@@ prefixes - once I replaced them with /usr/bin it
all
ran just fine.

This is also a problem for 64bit machines which like to install
things in lib64. The @@PGBINDIR@@ is also unset in these cases.

Generally a short sed (or perl if you like) script will fix
these up. But it is really pretty obscure trail for people
to find the exact problem.

--elein

On Thu, 6 Oct 2005 05:10 am, elein wrote:

Generally a short sed (or perl if you like) script will fix
these up. But it is really pretty obscure trail for people
to find the exact problem.

Yeah, it's not that it's hard to fix when you know where to look, but my aim
is to produce a site installation checklist for other people to follow. The
simpler it is, the better the chance of it being successful.

I'd prefer a site installation to be:
- install PostgreSQL RPMs
- unpack our specific postgresql.conf and pg_hba.conf
- set up database from scripts
- install Slony RPM
- unpack our specific slony config files
- run minimal commands to get Slony going
- profit! (or at least I don't get woken up by phone calls at 3am)

That's why I'm so keen on the RPMs working out of the box, with minimal need
for post-installation tweaks/fixes.

Regards, Philip.

Hi Devrim,

On Thu, 6 Oct 2005 12:32 am, Devrim GUNDUZ wrote:

Thanks for the report. It will fixed in CVS and all the RPM sets later
today. Always feel free to send me a patch if you want, I can apply your
patch, too.

OK, you got my previous email about why pgsql-libs was dependent on
compat-libs RPM?

I don't even know where to start with fixing RPM issues, but I guess I can
learn if you would like help?

BTW, could you please report the possible Slony problems to
slony1-general@gborg.postgresql.org later?

Sure will. Ermmm, there isn't something you want to tell me is there? :-) I'd
rather hear about gotchas now rather than finding them myself at the eleventh
hour.

Regards, Philip.

--

"Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it." - Brian W. Kernighan

-----------------
Utiba Pty Ltd
This message has been scanned for viruses and
dangerous content by Utiba mail server and is
believed to be clean.

Hi,

On Thu, 6 Oct 2005, Philip Yarra wrote:

On Thu, 6 Oct 2005 12:32 am, Devrim GUNDUZ wrote:

Thanks for the report. It will fixed in CVS and all the RPM sets later
today. Always feel free to send me a patch if you want, I�can apply your
patch, too.

OK, you got my previous email about why pgsql-libs was dependent on
compat-libs RPM?

See:
http://people.planetpostgresql.org/devrim/index.php?/archives/15-New-PostgreSQL-point-releases.html

"New" 8.0.4 RPMs will solve that problem.

Cheers,
--
Devrim GUNDUZ
Kivi Bili�im Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org

From pgsql-hackers-owner@postgresql.org Thu Oct 6 03:42:57 2005

X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 97037DA30C
for <pgsql-hackers-postgresql.org@localhost.postgresql.org>; Thu, 6 Oct 2005 03:42:56 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 16238-04
for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
Thu, 6 Oct 2005 06:42:52 +0000 (GMT)
Received: from smtp1.iitb.ac.in (unknown [203.199.81.149])
by svr1.postgresql.org (Postfix) with SMTP id 82A07DA2FB
for <pgsql-hackers@postgresql.org>; Thu, 6 Oct 2005 03:42:50 -0300 (ADT)
Received: (qmail 12115 invoked from network); 6 Oct 2005 12:12:49 +0530
Received: from unknown (HELO ldns2.iitb.ac.in) (10.200.12.2)
by smtp1.iitb.ac.in with SMTP; 6 Oct 2005 12:12:49 +0530
Received: (qmail 13270 invoked by uid 509); 6 Oct 2005 06:42:49 -0000
Received: from 10.129.1.1 by ldns2 (envelope-from <sandeep@it.iitb.ac.in>, uid 501) with qmail-scanner-1.25st
(clamdscan: 0.87/1110. spamassassin: 3.1.0.
Clear:RC:1(10.129.1.1):.
Processed in 0.016821 secs); 06 Oct 2005 06:42:49 -0000
Received: from unknown (HELO imap.it.iitb.ac.in) (10.129.1.1)
by ldns2.iitb.ac.in with SMTP; 6 Oct 2005 06:42:49 -0000
Received: from akash (akash.it.iitb.ac.in [::ffff:10.129.1.2])
by imap.it.iitb.ac.in with esmtp; Thu, 06 Oct 2005 12:08:17 +0530
id 0000172D.4344C659.000038FC
Received: from localhost (localhost [127.0.0.1])
(IDENT: uid 205035)
by akash with esmtp; Thu, 06 Oct 2005 12:08:08 +0530
id 00001147.4344C650.00007FE1
Date: Thu, 6 Oct 2005 12:08:08 +0530 (IST)
From: sandeep satpal <sandeep@it.iitb.ac.in>
To: pgsql-hackers@postgresql.org
Subject: Query Regarding initdb
In-Reply-To: <Pine.LNX.4.63.0510060842430.6525@mail.kivi.com.tr>
Message-ID: <Pine.LNX.4.63.0510061206190.16181@akash.it.iitb.ac.in>
References: <200510051751.13573.philip@utiba.com>
<Pine.LNX.4.63.0510051107100.23458@mail.kivi.com.tr> <200510061059.27362.philip@utiba.com>
<Pine.LNX.4.63.0510060842430.6525@mail.kivi.com.tr>
MIME-Version: 1.0
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.312 required=5 tests=[AWL=-0.062,
DNS_FROM_RFC_ABUSE=0.374]
X-Spam-Level:
Content-Type: TEXT/PLAIN; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8BIT
X-Archive-Number: 200510/254
X-Sequence-Number: 74113

Hello all,

I want to set a system level flag for my own purposes.
What changes in initdb.c or any other files are expected.
And When I will run my postgresql , how I get that system level flag.

On Thu, 6 Oct 2005, Devrim GUNDUZ wrote:

Hi,

On Thu, 6 Oct 2005, Philip Yarra wrote:

On Thu, 6 Oct 2005 12:32 am, Devrim GUNDUZ wrote:

Thanks for the report. It will fixed in CVS and all the RPM sets later
today. Always feel free to send me a patch if you want, I�can apply your
patch, too.

OK, you got my previous email about why pgsql-libs was dependent on
compat-libs RPM?

See:
http://people.planetpostgresql.org/devrim/index.php?/archives/15-New-PostgreSQL-point-releases.html

"New" 8.0.4 RPMs will solve that problem.

Cheers,
--
Devrim GUNDUZ
Kivi Bili?im Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

--
------------------
| Sandeep Satpal |
| M.Tech Student |
| Lab 212 KReSIT |
------------------

From pgsql-hackers-owner@postgresql.org Thu Oct 6 04:44:02 2005

X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id A41A0DA2F9
for <pgsql-hackers-postgresql.org@localhost.postgresql.org>; Thu, 6 Oct 2005 04:43:51 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 23452-01
for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
Thu, 6 Oct 2005 07:43:44 +0000 (GMT)
Received: from hotmail.com (bay20-f17.bay20.hotmail.com [64.4.54.106])
by svr1.postgresql.org (Postfix) with ESMTP id B954BD8833
for <pgsql-hackers@postgresql.org>; Thu, 6 Oct 2005 04:43:44 -0300 (ADT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
Thu, 6 Oct 2005 00:43:46 -0700
Message-ID: <BAY20-F177DFE8FB76659ECBFB540F9850@phx.gbl>
Received: from 85.160.84.164 by by20fd.bay20.hotmail.msn.com with HTTP;
Thu, 06 Oct 2005 07:43:46 GMT
X-Originating-IP: [85.160.84.164]
X-Originating-Email: [pavel.stehule@hotmail.com]
X-Sender: pavel.stehule@hotmail.com
In-Reply-To: <20051005133251.GJ5239@surnet.cl>
From: "Pavel Stehule" <pavel.stehule@hotmail.com>
To: alvherre@alvh.no-ip.org
Cc: pgsql-hackers@postgresql.org
Subject: Re: current_user versus current_role SOLVED
Date: Thu, 06 Oct 2005 09:43:46 +0200
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
X-OriginalArrivalTime: 06 Oct 2005 07:43:46.0876 (UTC) FILETIME=[AF154FC0:01C5CA49]
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.312 required=5 tests=[AWL=-0.438,
DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0]
X-Spam-Level: *
X-Archive-Number: 200510/255
X-Sequence-Number: 74114

Hi,

I used info from current_user for log. about some operations (who, when,
..). What I can see, current_user is equal current_role function. I had
problem with it, because user (if is member of any group role) can

change

his identity. example: peter is member of role users. But peter can do

set

role to users. From this moment I lost possibility of get identity if

user,

because current_user returns users and not peter. I can check it (if

some

user changed identity) ~ by exampl. test if role has login privilegia,

and

if not I can stop any operations.

I believe you can use session_user for this.

--

it's exactly it what I want.

Thank You
Pavel Stehule

_________________________________________________________________
Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/