Lonni J Friedman wrote:
selinux-policy-targeted-1.17.30-2.85
up2date insists that these packages are all up to date.
And you're certain that you're using the targetted policy and not strict?
To be frank, I am not. I have not the slightest idea what all that
selinux is about (beside security in ge
Hi Tom,
sudo /sbin/restorecon -R /var/lib/pgsql
worked like a charm!
Thank you very much!
Ulrich
--
Ulrich Wisser
RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769
__
It took me a while, but I finally figured out that the citext module did
not require a recompile, it just required all the compile information,
specifically the config.status file, which wasn't there.
After I extracted the sources and ran ./configure for postgresql, the
contrib module compiled ver
[Here's my third attempt to post this. Sorry if it's a dup. (trip?)]
If you're willing to modify your triggers you can gain per-session
control over any and all triggers and functions.
For example, suppose I have a trigger that logs certain events, but I
also want to be able to turn off logging
>Net Virtual Mailing Lists wrote:
>> All I did was added an extra column to my table (I called it
>> "batch_process"). Then in
>> the trigger do something like (in whichever function you are calling):
>>
>> IF NEW.batch_update IS NOT NULL AND NEW.batch_update = ''t'' THEN
>> NEW.batch_process :
Jim C. Nasby wrote:
Personally, I find the anti-windows bias that has been shown in this
thread by some developers to be disappointing. Maybe it sucks to program
in, and maybe it's not as stable as unix (though I don't put much water
in that argument anymore), but the fact is there's still a LOT of
Yes, that fixed it.
Marc G. Fournier wrote:
Not sure what I need to start on the server, so David will have to check
it over ... the only thing that is in the auto-start script on the
srever itself, though, I've just restarted, so try now and let me know
if that was the only thing I needed ot hi
Scott Marlowe <[EMAIL PROTECTED]> writes:
> Yes, it is a way. It's just a less necessary one than it once was, with
> hardware now able to provide the same performance increase with little
> or no work on the users part. We've got to weigh the increased
> complexity it would take to implement i
Scott Marlowe <[EMAIL PROTECTED]> writes:
> Wait, I'm not sure I understand your point here yet. Are you saying
> something along the lines of that with a 1TB storage array, and putting
> all the data in one big partitions, the DBAs had problems, but when they
> partitioned it down to say 10 100G
Not sure what I need to start on the server, so David will have to check
it over ... the only thing that is in the auto-start script on the srever
itself, though, I've just restarted, so try now and let me know if that
was the only thing I needed ot hit ...
On Thu, 10 Mar 2005, David Mitchell w
Hi,
It would appear the bittorrent tracker is down or broken. I can't
download anything from postgresql (but I can from other torrents), and I
can't seed either.
--
David Mitchell
Software Engineer
Telogis
NOTICE:
This message (including any attachments) contains CONFIDENTIAL
INFORMATION intende
The beauty of an open source, BSD-licensed project like PostgreSQL is
the entire "Who cares?" possibility list.
If you have a Windows shop and you have Windows trained personnel, then
you can use PostgreSQL.
If you have a Linux shop and Linux trained personnel, then you can use
PostgreSQL.
If yo
Quoting "Joshua D. Drake" <[EMAIL PROTECTED]>:
> >
> >
> >The only additional thing I would add to this if it hasn't been mentioned
> >already is that 2000 had/has some major security issues and even though 2003
> is
> >more secure out of the box from what I've experienced so far, I would
> **neve
On Wed, 2005-03-09 at 14:47, Greg Stark wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
>
> > Actually, I think it is the more common scenario of migrating off of
> > oracle or db2 and onto postgresql, and bringing along the experience
> > gained there over the years that has caused this refrai
Scott Marlowe <[EMAIL PROTECTED]> writes:
> Actually, I think it is the more common scenario of migrating off of
> oracle or db2 and onto postgresql, and bringing along the experience
> gained there over the years that has caused this refrain to sprout up
> more and more often. With a database si
Quoting "Joshua D. Drake" <[EMAIL PROTECTED]>:
> Shelby Cain wrote:
>
> >--- "Uwe C. Schroeder" <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> >>>The problem is, that it's a question of
> >>>
> >>>
> >>perception. Most windows fans don't
> >>
> >>
> >>>see that "their" OS is pretty instable
The only additional thing I would add to this if it hasn't been mentioned
already is that 2000 had/has some major security issues and even though 2003 is
more secure out of the box from what I've experienced so far, I would **never**
trust a windows box to anything other than my LAN using private
Lonni , folks
> Full meaning all the rows are being updated? What
> kind of data is
> this that you're updating?
the fts engine using one tsvector field indexing with
gist index
the statement is something like this
update from veryLargeTable
set field = to_tsvector( coleace(field1) );
an
> I thank you all for throwing light on the question I asked.
[missed it earlier, not been reading that lists mail]
> I was exchanging mails with one of the developers on
> PgFoundry. He made a comment and said
>
> 'Is anybody using PostgreSQL on Windows?'.
Yes. I know of several fairly lar
[EMAIL PROTECTED] (Tope Akinniyi) writes:
> I am wondering at this display of extreme Linux mentality being
> displayed by the 'top bras' of the PostgreSQL community. And I ask,
> are we encouraging Windows use of PostgreSQL at all?
> Take a look at tools being rolled out at PgFoundry on daily ba
Joshua,
Very well put !
Cheers,
Aly.
Joshua D. Drake wrote:
Shelby Cain wrote:
--- "Uwe C. Schroeder" <[EMAIL PROTECTED]> wrote:
The problem is, that it's a question of
perception. Most windows fans don't
see that "their" OS is pretty instable.
That may hav
On Wed, 2005-03-09 at 13:21, Joshua D. Drake wrote:
> Scott Marlowe wrote:
>
> >On Wed, 2005-03-09 at 10:31, FERREIRA William (COFRAMI) wrote:
> >
> >
> >>hi
> >>
> >>does the table partitionning exists under PostgreSQL ? or maybe an
> >>alternative exists ?
> >>
> >>Oracle implements this sys
Lonni , folks
configuration data: sorry for long response ;)
Linux sume 2.6.9-gentoo-r1 #1 SMP Mon Feb 21 10:46:46
Local time zone
must
be set--see zic i686 Intel(R) Xeon(TM) CPU 2.80GHz
GenuineIntel
GNU/Linux
postgres:
"PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 3.3.4
On Wed, 9 Mar 2005 16:26:53 -0300 (ART), marcelo Cortez
<[EMAIL PROTECTED]> wrote:
> Lonni , folks
>
> >
> > You're doing this from within psql or elsewhere?
> from putty terminal from windows statiom
That doesn't really answer the question. How are you interfacing with
the database? Are you
>From your postgresql.conf it look like you're running with a default
config, which is very likely unsuitable for the dataset and/or usage
patterns that you have. Granted that should not cause a seg fault,
but who knows what kind of weirdness is going on behind the scenes.
I didn't see any info f
Lonni , folks
>
> You're doing this from within psql or elsewhere?
from putty terminal from windows statiom
> What logging level
default i' guest
> are you using? How 'massive' is this update?
full , the update statement not have filter clause.
> kind of parameters
the update statemen
On Wed, 2005-03-09 at 13:07, Greg Stark wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
>
> > With the advent of very large raid arrays with very fast caching
> > controllers, this methodology is becoming less and less necessary.
>
> I think the evidence is to the contrary. Witness the rather
Scott Marlowe wrote:
On Wed, 2005-03-09 at 10:31, FERREIRA William (COFRAMI) wrote:
hi
does the table partitionning exists under PostgreSQL ? or maybe an
alternative exists ?
Oracle implements this system : it allows to spread rows on differents
partitions depending on an attribute.
For example,
Ragnar Hafstað wrote:
> On Tue, 2005-03-08 at 16:30 -0600, Guy Rouillier wrote:
>> We use a dynamic statement in a pgsql stored function to insert rows
>> into a table determined at run time. After much debugging, I've
>> discovered that a null incoming argument will cause the dynamic
>> statement
Scott Marlowe <[EMAIL PROTECTED]> writes:
> With the advent of very large raid arrays with very fast caching
> controllers, this methodology is becoming less and less necessary.
I think the evidence is to the contrary. Witness the rather dramatic surge in
inquiries about this on this list. A yea
Tom Lane wrote:
One problem is that selinux-policy-targeted updates don't necessarily
propagate to the security labels of the individual files.
Sounds like it might be a good idea to add a trigger to the PostgreSQL
RPM to run restorecon when the SELinux policy is updated.
--
===
tony wrote:
Excuse me dear sir. There seems to be about 97% of the world that runs
Windows that does not give you permission to be rude to a tiny minority
who just happen to have written an insanely great database that runs
quite nicely on their "hobby" OSs as well as the crap you call home. If
you
On Wed, 9 Mar 2005, tony wrote:
> Le mercredi 09 mars 2005 à 09:47 -0800, Ben a écrit :
> > Ho ho, flame on! :)
>
> Hear hear!!! This man is a troll if ever we have seen one.
Who? Jim Nasby? He's made several helpful posts to this list in my
memory, and I'm sure an archive search would turn up
Sim Zacks wrote:
I just installed postgresql on a new gentoo server using emerge and I would
like to add the citext module for a case insensitive text type. Emerge does
not have a citext option in postgresql or package.
No, because it's not part of the postgres tarball. But the Gentoo
ebuilds _do_
I thank you all for throwing light on the question I
asked.
I was exchanging mails with one of the developers on
PgFoundry. He made a comment and said
'Is anybody using PostgreSQL on Windows?'.
I began to wonder, was the Windows version a toy?
I head a software development outfit in Nigeria a
Le mercredi 09 mars 2005 à 09:47 -0800, Ben a écrit :
> Ho ho, flame on! :)
Hear hear!!! This man is a troll if ever we have seen one.
> > Personally, I find the anti-windows bias that has been shown in this
> > thread by some developers to be disappointing. Maybe it sucks to program
> > in, and
I don't think so, if you consider a troll to be someone who doesn't care
about the topic, but rather wishes to stir up newbies and flamers. A
search of the archives shows the sender has a history of asking valid
questions and offering advice on-topic.
That said, the result is the same.
Cheers,
Sim Zacks wrote:
> I just installed postgresql on a new gentoo server using emerge and I
> would like to add the citext module for a case insensitive text type.
> Emerge does not have a citext option in postgresql or package. Does
> anyone know how to get the citext into postgresql on gentoo and wi
On Wed, 9 Mar 2005 14:28:55 -0300 (ART), marcelo Cortez
<[EMAIL PROTECTED]> wrote:
>
> hello to all
> I have the following problem, when making massive
> update of a table, I received the message
> "segmentation fault" without no other data of the
> error in log.
> Some idea of because it gives
Ho ho, flame on! :)
My completely annecodal experience with devs which prefer windows over
posix is that the former prods things until they seem to work and accepts
unexplained behavior far more readily than the latter. Do I *really* want
that kind of mentality in my database devs?
Anyway, I th
On Wed, 9 Mar 2005 11:02:10 -0600, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
>... but the fact is there's still a LOT of places
> that are windows shops and a LOT of people who use windows more heavily
> than *nix. More important, the egotism of "If you want to use PostgreSQL
> you better run it on w
hello to all
I have the following problem, when making massive
update of a table, I received the message
"segmentation fault" without no other data of the
error in log.
Some idea of because it gives east message?
I am using
gentoo
postgres 7.4.6
dual processor HP proliant
5 gigabyte of
Whoops, posted to the wrong mailing list... but it might fit anyway.
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Wed, Mar 09, 2005 at 04:49:28PM +0100, Alessandro Vincelli wrote:
>
> This simple function return setof table "DatiRegione"
>
>
> CREATE OR REPLACE FUNCTION public._stato_dati_regione_rt(text)
> RETURNS SETOF "DatiRegione" AS
> '
> SELECT DISTINCT ON ("Codice_regione") dr.* FROM "Da
Hi, I'm new at pg.
I'll be using tmp tables in others rdbms. An user can create your own
tmp tables (grant temporary tables) but can't drop it (I don't want to
grant drop privileges).
Other way it's using on commit; but I can't make this work.
Example:
CREATE TEMPORARY TABLE tmp ON COMMIT DROP AS
Shelby Cain wrote:
--- "Uwe C. Schroeder" <[EMAIL PROTECTED]> wrote:
The problem is, that it's a question of
perception. Most windows fans don't
see that "their" OS is pretty instable.
That may have been true in 1995. However, in this day
and age most Windows fans don't see t
Tablespaces are the closest thing. They were introduced in 8.0:
http://www.postgresql.org/docs/8.0/static/sql-createtablespace.html
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-00
Personally, I find the anti-windows bias that has been shown in this
thread by some developers to be disappointing. Maybe it sucks to program
in, and maybe it's not as stable as unix (though I don't put much water
in that argument anymore), but the fact is there's still a LOT of places
that are win
Please post to the list too when replying...
On Wed, 2005-03-09 at 17:29, Mican Bican wrote:
> Thank you for your answer. The reason of so long transactions is that
> I first Insert a row than get the last ID (primary key) and select it
> for update from the database and wait for user to commit it
On Wed, 2005-03-09 at 10:31, FERREIRA William (COFRAMI) wrote:
> hi
>
> does the table partitionning exists under PostgreSQL ? or maybe an
> alternative exists ?
>
> Oracle implements this system : it allows to spread rows on differents
> partitions depending on an attribute.
> For example, my
unsuscribe
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
Title: iterate over refcursor
hi
does
the table partitionning exists under PostgreSQL ? or maybe an alternative exists
?
Oracle
implements this system : it allows to spread rows on differents partitions
depending on an attribute.
For
example, my application store xml documents in databa
--- "Uwe C. Schroeder" <[EMAIL PROTECTED]> wrote:
> > The problem is, that it's a question of
> perception. Most windows fans don't
> > see that "their" OS is pretty instable.
That may have been true in 1995. However, in this day
and age most Windows fans don't see that their OS as
unstable beca
Tom Lane wrote:
Tope Akinniyi <[EMAIL PROTECTED]> writes:
I am not holding anybody responsible, but I think we need to do a massive re-orientation of the community not to carry the Linux-Windows game too far.
This is a troll, isn't it?
My thinking as well, unfortunately, has hooked some folks...
-
This simple function return setof table "DatiRegione"
CREATE OR REPLACE FUNCTION public._stato_dati_regione_rt(text)
RETURNS SETOF "DatiRegione" AS
'
SELECT DISTINCT ON ("Codice_regione") dr.* FROM "DatiRegione"
'
LANGUAGE 'sql' VOLATILE STRICT;
When I perform query on this setof, pgsq
Csaba Nagy wrote:
DELETE FROM Temp1 WHERE Test = 'test3';
ERROR: syntax error at or near "$2" at character 44
QUERY: INSERT INTO Temp2 (ID, test) VALUES ( $1 $2 )
CONTEXT: PL/pgSQL function "temp1_trigger_delete" line 2 at SQL statement
LINE 1: INSERT INTO Temp2 (ID, test) VALUES ( $1 $2 )
> DELETE FROM Temp1 WHERE Test = 'test3';
> ERROR: syntax error at or near "$2" at character 44
> QUERY: INSERT INTO Temp2 (ID, test) VALUES ( $1 $2 )
> CONTEXT: PL/pgSQL function "temp1_trigger_delete" line 2 at SQL statement
> LINE 1: INSERT INTO Temp2 (ID, test) VALUES ( $1 $2 )
Ulrich Wisser <[EMAIL PROTECTED]> writes:
> it seems selinix doesn't like postgres. Can I uninstall selinux from
> fedora savely? OR is there any way to make them both work together?
They should work together as long as you have the latest PG RPMs (which
it seems you do) and a reasonably recent s
Ulrich Wisser wrote:
Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc: denied
{ read } for pid=9251 exe=/usr/bin/postgres name=PG_VERSION dev=dm-1
ino=1255016 scontext=user_u:system_r:postgresql_t
tcontext=root:object_r:var_lib_t tclass=file
Try running 'restorecon -n -R -v /var
I just installed postgresql on a new gentoo server using emerge and I would
like to add the citext module for a case insensitive text type. Emerge does
not have a citext option in postgresql or package.
Does anyone know how to get the citext into postgresql on gentoo and will
this break the next ti
Richard Huxton wrote:
Gordan Bobic wrote:
Hi,
I'm trying to figure out how to do this from the documentation, but I
can't figure it out. :-(
Here is what I'm trying to do:
CREATE TABLE MyTable
(
IDbigserial unique,
MyDatachar(255),
PRIMARY KEY (ID)
);
CREATE TABLE Archive_MyTa
On Tue, 2005-03-08 at 21:24, Tope Akinniyi wrote:
> Hi,
>
> I am wondering at this display of extreme Linux mentality being
> displayed by the 'top bras' of the PostgreSQL community. And I ask,
> are we encouraging Windows use of PostgreSQL at all?
>
> Take a look at tools being rolled out at
On Wed, 09 Mar 2005 14:38:06 +0100, Ulrich Wisser
<[EMAIL PROTECTED]> wrote:
> Sorry,
>
> of course I forgot to mention my installed version. Please find them below:
>
> postgresql-jdbc-7.4.7-3.FC3.1
> postgresql-odbc-7.3-8.FC3.1
> postgresql-test-7.4.7-3.FC3.1
> postgresql-devel-7.4.7-3.FC3.1
>
Sorry,
of course I forgot to mention my installed version. Please find them below:
postgresql-jdbc-7.4.7-3.FC3.1
postgresql-odbc-7.3-8.FC3.1
postgresql-test-7.4.7-3.FC3.1
postgresql-devel-7.4.7-3.FC3.1
postgresql-contrib-7.4.7-3.FC3.1
postgresql-python-7.4.7-3.FC3.1
postgresql-7.4.7-3.FC3.1
postgre
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Are you using the latest selinux_policy_targeted package? I mean, is your
system up2date?
Regards,
On Wed, 9 Mar 2005, Ulrich Wisser wrote:
Hi,
it seems selinix doesn't like postgres. Can I uninstall selinux from fedora
savely? OR is there any wa
Okay, I'll split them with you. I remember the Groton Database Corp. of
Groton Connecticut, whose marketing people didn't like the sound of
*Groton*, and renamed the company Interbase and the product InterBase (note
caps). Ashton Tate came along years later and bought the company to
increase thei
Hi,
it seems selinix doesn't like postgres. Can I uninstall selinux from
fedora savely? OR is there any way to make them both work together?
Here is my error message:
Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc: denied
{ read } for pid=9251 exe=/usr/bin/postgres name=PG_VER
Pruteanu Dragos wrote:
Hi all,
I am running Postgres on a machine with
4G of memory.
When I run
dbvlm=> SELECT u.email, g.email FROM dom_user u,
shared_buffers = 20
sort_mem = 819200
vacuum_mem = 819200
What process led you to choose these values? Do you
# [EMAIL PROTECTED] / 2005-03-01 17:41:46 +0100:
> > > There are 5 vaccinations in a given vaccination schedule.
> > >
> > > Patient had 3 shots.
> > >
> > > I want the view to show me that shot 4 and 5 are missing
> > > without having to enter the cardinality of the vaccination in
> > > the origin
Hi all,
I am running Postgres on a machine with
4G of memory.
When I run
dbvlm=> SELECT u.email, g.email FROM dom_user u,
dom_member m, dom_group g
andlm-> WHERE u.userid=m.userid and
m.groupid=g.groupid and g.iso_language='de' and
dbvlm-> m.type='n' limit 1000;
ERROR: out of memory
DETAIL: Fa
Gordan Bobic wrote:
Hi,
I'm trying to figure out how to do this from the documentation, but I
can't figure it out. :-(
Here is what I'm trying to do:
CREATE TABLE MyTable
(
IDbigserial unique,
MyDatachar(255),
PRIMARY KEY (ID)
);
CREATE TABLE Archive_MyTable
(
IDbigser
Hi,
I'm trying to figure out how to do this from the documentation, but I
can't figure it out. :-(
Here is what I'm trying to do:
CREATE TABLE MyTable
(
ID bigserial unique,
MyData char(255),
PRIMARY KEY (ID)
);
CREATE TABLE Archive_MyTable
(
ID bigseria
Marco Colombo wrote:
If want to develop a commercial application that:
- runs under Linux - I can;
- uses HTTP as protocol, and connects to a GPL-ed web server - I can;
- uses MySQL as a database backend - I can't, unless I rewrite the
client library, or buy a commercial licence from them. Why?
W
On Tue, Mar 08, 2005 at 04:30:54PM -0600, Guy Rouillier wrote:
> This is such a common usage pattern that I'm pretty sure I'm missing
> something basic. Pgsql provides quote_literal to aid with inserting a
> literal string into a dynamically prepared statement. My opinion is
> that quote_literal
Net Virtual Mailing Lists wrote:
All I did was added an extra column to my table (I called it
"batch_process"). Then in
the trigger do something like (in whichever function you are calling):
IF NEW.batch_update IS NOT NULL AND NEW.batch_update = ''t'' THEN
NEW.batch_process := NULL;
RETURN NUL
On Tue, 8 Mar 2005, Scott Marlowe wrote:
On Tue, 2005-03-08 at 09:06, Shelby Cain wrote:
--- Howard Cole <[EMAIL PROTECTED]> wrote:
Although not appropriate for a speed comparison, you
might want to note
that the use of Mysql versions 4.0 upward now
require commercial license
for clients, which are
On Tue, 2005-03-08 at 16:30 -0600, Guy Rouillier wrote:
> We use a dynamic statement in a pgsql stored function to insert rows
> into a table determined at run time. After much debugging, I've
> discovered that a null incoming argument will cause the dynamic
> statement to evaluate to null. The e
Adam Tomjack wrote:
For various reasons, I can't actually delete records from my database.
Instead, I have a boolean 'active' field for each table. I need to
implement something like cascading delete, but instead of deleting, I
need to set active=false.
I've googled and haven't found a solutio
Title: RE: [GENERAL] Move cursor
does i hope that CURSOR will be fully implemented soon ?
(or maybe you know an alternative for my problem ? :) )
-Message d'origine-
De : Michael Fuhr [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 8 mars 2005 18:29
À : Tom Lane
Cc : FERREIRA William (COFR
79 matches
Mail list logo
