On 19.12.2006 20:32, Reece Hart wrote:
On Tue, 2006-12-19 at 13:25 +0100, Hannes Dorbath wrote:
A counter example is searching for information schema, for which you'd
probably want hits to information_schema as well.
I think `information_schema' should be indexed as:
- information
-
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Matthew O'Connor
Sent: woensdag 20 december 2006 2:53
To: Glen Parker; Postgres General
Subject: Re: [GENERAL] Autovacuum Improvements
Alvaro Herrera wrote:
[snip]
I would go one step further and suggest
On Dec 19, 7:03 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote:
On 19 Dec 2006 08:37:01 -0800, BigSmoke [EMAIL PROTECTED] wrote:
What would solve my problem is if there was a
method to, at the end of a begin/end block,
rollback the changes made in that block
without having to raise an
On 19/12/06, Chris Browne [EMAIL PROTECTED] wrote:
matthew@zeut.net (Matthew O'Connor) writes:
2) Once we can have multiple autovacuum workers: Create the concept of
hot tables that require more attention and should never be ignored for
more that X minutes, perhaps have one autovacuum worker
Glen Parker wrote:
Brandon Aiken wrote:
You're saying that the dirtyness of a table is proportional to when you
plan on vacuuming it next.
The dirtiness of a table should most certainly have an effect on when it
gets vacuumed in relation to other tables. If dirtiness could be rated,
then
On Dec 20, 9:02 am, Christian Maier [EMAIL PROTECTED] wrote:
Sorry I have not found a plperl group so I hope the useres of this
group can help me.
I have some csv data and some columns are in a bad format. this means
that some float values are formatet as . if the are 0. So I have
made
On Dec 18, 1:10 pm, [EMAIL PROTECTED] (Sandro Dentella) wrote:
Hi all,
I'm starting a project in which I will use PostgreSQL in which I need to
check permissions at different levels (eg.: status of a record, hierarchy
and so on). The application needs to run with a web interface
On 12/20/06, A. Kretschmer [EMAIL PROTECTED] wrote:
But i have questions/suggestions:
- you have never-used variables in your function. Perhaps you have an
older version from the function with an error and the wrong version
runs?
- perhaps, you have an other trigger on phonebook that calls
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 19 Dec 2006, at 11:44, Albe Laurenz wrote:
Actually I just figured out, that is is not the trigger but the two
cascade on update triggers collide.
It happens also without the trigger:
lt=# UPDATE ltlocation SET id = 4 WHERE id = 18999;
Thanks Devrim and Peter...
I had a feeling that it was just missing something but couldn't see exactly
what it was...
Regards,
Paul
Paul Silveira wrote:
Hello,
I just installed Postgres 8.2 and was trying to add the xml2 contrib
module. I went to the folder that contained the
As for searching spceific mailinglists, you can do that from the
archives search page already. Perhaps it needs to be made more
accessible or something?
Amazing. What I like the most about it is that it actually works.
Great!
that actually worked on the old one as well. The only new
Thanks, I'm going to go ahead and try to implement postgresql kerberos
against active directory 2003 today. I read a bit about it last night
and have a few questions.
You wrote:
* Map PG on database server as a user in Active Directory
o Create user account in AD for PG service
hubert depesz lubaczewski wrote:
On 19 Dec 2006 07:01:41 -0800, Angva [EMAIL PROTECTED] wrote:
shared_buffers = 57344
work_mem = 20
maintenance_work_mem = 524288
work_mem seems to be high. what is you max_connections setting?
max_connections = 100
However we never come even
Well the problem is occurring again, but this time it is intermittent.
I think the crux of the issue is that Linux isn't giving swap to
Postgres - and possibly other - processes. Why this is the case I do
not know and will research. I may shrink work_mem or add more RAM, but
I'd rather use swap
We found that the kernel setting SHMALL was set ridiculously high -
1024g!. Someone noticed this when running ipcs -lm - seemed just a
tad off. :)
-- Shared Memory Limits
max number of segments = 4096
max seg size (kbytes) = 524288
max total shared memory (kbytes) = 1073741824
min
Hi,
I am packaging the postgres database in my application and for this I
need to do a silent install and uninstall, the msiexec for install works
great. Is there a similar utility for uninstall. If not, are there any
other options to achieve this??
Thanks
Amit
Sorry I have not found a plperl group so I hope the useres of this
group can help me.
I have some csv data and some columns are in a bad format. this means
that some float values are formatet as . if the are 0. So I have
made an before insert trigger that looks for these values and replaces
Angva wrote:
We found that the kernel setting SHMALL was set ridiculously high -
1024g!. Someone noticed this when running ipcs -lm - seemed just a
tad off. :)
That's not a problem because it's just a limit. It won't cause out of
memory or anything.
The problem with work_mem is that the
Christian Maier [EMAIL PROTECTED] writes:
I have some csv data and some columns are in a bad format. this means
that some float values are formatet as . if the are 0. So I have
made an before insert trigger that looks for these values and replaces
them but it dont work and I cannot found
On Tue, Dec 19, 2006 at 05:42:05PM -0500, Amit Mody wrote:
Hi,
I am packaging the postgres database in my application and for this I
need to do a silent install and uninstall, the msiexec for install works
great. Is there a similar utility for uninstall. If not, are there any
other options
hi all,
exists a common citation for the postgresql-project, like e.g. for the
R-project:
To cite R in publications, use
@Manual{,
title= {R: A Language and Environment for Statistical
Computing},
author = {{R Development Core Team}},
If anyone else out there can help me understand what this ktpass program
is doing I would be greatful. Also, can anyone help answer these
questions I have. Thanks.
Questions:
- If I have 10 users in postgresql do I need to run this ktpass program
for each user? If so would I always keep
On Mon, Dec 18, 2006 at 22:18:43 -0500,
Chansup Byun [EMAIL PROTECTED] wrote:
Hi,
I'm trying to set up a trigger to prevent any duplicate entries into
my table. But I couldn't figure out how to make my trigger work.
Couldn't you use a unique constraint to do this?
On Tue, Dec 19, 2006 at 11:20:35 +0100,
Udo Zubel [EMAIL PROTECTED] wrote:
Hi Im engineering a PG database with my workmate.
Unfortunately the inheritance feature seems not to be able to solve my
problem.
I have a table order with an orderID, each order has 1 to n types of
articles, like
Joris Dobbelsteen wrote:
Alvaro Herrera wrote:
[snip]
I would go one step further and suggest that when the
maintenance window system gets completed we give it a default
setup of midnight to 6AM or something like that.
Do not do that...
I agree. There is nothing very special about that
Hey Derrick,
I work with Matt, and I was involved in our Kerberos implementation.
I'll try to answer your questions...
- You only need to make the mapping to an Active Directory(AD) user once
for that PG service. What that ktpass command does is map the principal
name for your PG service to an
Great! Thanks so much, I'm going to try to get this going right now.
Do I need unix user accounts?
Garner Chung wrote:
Hey, I think this made it to the list. But I had also CC:ed you
separately -- to which I got a bounce back. So here's my second attempt
to essentially CC: you.
garner
I haven't used the command lines previously having relied on PG Admin.
In the instructions -
Starting postmaster
Nothing can happen to a database unless the postmaster process is running. As
the site administrator, there are a number of things you should remember before
starting the
a shell
http://en.wikipedia.org/wiki/Shell_%28computing%29
On Wed, Dec 20, 2006 at 10:59:05AM -0800, Bob Pawley wrote:
I haven't used the command lines previously having relied on PG Admin.
In the instructions -
Starting postmaster
Nothing can happen to a database unless the postmaster
which in PostgreSQL is
Bob
- Original Message -
From: Ray Stell [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Wednesday, December 20, 2006 11:07 AM
Subject: Re: [GENERAL] Starting Postgresql
a shell
which in PostgreSQL is
Bob
- Original Message -
From: Bob Pawley [EMAIL PROTECTED]
To: Ray Stell [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Wednesday, December 20, 2006 11:12 AM
Subject: Re: [GENERAL] Starting Postgresql
which in PostgreSQL is
Bob
On 20 Dec 2006 at 11:12, Bob Pawley wrote:
which in PostgreSQL is
It's not in PostgreSQL - it's the shell of your operating system. In
Windows, you get that either by clicking Start - Run and typing
command or cmd (depending on your version of windows), or by
clicking on Start - Programs
Raymond O'Donnell wrote:
On 20 Dec 2006 at 11:12, Bob Pawley wrote:
which in PostgreSQL is
It's not in PostgreSQL - it's the shell of your operating system. In
Windows, you get that either by clicking Start - Run and typing
command or cmd (depending on your version of windows), or by
On Wed, 2006-12-20 at 11:13 -0800, Bob Pawley wrote:
which in PostgreSQL is
Bob, you should be looking into your control-panel and service controls
to start the postgresql service.
Sincerely,
Joshua D. Drake
Bob
- Original Message -
From: Bob Pawley [EMAIL PROTECTED]
To:
Here's the url http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm
Bob
- Original Message -
From: Richard Huxton dev@archonet.com
To: Raymond O'Donnell [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Wednesday, December 20, 2006 11:43 AM
Subject: Re:
Nope, no Unix accounts are necessary besides the one that PG runs as.
You do need the PG roles, however. Good luck!
garner
From: Derrick Stensrud [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 20, 2006 10:36 AM
To: Garner Chung
Cc:
I think you're better off to use the official documentation.
http://www.postgresql.org/docs/
(chose the docs for the version you're running on the right side of that
page).
The docs you're currently referencing are for 7.0 - which is stone-age
postgresql.
On Wednesday 20 December 2006 11:57,
Original Message From Bob Pawley
Here's the url
http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm
Bob,
The above documentation is circa version 7.0.
It might be easier to use the current PostgreSQL official documentation.
See for example:
We bit the bullet and upgraded to 8.2 so that we could get the built in
ldap auth support, and boom! It worked out of the box. Thanks a
million and special thanks to Magnus!
Garner Chung wrote:
Nope, no Unix accounts are necessary besides the one that PG runs as.
You do need the PG roles,
Bob Pawley wrote:
Here's the url http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm
As the others say, use the official docs. And perhaps drop osborne a
note to let him know his docs are out of date.
--
Richard Huxton
Archonet Ltd
---(end of
ok. tried to install the correct libs and then do it but still same errors.
Here is where I am now...
# installed both rmp's that were necessary...
rpm -i
ftp://rpmfind.net/linux/redhat/enterprise/4/en/os/i386/SRPMS/libxml2-2.6.16-6.src.rpm
rpm -i
Paul Silveira wrote:
ok. tried to install the correct libs and then do it but still same errors.
Here is where I am now...
# installed both rmp's that were necessary...
rpm -i
ftp://rpmfind.net/linux/redhat/enterprise/4/en/os/i386/SRPMS/libxml2-2.6.16-6.src.rpm
rpm -i
Alvaro Herrera wrote:
Matthew O'Connor wrote:
Glen Parker wrote:
If it isn't there somewhere already, I would ask to add:
4) Expose all information used by autovacuum to form its decisions.
You could argue that this is already there, although not easy to get at
I suppose. But
I vaguely recall that there's an interface to PostgreSQL 7.3 where
developers can directly feed it query plans. Can someone help me
remember where this lived and whether it worked?
The problem I'm looking at is that it's difficult to impossible to get
optimal uses of indexes all the time. Some
Alvaro Herrera wrote:
No, we currently don't expose the number of dead tuples which autovacuum
uses.
Patch submitted :-)
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
I am trying to loop through some data and then run insert some of the
resulting data into a new table. I can create the function but when I run
it i get the error:
ERROR: query SELECT 'INSERT INTO payment (
id,amount,accepted_date, company_id , date ,
patient_responsible_party_id ,
On Wednesday 20 December 2006 7:36 pm, [EMAIL PROTECTED] wrote:
I am trying to loop through some data and then run insert some of the
resulting data into a new table. I can create the function but when I run
it i get the error:
ERROR: query SELECT 'INSERT INTO payment (
[EMAIL PROTECTED] wrote:
I am trying to loop through some data and then run insert some of the
resulting data into a new table. I can create the function but when I run
it i get the error:
ERROR: query SELECT 'INSERT INTO payment (
id,amount,accepted_date, company_id , date ,
Hi Paul,
On Wed, 2006-12-20 at 14:07 -0800, Paul Silveira wrote:
ok. tried to install the correct libs and then do it but still same errors.
Here is where I am now...
# installed both rmp's that were necessary...
rpm -i
Dear :
These days, I come across a problem that I can’t solve i , so I ask U
for help.
Problem Description:
I use RedHat AS 4 + PostgreSQL 8.1 as our server. As long as
the server program starts, it’ll immediately open 10~20 connects to the DB to
handle
On Wednesday 20 December 2006 7:36 pm, [EMAIL PROTECTED] wrote:
I am trying to loop through some data and then run insert some of the
resulting data into a new table. I can create the function but when I
run
it i get the error:
ERROR: query SELECT 'INSERT INTO payment (
[EMAIL PROTECTED] wrote:
I am trying to loop through some data and then run insert some of the
resulting data into a new table. I can create the function but when I
run
it i get the error:
ERROR: query SELECT 'INSERT INTO payment (
id,amount,accepted_date, company_id , date ,
Sounds like pgpool. http://pgpool.projects.postgresql.org/
On Thu, 2006-12-21 at 12:01 +0800, 马庆 wrote:
Dear :
These days, I come across a problem that I can’t solve i , so
I ask U for help.
Problem Description:
I use RedHat AS 4 + PostgreSQL 8.1 as
Hello,I'm using JSP for accessing postgre
My postgre version is 8.1 running on suse enterprise 10 linux machine.
My JSP container is Apache Tomcat 5.5.
My connection method is JNDI(pooling).
Recently I'm having trouble after my web application is being accessed by
many users.
My error log shows
54 matches
Mail list logo