On Apr 19, 2005, at 22:56, Dann Corbit wrote:
Have you actually seen any problem in simple get/put/delete/update
situations?
Not sure, that I understand your question.
It's a shame when people spend a great deal of effort to invent a cure
for a disease that does not exist.
If you have problems with
Baldur Norddahl wrote:
> Is there a better way to query the status of postgresql? I would
> expect it to at least check that the process in the PID is actually
> running and that it is a postgresql process.
Maybe try
test $(readlink /proc/$pid/exe) = /usr/bin/postgres
--
Peter Eisentraut
http:/
On Apr 19, 2005, at 23:24, Dan Sugalski wrote:
At 9:40 PM +0400 4/19/05, Alexandre wrote:
Lane, thank you, but it is not: PostISAM "generates SQL statements on
the fly from traditional ISAM (read, write, start) statements", so it
just add overhead, and is not what I'm looking for.
Speaking from e
Tom, yes, something like Berkeley DB, but inside PostgreSQL... It may
sounds crazy, but some data just need not all SQL functionality and
overhead, and at the same time I need not second db, so the best
possible solution (in my opinion): two ways of the data access inside
one db.
Regards,
/Ale
On Apr 19, 2005, at 4:35 AM, neo anderson wrote:
lately i download postgresql 8.0.2 (window version)
from postgresql mirror website site. and i read the
document, saying that postgresql support multibyte
encoding
(http://www.postgresql.org/docs/8.0/static/multibyte.html).
but during installation, i
Hi,
There is no particular pattern but it is generally the update queries of the
form "update tableName set colName='something'" that are taking a lot of
time incase there is a lot of background data. Also, I would not like to
change my application to access data from another schema when require
Added to TODO list:
* Log queries where the optimizer row estimates were dramatically
different from the number of rows actually found (?)
---
Doug Fields wrote:
>
> >Tom Lane wrote:
> > > Bruce Momjian
What I was trying to do was export the database on one computer and import it onto another. I gave up trying to fix the export problem since I had an old backup of the database. It was old enough that it was short three tables, but I have the raw tab delimited data so I just reconstructed the datab
I am Seeing twelve of these messages every five to ten seconds in the
Postgresql serverlog when my java application is running:
2005-04-19 16:43:03 LOG: 0: duration: 0.246 ms
LOCATION: exec_simple_query, postgres.c:960
2005-04-19 16:43:03 LOG: 0: statement: rollback; begin;
LOCATION:
On Tue, 19 Apr 2005 11:53 pm, Lorenzo Thurman wrote:
> Thanks for the reply. I've tried recompiling with my install build
> settings, but no luck. I've posted a message on the Gentoo forums.
> Hopefully they will have an answer. If they do, I'll post back here for
> future reference.
>
I read y
Hi,
I am working on making a postgresql/drbd/heartbeat high availability
cluster. I need a script for heartbeat to start, stop and query the
service. I wrote the following:
pgStart() {
su - pg0 -c "cd data ; /mnt/data0/postgresql/bin/pg_ctl start -D
/mnt/data0/postgresql/data -w -o '-i -
At 9:40 PM +0400 4/19/05, Alexandre wrote:
Lane, thank you, but it is not: PostISAM "generates SQL statements
on the fly from traditional ISAM (read, write, start) statements",
so it just add overhead, and is not what I'm looking for.
Speaking from experience, as I have a system which hides Postg
Ironic too, if we think of the name "Stonebreaker"
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ian Harding
Sent: Tuesday, April 19, 2005 9:02 AM
To: Michael Fuhr
Cc: Daniel Schuchardt; pgsql-general@postgresql.org
Subject: Re: [GENERAL] What means Post
Have you actually seen any problem in simple get/put/delete/update
situations?
It's a shame when people spend a great deal of effort to invent a cure
for a disease that does not exist.
If you have problems with any of these things, there are usually good
solutions.
Using the copy API, you can in
On Tue, Apr 19, 2005 at 11:31:50AM -0600, Abe Burnett wrote:
> Essentially, literally installing an application with a
> non-administrative account is nearly impossible because that's the
> whole purpose of having such things as non-administrative accounts.
> I'm probably preaching to the choir he
Alexandre <[EMAIL PROTECTED]> writes:
> Lane, thank you, but it is not: PostISAM "generates SQL statements on
> the fly from traditional ISAM (read, write, start) statements", so it
> just add overhead, and is not what I'm looking for.
Well, if you don't want any SQL capability at all, I think y
Richard Huxton wrote:
vinita bansal wrote:
Hi,
I have a 40GB database with a few tables containing approx 10 million
rows. Most of the data in these tables is inactive and there is only
a few rows which get used for our benchmark run each day. We cannot
delete the inactive data since it might b
vinita bansal wrote:
Hi,
I have a 40GB database with a few tables containing approx 10 million
rows. Most of the data in these tables is inactive and there is only a
few rows which get used for our benchmark run each day. We cannot delete
the inactive data since it might be required for a parti
Michael Fuhr wrote:
On Tue, Apr 19, 2005 at 12:39:52PM -0400, Alvaro Herrera wrote:
On Tue, Apr 19, 2005 at 10:03:45AM -0600, Michael Fuhr wrote:
On Tue, Apr 19, 2005 at 11:17:46AM -0500, Don Isgitt wrote:
Thanks, Tom. Interestingly enough, neither my original query or your
correct
Lane, thank you, but it is not: PostISAM "generates SQL statements on
the fly from traditional ISAM (read, write, start) statements", so it
just add overhead, and is not what I'm looking for.
Anyway, thank you for the information.
Regards,
/Alexandre.
On Apr 19, 2005, at 18:16, Tom Lane wrote:
A
Thanks for helping Joshua!
While I do attempt to install PostgreSQL using my normal windows account
(which of course has administrative rights), I've installed PostgreSQL
before and never run into this problem. It appears that as long as you
establish a different user name which isn't an administra
Then I guess I need to know how one can encapsulate variables in quotes, yet let the pl/pgsql interpreter interpolate.
In the case of my SELECT INTO, are the quotes even needed to avoid potential confusion with column names?On 4/19/05, Richard Huxton <
dev@archonet.com> wrote:Benjamin Holmberg wrot
Benjamin Holmberg wrote:
This is the error message I'm getting by using: ''arg_id'' instead of:
(CAST(arg_id
AS integer))
SELECT production_scheduled_for_date('2005-05-12', '49');
ERROR: invalid input syntax for integer: "arg_id"
That's because ''arg_id'' is the string value "arg_id", those six
ch
> On Mon, 2005-04-18 at 17:18 -0400, Tom Lane wrote:
> > "Christopher Nelson" <[EMAIL PROTECTED]> writes:
> > > I'm developing a hobby OS and I'm looking into file systems. I've
> > > thought about writing my own, and that appeals, but I'm also very
> > > interested in the database-as-a-filesystem
Hi,
I have a 40GB database with a few tables containing approx 10 million rows.
Most of the data in these tables is inactive and there is only a few rows
which get used for our benchmark run each day. We cannot delete the inactive
data since it might be required for a particular run some day wh
On Tue, Apr 19, 2005 at 12:39:52PM -0400, Alvaro Herrera wrote:
> On Tue, Apr 19, 2005 at 10:03:45AM -0600, Michael Fuhr wrote:
> > On Tue, Apr 19, 2005 at 11:17:46AM -0500, Don Isgitt wrote:
> > >
> > > Thanks, Tom. Interestingly enough, neither my original query or your
> > > corrected one retur
On Tue, Apr 19, 2005 at 10:03:45AM -0600, Michael Fuhr wrote:
> On Tue, Apr 19, 2005 at 11:17:46AM -0500, Don Isgitt wrote:
> >
> > Thanks, Tom. Interestingly enough, neither my original query or your
> > corrected one returns anything with pg 7.4--another good reason to
> > upgrade to 8.*
>
> H
Michael Fuhr schrieb:
According to "The design of POSTGRES" by Stonebreaker and Rowe,
POSTGRES means "POST inGRES" (the successor to INGRES). Various
other sources say that INGRES means "INteractive Graphics (and)
REtrieval System."
Ah, this is what i searched.
I read
http://www.postgresql.org/doc
On Tue, Apr 19, 2005 at 11:17:46AM -0500, Don Isgitt wrote:
>
> Thanks, Tom. Interestingly enough, neither my original query or your
> corrected one returns anything with pg 7.4--another good reason to
> upgrade to 8.*
Hmmm...for me both queries give the results shown if I run them in
7.3.9, 7.4
Don't forget to cc: the list...
Benjamin Holmberg wrote:
This is one of the "bad" ones...
I would call it like the following:
SELECT SIMPLE_date_used('5/11/06','5');
Well, you're trying to call it with two text-values here (or at least
two unknown values).
SELECT simple_date_used('5/11/06'::date,
Or, according to Babelfish, if "Postgres" is a Spanish word, it
translates to "poststoneware" in English.
Nonsense of course, but I thought it was funny.
On 4/19/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Tue, Apr 19, 2005 at 05:24:22PM +0200, Daniel Schuchardt wrote:
> >
> > What means Pos
On Tue, Apr 19, 2005 at 05:24:22PM +0200, Daniel Schuchardt wrote:
>
> What means Postgres? Where and why this name was born?
See "A Brief History of PostgreSQL" in the PostgreSQL documentation
and some of the documents it links to:
http://www.postgresql.org/docs/8.0/interactive/history.html
Ac
Its a takeoff of ingres, the ORDBMS (Object-Relational Database Management System) postgres is based on...The origins date to 1977 at UC Berkeley.
On 4/19/05, Daniel Schuchardt <[EMAIL PROTECTED]> wrote:
Just for fun and interrest.What means Postgres? Where and why this name was born?Daniel
Tom Lane wrote:
Don Isgitt <[EMAIL PROTECTED]> writes:
gds2=# select substring('NE NE SE 2310 FSL 330 FEL' from '^([A-Z][A-Z] )+');
substring
---
SE
(1 row)
The pg docs say that this form of substring uses POSIX re's, and my
understanding of POSIX re's is they are always greedy
Just for fun and interrest.
What means Postgres? Where and why this name was born?
Daniel
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
This is one of the "bad" ones hacked up to work like it should...
I would call it like the following:
SELECT SIMPLE_date_used('5/11/06','5');
beginning_date and ending_date are date columns in MyTable. The
function is checking to see if given_date falls within a date range
that has already been
On Tue, Apr 19, 2005 at 10:01:26AM -0500, Benjamin Holmberg wrote:
>
> When creating a function which accepts a single argument, things work just
> fine, variable can be used throughout the function as expected with no
> modification.
> When creating functions containing two or more arguments, I
Benjamin Holmberg wrote:
Hello-
This is my first foray into pl/psql so forgive me if I sound totally
incompetent.
I've been writing a few functions, and have come across some screwing data
typing issues.
When creating a function which accepts a single argument, things work just
fine, variable
Hello-
This is my first foray into pl/psql so forgive me if I sound totally incompetent.
I've been writing a few functions, and have come across some screwing data typing issues.
When creating a function which accepts a single argument, things
work just fine, variable can be used throughou
Don Isgitt <[EMAIL PROTECTED]> writes:
> gds2=# select substring('NE NE SE 2310 FSL 330 FEL' from '^([A-Z][A-Z] )+');
> substring
> ---
> SE
> (1 row)
> The pg docs say that this form of substring uses POSIX re's, and my
> understanding of POSIX re's is they are always greedy. So, why d
I'm trying to find out which columns of which tables reference which
columns of which tables by querying the information_schema. I found
the referencing columns in key_column_usage and the referenced columns
in constraint_column_usage - fine so far.
Now consider the following:
CREATE TABLE t1
Hi.
First: PG version 7.4 and 8.0.
I have a question regarding the following simplified query:
gds2=# select substring('NE NE SE 2310 FSL 330 FEL' from '^([A-Z][A-Z] )+');
substring
---
SE
(1 row)
The pg docs say that this form of substring uses POSIX re's, and my
understanding of POSIX re
ElayaRaja S <[EMAIL PROTECTED]> writes:
> bash-2.05b$ pg_ctl stop
> /usr/local/pgsql/bin/pg_ctl: line 274: kill: (19859) - No such process
> waiting for postmaster to shut
> down
> failed
> pg_ctl: postmaster does not shut down
Is the
Alexandre <[EMAIL PROTECTED]> writes:
> What I mean is: currently to get/put/delete/edit any data I have to
> compose an SQL query, which should be parsed, compiled, optimized and
> so on. While, in some tasks simple interface a-la [G|N]DBM should be
> more than enough, but it will be more prefe
Hi List!
What ist the best and easiest way to trigger a commandline command out
from the database? We want to start a printjob.
I think it could work with pl/tclu but i am not familar with that language.
Thanks in Advance,
Thomas
---(end of broadcast)
Hi,
On Tue, 19 Apr 2005, Leonel Nunez wrote:
There's been a change on libpq from libpq.so.3 to libpq.so.4
you need to recompile all the pagackes that depend on libpq.so.3 so they
can use the new libpq.so.4
Actually, no.
Reinhard Max, the SuSE PostgreSQL RPM maintainer has just wrote that:
"W
R WARRINER wrote:
Anyone ran across a broken libpq.so.3 link from the SLES rpm, and if
so found a solution to fix it?
Regards,
Paul
PS,
YaST2 conflicts list - generated 2005-04-19 04:22:00
freeradius 0.9.3-106.6 conflict
Unresolved Requirements:
freeradius requires
Thanks for the reply. I've tried recompiling with my install build
settings, but no luck. I've posted a message on the Gentoo forums.
Hopefully they will have an answer. If they do, I'll post back here for
future reference.
On Apr 19, 2005, at 1:01 AM, Tom Lane wrote:
Lorenzo Thurman <[EMAIL PR
Yes. Thanks. I ran VACUUM ANALYZE and got the same results...
-Jack
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Anyone ran across a broken libpq.so.3 link from the SLES
rpm, and if so found a solution to fix it?
Regards,
Paul
PS,
YaST2 conflicts list - generated 2005-04-19 04:22:00
freeradius 0.9.3-106.6 conflict
Unresolved Requirements:
freeradius
requires libpq
Good day,
excuse me, if my question is lame, but is it possible to get some
simplified access to the PostgreSQL?
What I mean is: currently to get/put/delete/edit any data I have to
compose an SQL query, which should be parsed, compiled, optimized and
so on. While, in some tasks simple interface
lately i download postgresql 8.0.2 (window version)
from postgresql mirror website site. and i read the
document, saying that postgresql support multibyte
encoding
(http://www.postgresql.org/docs/8.0/static/multibyte.html).
but during installation, i can't find the item in the
drop-down list, which
On Mon, 2005-04-18 at 17:18 -0400, Tom Lane wrote:
> "Christopher Nelson" <[EMAIL PROTECTED]> writes:
> > I'm developing a hobby OS and I'm looking into file systems. I've
> > thought about writing my own, and that appeals, but I'm also very
> > interested in the database-as-a-filesystem paradigm
Hi,
I am using postgreSQL 7.4.5 in Redhat Linux 9. Whenever i faced
power failure ,
i am unable to stop the postgres.
bash-2.05b$ pg_ctl stop
/usr/local/pgsql/bin/pg_ctl: line 274: kill: (19859) - No such process
waiting for postmaster to shut
down...
54 matches
Mail list logo