Ben,
As far as I can see MusicBrainz only does one way replication (which I already
achieved).
Two ways replication (without re-sending the information you have just
received) is a bit more complex.
I could not find much info on the MusicBrainz project anyway.
Thanks,
[EMAIL PROTECTED]
The
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I must replicate (or synchronise) data between disconnected
postgreSQL databases ... hence a replication very asynchronous!
Check out Bucardo (http://bucardo.org). It should be able to do
what you want with a swap sync (master-master). If
Hi, Newbie here,
I have implemented a stored procedure that writes out the newest DB entry on
insert, and combined it with a rule.
1) create function newcache() returns void AS 'newCache', 'newCache'
language c;
2) create rule newcacherule AS on insert to caches do also select
newcache();
The
Hi Rainer and Christopher,
Thank you for your quick responses. I didn't know about CLUSTER
command. It seems like just what I needed!
Thanks!
--Michi
---(end of broadcast)---
TIP 6: explain analyze is your friend
Does PostgreSQL store records sorted by primary key?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
I have a following table
-+
day | quantity
-+
where day is a date and quantity is an integer value. Now I need to
make a SELECT statement on this table which returns me a full
information on a whole month, it means day='2007-10-01' and day
'2007-11-01' but if there is no
Hello.
I want to use fuction dblink in my queries. But it is not installed on my
postgres server.
I have found that i was able to install this function when installing
postgres on my machine.
I tried to start installation app again but it does not ask me if i want to
install dblink (or other
Hi,
I have a table1 with a tb1_column that stores PHP serialized data that are
unique integers.
| tb1_column |
---
a:5:{i:0;s:1:9;i:1;s:2:5;i:2;s:2:11;i:3;s:2:100;i:4;s:2:10;}
I also have a table2 with unique integers (ids) in tb2_column
| tb2_column | descr |
--
11 | Pears
100 |
Josh,
Thanks for sharing a very good info on partitioning.
On Oct 5, 10:08 pm, [EMAIL PROTECTED] (Josh Tolley) wrote:
On 10/3/07, Goboxe [EMAIL PROTECTED] wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this
am Mon, dem 08.10.2007, um 3:28:04 -0700 mailte marwis1978 folgendes:
I have a following table
-+
day | quantity
-+
where day is a date and quantity is an integer value. Now I need to
make a SELECT statement on this table which returns me a full
information on a
Bima Djaloeis [EMAIL PROTECTED] writes:
I have implemented a stored procedure that writes out the newest DB
entry on insert, and combined it with a rule.
1) create function newcache() returns void AS 'newCache', 'newCache' language
c;
2) create rule newcacherule AS on insert to caches do
I'm having an issue inside a SPI routine that is giving me crashes.
I'm curious if this is a backend problem or something that I am doing
improperly. The following SPI routine dumps core for large, but
reasonable allocations:
/* testing function. just makes bytea a of input len */
Datum
Merlin Moncure [EMAIL PROTECTED] writes:
Am I doing anything wrong here?
Returning an already-pfree'd hunk of memory. I gather you are not
testing your code in an enable-cassert build (tut tut), else you'd
not think this worked for small allocations either. See
I am trying to use postgresql-autodoc. The autodoc finds all the Perl
modules and compiles but when I go to /usr/local/bin and run
postgresql_autodoc like this
postgresql_autodoc -f owl -d owl -u postgres --password=''
I get a message that says
Use of uninitialized value in numeric lt ()
Oh, sorry, I misread your question and didn't realize the distributed
copies would need to make modifications back. AFAIK, the MusicBrainz
system is master/slave, not multi-master.
On Mon, 8 Oct 2007, Laurent ROCHE wrote:
Ben,
As far as I can see MusicBrainz only does one way replication
Hannes Dorbath [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Dave wrote:
What I'm trying to do is to create a foreign key on tb1_column so that if
a
number in tb2_column changes or gets deleted, it cascades to the
appropriate
segment of the serialized data.
e.g. if an id of
Hello.
I run
explain analyze
SELECT id FROM table WHERE name LIKE 'dt%';
having a btree index on name column. But unfortunately it uses seqscan
instead of index scan, it's too slow.
I had read some mailing archives about that problem, but have not found a
solution. How to fix this LIKE
Le lundi 08 octobre 2007, Dmitry Koterov a écrit :
explain analyze
SELECT id FROM table WHERE name LIKE 'dt%';
having a btree index on name column. But unfortunately it uses seqscan
instead of index scan, it's too slow.
It seems to me you'd benefit from reading this page of the fine manual:
-Original Message-
From: Michael Glaesemann [mailto:[EMAIL PROTECTED]
Sent: Friday, October 05, 2007 3:25 PM
To: Bill Bartlett
Cc: 'Andreas Kretschmer'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
humorous X-Message-Flag headers, could we
On Oct 8, 2007, at 8:33 , Dave wrote:
I guess, I can always
set up views with joins, but could not come up with a good way to
query this
in a one returned row, e.g.:
ID | Name | colors | fav_col | kind
| fav_kind | etc.
11 | Apples | red, green, etc. | red |
Dave wrote:
Hannes Dorbath [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Dave wrote:
e.g. if an id of Oranges changes from '5' to '24', the tb1_column rows
will
get changed in the above example row to:
a:5:{i:0;s:1:9;i:1;s:2:24;i:2;s:2:11;i:3;s:2:100;i:4;s:2:10;}
No offense, but
On 10/8/07, Bill Bartlett [EMAIL PROTECTED] wrote:
Most people didn't completely read my email and thus unfortunately
completely missed the point, in many cases seemingly because they were
too quick to jump on my use of Outlook as an email client (thus assuming
I was just one of those
On Oct 8, 2007, at 12:08 PM, Michael Glaesemann wrote:
On Oct 8, 2007, at 8:33 , Dave wrote:
I guess, I can always
set up views with joins, but could not come up with a good way to
query this
in a one returned row, e.g.:
ID | Name | colors | fav_col | kind
| fav_kind
On Mon, 8 Oct 2007, Dmitry Koterov wrote:
Hello.
I run
explain analyze
SELECT id FROM table WHERE name LIKE 'dt%';
having a btree index on name column. But unfortunately it uses seqscan
instead of index scan, it's too slow.
I had read some mailing archives about that problem, but have not
Scott Marlowe [EMAIL PROTECTED] writes:
On 10/8/07, Bill Bartlett [EMAIL PROTECTED] wrote:
(But I'm still not going to post the problem I've been
hitting recently running Postgres 7.4.1 on a SuSE 9.0 box -- somehow I
think the first few responses might be get OFF that version.
[Hopefully
am Mon, dem 08.10.2007, um 13:05:50 -0400 mailte Bill Bartlett folgendes:
(Makes me have to think twice about raising
any _real_ issues though, like why my VACUUMs periodically keep
getting
into lock contentions with my JDBC connections and ultimately
causing me
to have to shut down
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
A. Kretschmer wrote:
am Mon, dem 08.10.2007, um 13:05:50 -0400 mailte Bill Bartlett folgendes:
(Makes me have to think twice about raising
any _real_ issues though, like why my VACUUMs periodically keep
getting
into lock contentions with my JDBC
--- A. Kretschmer [EMAIL PROTECTED] wrote:
at least post them and see what kind of response you get,
rather than judge the list as a whole due to the response you got to
an
off-topic post. Many of the people on the lists have been here for
years and
have gotten lots of helpful
am Mon, dem 08.10.2007, um 12:00:30 -0700 mailte Richard Broersma Jr folgendes:
--- A. Kretschmer [EMAIL PROTECTED] wrote:
at least post them and see what kind of response you get,
rather than judge the list as a whole due to the response you got to
an
off-topic post. Many of
Hi -
A colleague presented the following very slow query to me:
SELECT DISTINCT lemma FROM word
JOIN sense USING (wordid)
JOIN synset USING (synsetid)
WHERE sense.synsetid
IN (SELECT synset2id FROM semlinkref
WHERE synset1id
IN (SELECT synsetid FROM
--- John D. Burger [EMAIL PROTECTED] wrote:
My question is, should the planner have figured this out, and we're
just losing out because we're stuck in 7.4? Or is there some subtle
difference in semantics I'm missing? The select results were the
same in both cases, but I'm willing to
OOPs!
--- Richard Broersma Jr [EMAIL PROTECTED] wrote:
--- John D. Burger [EMAIL PROTECTED] wrote:
My question is, should the planner have figured this out, and we're
just losing out because we're stuck in 7.4? Or is there some subtle
difference in semantics I'm missing? The select
On 10/6/07, Goboxe [EMAIL PROTECTED] wrote:
Josh,
Thanks for sharing a very good info on partitioning.
Don't thank me -- this comes from Robert Treat. I'm just the messenger :)
-Josh/eggyknap
---(end of broadcast)---
TIP 2: Don't 'kill -9' the
A. Kretschmer wrote:
As far i can see your mails are correct. But one exclusion: please no
CC: to the sender, i'm reading the list.
The additional CC: to sender is customary on these lists.
--
Alvaro Herrera http://www.flickr.com/photos/alvherre/
How amazing is that?
On 10/8/07, A. Kretschmer [EMAIL PROTECTED] wrote:
am Mon, dem 08.10.2007, um 12:00:30 -0700 mailte Richard Broersma Jr
folgendes:
--- A. Kretschmer [EMAIL PROTECTED] wrote:
at least post them and see what kind of response you get,
rather than judge the list as a whole due to the
Alvaro Herrera [EMAIL PROTECTED] writes:
A. Kretschmer wrote:
As far i can see your mails are correct. But one exclusion: please no
CC: to the sender, i'm reading the list.
The additional CC: to sender is customary on these lists.
Generally it's just how Internet mailing lists work.
John D. Burger [EMAIL PROTECTED] writes:
... WHERE sense.synsetid
IN (SELECT synset2id FROM semlinkref
WHERE synset1id
IN (SELECT synsetid FROM sense
WHERE wordid = (SELECT wordid FROM word WHERE
lemma='scramble'))
AND linkid=1
Hi, I'm running Postgres 8.2.4 and have installed the CUBE extension.
Using this I had a 10M row table populated with 12-dimensional zero-
volume cubes (i.e., 12D points).
My queries are of the form
select * from ctab where '(x1,x2,x3,...,x12),
(y1,y2,y3,...,y12)'::cube @ cubeField;
So
Guys,
I've got a C-implemented function which performs number
of SPI_exec()'s in a loop, where each of them may fail,
thus I wrapped them into the PG_TRY()/PG_CATCH() inside
the loop. Something like this :
for(i = 0; i query_count; i++) {
PG_TRY();
{
SPI_exec(query[i], 1);
}
Hello,
For upgrade purposes I now have 7.4 and 8.2 on the same Ubuntu box,
and that brings up some questions that I know of, and I'm sure many
that I haven't thought of yet.
I assume that I'll have to put the full path to the version of psql,
etc, corresponding to the same version
I'm not sure, but probably mtree will be better ?
On Mon, 8 Oct 2007, Rajarshi Guha wrote:
Hi, I'm running Postgres 8.2.4 and have installed the CUBE extension. Using
this I had a 10M row table populated with 12-dimensional zero-volume cubes
(i.e., 12D points).
My queries are of the form
On Oct 8, 2007, at 9:15 PM, Oleg Bartunov wrote:
I'm not sure, but probably mtree will be better ?
Thanks - do you have any pointers to this? Google only turns up an
mtree utility that seems to be related to file system operations
On Mon, 2007-10-08 at 17:34 -0700, Ralph Smith wrote:
What is the best way to upgrade? Use pg_dumpall (using 8.2's
program), afterwards redirect that file into v8.2 via psql v8.2?
There are lots of ways to do this. My favorite is to bring a new cluster
on port 5433 and then pipe data
am Mon, dem 08.10.2007, um 15:46:04 -0500 mailte Scott Marlowe folgendes:
Actually CC to the sender is the norm on this list. I believe there
Okay, no problem. I'm knowing other lists like the german debian user
list and there is this CC to the sender unwanted.
Andreas
--
Andreas Kretschmer
44 matches
Mail list logo