Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 00:46, Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 19:57, Rick Gigger wrote:
[snip]
Not much that is useful. I think this is a
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 20:41, andrew plata wrote:
I am trying to following the instructions at URL below to try to create a
database called web_database required for phpPgAdmin. When I try to do this
I get the following error:
template1=#
Hi,
I am using and installing pg on many servers running
FreeBSD and it works perfect.
Now I need to install a brand new Solaris 10 ( from
opensolaris.org) on amd64 (Opteron) and install pg on
it.
Till now I installed pg from source (on FreeBSD and
many linux systems).
My first question :
Is
Hello all,
Im developing a specialist application
that needs a different kind of referential integrity! I need interval
referential integrity where the bounds of the referenced interval must overlaps
(or be equal) the bounds of the referencing interval!
For example,
Hello,
I have table for online chat system that keep messages sent between users.
CREATE TABLE chat_message
(
message_time timestamp without time zone NOT NULL DEFAULT now(),
message_body text,
user_id_from bigint,
user_id_to bigint,
CONSTRAINT chat_message_pkey PRIMARY KEY (message_time)
On Thu, 19 Oct 2006, Joe Kramer wrote:
Question: is it okay to use timestamp as primary key, or there is
possibility of collision? (Meaning two processes may INSERT into table
within same millisecond.) It is a web application.
If your insert fail you can always try again after some random
Hi all,
we are struggling for some time now with PostgreSQL 8.1.4 and the
situation is pretty critical so please help with whatever comes to
your mind.
We even did an upgrade from version 7.4.13, tried different vacuum
configurations and optimized the configuration.
There is a table called
Rick Gigger wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 00:46, Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 19:57, Rick Gigger wrote:
[snip]
Not much that is useful.
On Thu, 19 Oct 2006, Peter Bauer wrote:
A vaccum of the whole database is performed every 10 minutes with
cron
What is the command you use? Maybe you are vaccuming with -f and
locking the whole table.
Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
Hello List,
I work with PostgreSQL 8.1.3 on an IA64 server with Red Hat Enterprise
Linux 4 AS and I try to install Munin 1.2.4.
To do that, I downloaded these RPM from Sourceforge :
- munin-1.2.4-8rhel4.noarch.rpm
-munin-node-1.2.4-8rhel4.noarch.rpm
and munin-plugins-postgresql-0.3.tar.tar
On 10/19/06, DANTE Alexandra [EMAIL PROTECTED] wrote:
My problem is that I have not found any RPM for perl-rrdtool and
rrdtool for IA64 and RHEL4-AS (for the others, it's OK).
Does someone know where I can find them or tell me where I can find the
associated tar.gz archive ?
Download the
Hi,
its just a vacuumdb --all. We already learned that full vacuums are
evil because the database was carrupted after some time.
Regards,
Peter
2006/10/19, Tomasz Ostrowski [EMAIL PROTECTED]:
On Thu, 19 Oct 2006, Peter Bauer wrote:
A vaccum of the whole database is performed every 10
Peter Bauer [EMAIL PROTECTED] writes:
There is a table called tableregistrations where per day about
1 million rows are INSERTed
2 SELECTs should be performed on it
1 UPDATEs should be performed where about 100 rows are updated
with each execution
1 DELETEs should be performed
Hello Robin, hello List,
I have also spent several minutes searching the src.rpm, but the only
rpm source that I found was for Fedora Core...
For example, in the site
http://rpm.pbone.net/index.php3/stat/4/idpl/2919466/com/perl-rrdtool-1.2.13-1.fc3.rf.x86_64.rpm.html,
the rpm source available
On Thu, Oct 19, 2006 at 01:42:48AM -0700, Georgi Petrov wrote:
Is it better to install pg on Solaris from packages or
build it from source?
Define better. I prefer to build from source so I know I'm using
the same source code the developers are using and so I can control
the configure
Joe Kramer wrote:
Hello,
I have table for online chat system that keep messages sent between users.
CREATE TABLE chat_message
(
message_time timestamp without time zone NOT NULL DEFAULT now(),
Hmm - timestamp without time zone. So you don't actually care when the
message was sent? Or you
Peter Bauer wrote:
- Two of these clusters are using the same PostgreSQL installation to
share the data
Just checking - you're not sharing the same data files between two
machines here, are you? Because that's not good.
--
Richard Huxton
Archonet Ltd
---(end of
cckramer wrote:
I have table for online chat system that keep messages sent between
users.
Question: is it okay to use timestamp as primary key, or there is
possibility of collision? (Meaning two processes may INSERT into table
within same millisecond.) It is a web application.
tometzky
On Thu, 19 Oct 2006 06:14:46 -0600, Rick Gigger wrote:
I think we've got it figure out though. We were able to patch up the
db enough to extract the data with some help from google and old postings
from Tom.
It would be really great if you put down the specifics of what you
googled/old
On Oct 19, 2006, at 10:30 , John D. Burger wrote:
cckramer wrote:
I have table for online chat system that keep messages sent
between users.
Question: is it okay to use timestamp as primary key, or there is
possibility of collision? (Meaning two processes may INSERT into
table
within
[EMAIL PROTECTED] (Tom Lane) writes:
Chris Browne [EMAIL PROTECTED] writes:
(gdb) print addr-ai_addr-sa_data
$18 = \000\001\177\000\000\001\000\000\000\000\000\000\000
Hmm, that looks a bit odd --- what's the full declaration of structs
sockaddr and sockaddr_in on that machine?
struct
Can anyone point me to an overview of PostGIS and how it
is being used???
Bob Pawley
Here is their web page:
http://postgis.refractions.net/
I am probably not the best to answer how it is used because
we use it just to allow index on spatial data (coordinates). You may ask
on the postgis mailing list.
Woody
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Hi,
the drbd device can only be active and mounted on one machine, so the
other is just in standby.
Regards,
Peter
2006/10/19, Richard Huxton dev@archonet.com:
Peter Bauer wrote:
- Two of these clusters are using the same PostgreSQL installation to
share the data
Just checking - you're not
thank you, so we will perform the tests with such a vacuum configuration,
br,
Peter
2006/10/19, Tom Lane [EMAIL PROTECTED]:
Peter Bauer [EMAIL PROTECTED] writes:
There is a table called tableregistrations where per day about
1 million rows are INSERTed
2 SELECTs should be performed on
On Oct 19, 2006, at 11:08 AM, Bob Pawley wrote:Can anyone point me to an overview of PostGIS and how it is being used??? Bob,Ā PostGIS provides extensions to PostgreSQL's procedural language and geometric data types so that it can store geo-referenced data, and so that you can query this data using
On Thu, Oct 19, 2006 at 07:51:17AM -0300, Rodrigo Sakai wrote:
I?m developing a specialist application that needs a different kind of
referential integrity! I need interval referential integrity where the
bounds of the referenced interval must overlaps (or be equal) the bounds of
the
On Thu, Oct 19, 2006 at 10:36:29AM -0400, AgentM wrote:
Only if each message is contained in its own transaction since now()
is effectively a constant throughout a transaction. In this case, I
would choose a surrogate key since it is likely that the table will
be referenced.
See
I use postgis to wipe my ASS ...no good documentation ...in what units is the result of distance(geometry,geometry)..what is distance_sphere(geometry,geometry).. when u give same geometry as both parameters it gives a non-zero value
On 10/19/06, James Cradock [EMAIL PROTECTED] wrote:
On Oct
Chris Browne [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] (Tom Lane) writes:
Chris Browne [EMAIL PROTECTED] writes:
(gdb) print addr-ai_addr-sa_data
$18 = \000\001\177\000\000\001\000\000\000\000\000\000\000
Hmm, that looks a bit odd --- what's the full declaration of structs
sockaddr and
On Thu, Oct 19, 2006 at 01:57:56PM +0200, Peter Bauer wrote:
In the update statement, don't wrap the ID values in quotes. At best
it's extra work; at worse it will fool the planner into not using the
index.
shared_buffers = 1000 # min 16 or max_connections*2, 8KB each
This is *way*
[EMAIL PROTECTED] (Tom Lane) writes:
Brad Nicholson [EMAIL PROTECTED] writes:
On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote:
Also, do regular connections to this postmaster work across TCP/IP?
If getaddrinfo() is broken I'd expect there to be problems binding
to the postmaster's listen
Thanks Jim
Bob
- Original Message -
From:
James Cradock
To: Postgresql
Cc: Bob Pawley
Sent: Thursday, October 19, 2006 8:35
AM
Subject: Re: [GENERAL] PostGIS
On Oct 19, 2006, at 11:08 AM, Bob Pawley wrote:
Can anyone point me to an overview of
[EMAIL PROTECTED] (Tom Lane) writes:
Chris Browne [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] (Tom Lane) writes:
Chris Browne [EMAIL PROTECTED] writes:
(gdb) print addr-ai_addr-sa_data
$18 = \000\001\177\000\000\001\000\000\000\000\000\000\000
Hmm, that looks a bit odd --- what's the full
Chris Browne [EMAIL PROTECTED] writes:
Is there a more elegant way of setting the requested port to 0 than my
2-liner?
What I'm tempted to do is add this to pg_getaddrinfo_all (in
src/backend/libpq/ip.c):
{
/* not all versions of getaddrinfo() zero *result on failure */
[EMAIL PROTECTED] (Tom Lane) writes:
Chris Browne [EMAIL PROTECTED] writes:
Is there a more elegant way of setting the requested port to 0 than my
2-liner?
What I'm tempted to do is add this to pg_getaddrinfo_all (in
src/backend/libpq/ip.c):
{
/* not all versions of getaddrinfo()
Chris Browne [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] (Tom Lane) writes:
What I'm tempted to do is add this to pg_getaddrinfo_all (in
src/backend/libpq/ip.c):
...
That seems to work fine, too. And that seems somewhat more
portable/elegant/something.
OK, patch applied as far back as 7.4
On 10/19/06, DANTE Alexandra [EMAIL PROTECTED] wrote:
Hello Robin, hello List,
Can I use it on RHEL4-AS ? I also tried to find the rpm sources on the
Red Hat web site, without success...
/index.php3/stat/3/srodzaj/2/search/rrdtool-1.2.13-1.fc3.rf.src.rpm
Download the source and try. rpmbuild
I am migrating a database from 7.4 in SQL_ASCII encoding to 8.1 in UTF8.
I made a pg_dump of the 7.4 database. I had difficulty (there are
invalid UTF8 characters in the original database, like 0xb9) going
straight into 8.1 with UTF8, so I tried importing it in a temporary 8.1
cluster that I set
I want to upgrade a system from 7.3.8 ro 8.1.5
I am new to Psql and looking for handy hints
Any known problems or pit-falls ?
Anything we need to do in preparation ?
Cheers
CraigW
---(end of broadcast)---
TIP 3: Have you checked our extensive
Hi,
I have a question connected with postgres procedural langauge. Version
of Postgres:
PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc
I have a table on which I have created many triggers on the same event
BEFORE UPDATE.
I have 3 these triggers. In each of this trigger I have a
I wants to make a view giving me some statistics.
I am not sure to understand why something like this
SELECT location_id, (sold_parts_amount_dly + sold_labor_amount_dly) /
(sold_parts_amount_dly + sold_labor_amount_dly) from sales
give me a division by zero error?
If that is not the way to go,
Hi,
I have a strange problem running Django on a GrokThis.net shared
hosting account:
Environment:
--
Apache/2.0.59 (Unix)
mod_fastcgi/2.4.2
PostgreSQL 8.1.3
--
settings.py:
I want to upgrade a system from 7.3.8 ro 8.1.5
I am new to Psql and looking for handy hints
Any known problems or pit-falls ?
Anything we need to do in preparation ?
The Postgresql manual is a good place to start:
http://www.postgresql.org/docs/8.1/interactive/install-upgrading.html
Bernard Grosperrin wrote:
I wants to make a view giving me some statistics.
I am not sure to understand why something like this
SELECT location_id, (sold_parts_amount_dly + sold_labor_amount_dly) /
(sold_parts_amount_dly + sold_labor_amount_dly) from sales
give me a division by zero error?
thank you very much, we will test it
br,
Peter
2006/10/19, Jim C. Nasby [EMAIL PROTECTED]:
On Thu, Oct 19, 2006 at 01:57:56PM +0200, Peter Bauer wrote:
In the update statement, don't wrap the ID values in quotes. At best
it's extra work; at worse it will fool the planner into not using the
Hello:
I am going to install Ubuntu OS under their LAMP
installation. This LAMP installation installs mySQL. Is there any way I can install
postgreSQL instead of mySQL? Has anybody created a LAMP to install Ubuntu,
Apache, postgreSQL PHP?
Kirt
Hello:
I am going to install Ubuntu OS under their LAMP installation. This LAMP
installation installs mySQL. Is there any way I can install postgreSQL
instead of mySQL? Has anybody created a LAMP to install Ubuntu, Apache,
postgreSQL PHP?
Kirt
after instalation do
sudo apt-get
kbajwa wrote:
Hello:
I am going to install Ubuntu OS under their LAMP installation. This LAMP
installation installs mySQL. Is there any way I can install postgreSQL
instead of mySQL? Has anybody created a LAMP to install Ubuntu, Apache,
postgreSQL PHP?
Kirt
I don't know about a
Do I need to remove mySQL or leave it installed?
Kirt
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Leonel Nunez
Sent: Thursday, October 19, 2006 4:02 PM
To: kbajwa
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Ubuntu Help
Hello:
I am
Do I need to remove mySQL or leave it installed?
Kirt
If you don't need itremoveit
leonel
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I'm running postgres 8.0.8. I have a table that is updated very
rapidly, so I vacuum it every 10 minutes. The problem is that I
sometimes have transactions that hang out for a long time without doing
anything. These transactions are preventing VACUUM from cleaning up
tuples that were
On Thu, Oct 19, 2006 at 04:18:50PM -0400, Joseph Shraibman wrote:
I'm running postgres 8.0.8. I have a table that is updated very
rapidly, so I vacuum it every 10 minutes. The problem is that I
sometimes have transactions that hang out for a long time without doing
anything. These
Martijn van Oosterhout wrote:
Sure, don't keep transactions open for so long. Is there a particular
reason you do that?
Because I have a leak somewhere? Even if the transaction isn't that old
it will still cause me some table bloat in the meantime.
The problem is that the old transaction
On Thu, Oct 19, 2006 at 04:25:09PM -0400, Joseph S wrote:
The problem is that the old transaction can see effects of later
started transactions, so VACUUM can't delete the later stuff either...
How can it see effects of transactions that started after it?
Check the documentation for the
On Oct 19, 2006, at 8:19 AM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
I want to upgrade a system from 7.3.8 ro 8.1.5
I am new to Psql and looking for handy hints
Any known problems or pit-falls ?
You'll need to dump the database and reload (pg_dump and pg_restore),
8.1 uses a
But if the tuple in question was created and then deleted after the
transaction, the transaction should still not need to see it.
Martijn van Oosterhout wrote:
On Thu, Oct 19, 2006 at 04:25:09PM -0400, Joseph S wrote:
The problem is that the old transaction can see effects of later
started
Hello Postgres-General users
I currently am upgrading from PostgreSQL 7.3.4-RH to
PostgreSQL 8.1.5. Everything fine so far: have
installed 8.1.5 into /usr/local/pgsql, of course, and am
running 8.1.5 on port 5433,
while still running 7.3.4 (in /var/lib/... and /usr/bin/pg...)
Then (also,
Hello
Just trying to play around with PostgreSQL. Some commands and their
result are:
test=# create table ncbi ( id serial, title varchar(50), abstract text,
primary key(id));
NOTICE: CREATE TABLE will create implicit sequence ncbi_id_seq for
serial column ncbi.id
NOTICE: CREATE TABLE /
Maurice Yarrow [EMAIL PROTECTED] writes:
I am hoping that there is an equivalent
upgraded init.d/postgresql startup/shutdown script available
for the postgres 8.1 tree.
The Postgres project proper doesn't maintain system-specific start
scripts. Look in the RPM distributions instead ---
On Thu, 2006-10-19 at 18:32 -0500, Ritesh Nadhani wrote:
Hello
Just trying to play around with PostgreSQL. Some commands and their
result are:
test=# create table ncbi ( id serial, title varchar(50), abstract text,
primary key(id));
NOTICE: CREATE TABLE will create implicit sequence
Thanks.
So the implicit value means that PG gave it a name?
Jeff Davis wrote:
On Thu, 2006-10-19 at 18:32 -0500, Ritesh Nadhani wrote:
Hello
Just trying to play around with PostgreSQL. Some commands and their
result are:
test=# create table ncbi ( id serial, title varchar(50), abstract
Joseph S jks@selectacast.net writes:
But if the tuple in question was created and then deleted after the
transaction, the transaction should still not need to see it.
No, because it might have taken a snapshot during the interval where the
tuple was good.
regards, tom
On Thu, 2006-10-19 at 19:05 -0500, Ritesh Nadhani wrote:
Thanks.
So the implicit value means that PG gave it a name?
Right, when you declare a column to be a primary key, PostgreSQL must
create an index to enforce the unique constraint. This index must have
some kind of name, so PostgreSQL
I'm having trouble figuring out when (if) the planner inlines sql
functions (I'm running 7.4). I was assuming that pure sql functions
are kind of like views with parameters, but I can't seem to see any
cases where functions that select from a table get inlined. For
instance:
create
John D. Burger [EMAIL PROTECTED] writes:
I'm having trouble figuring out when (if) the planner inlines sql
functions (I'm running 7.4). I was assuming that pure sql functions
are kind of like views with parameters, but I can't seem to see any
cases where functions that select from a
Hi,
The docs say:
A SELECT INTO statement sets FOUND true if it returns a row,
false if no row is returned.
I'm running a plpgsql procedure from a trigger and
am doing a SELECT INTO foo bar ... where a row
matches the selection criteria, but the value of
that row's bar column is NULL. The
On Thu, Oct 19, 2006 at 09:31:40PM +0530, Sandeep Kumar Jakkaraju wrote:
I use postgis to wipe my ASS ...
no good documentation ...
If you find the documentation lacking then please consider posting
to postgis-users with suggestions for improving it. Even better,
submit a patch :-)
in what
Karl O. Pinc [EMAIL PROTECTED] writes:
I would expect that because a row exists, even
though the value assigned is NULL, FOUND would
be TRUE. Are my expectations wrong?
No, but I think your code is. Please provide a test case demonstrating
this behavior.
regards, tom
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 14:34, kbajwa wrote:
Do I need to remove mySQL or leave it installed?
It certainly won't *hurt* to leave it there, but it's always *smart*
to purge un-needed systems from a server.
As for installing the _A_P porrtions of LAMP, if lamp
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 15:22, Martijn van Oosterhout wrote:
On Thu, Oct 19, 2006 at 04:18:50PM -0400, Joseph Shraibman wrote:
I'm running postgres 8.0.8. I have a table that is updated very
rapidly, so I vacuum it every 10 minutes. The problem is that I
Maurice Yarrow wrote:
In fact, the only thing I cannot find is a recent copy (for
8.1.5 located in /usr/local/pgsql) of an init.d startup script
for the postgres, equivalent to the currently running
/etc/rc.d/init.d/postgresql(which is about 250 lines
of shell).
If you download the
am Thu, dem 19.10.2006, um 2:49:23 -0700 mailte [EMAIL PROTECTED] folgendes:
Hi,
I have a question connected with postgres procedural langauge. Version
of Postgres:
PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc
Outdated.
I have a table on which I have created many
Ritesh Nadhani wrote:
Hello
Just trying to play around with PostgreSQL. Some commands and their
result are:
test=# create table ncbi ( id serial, title varchar(50), abstract text,
primary key(id));
NOTICE: CREATE TABLE will create implicit sequence ncbi_id_seq for
serial column ncbi.id
74 matches
Mail list logo