Here is a sourceforge version of the same thing
http://openorb.sourceforge.net/
> -Original Message-
> From: Dann Corbit
> Sent: Friday, October 10, 2003 9:38 PM
> To: Christopher Browne; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] 2-phase commit
>
>
> Why not apply the effort to somethi
Why not apply the effort to something already done and compatibly
licensed?
This:
http://dog.intalio.com/ots.html
Appears to be a Berkeley style licensed:
http://dog.intalio.com/license.html
Transaction monitor.
"Overview
The OpenORB Transaction Service is a very scalable transaction monitor
wh
Martha Stewart called it a Good Thing [EMAIL PROTECTED] ("Dann Corbit")wrote:
>> I can't see a grave overhead from this comparison.
>
> 2PC is absolutely essential when you have to have both parts of the
> transaction complete for a logical unit of work. For a project that
> needs it, if you don't
Env: Postgres 7.3.4 on Unix
I have a script to create a new database user and update pg_hba.conf.
I was wondering whether I need to restart server, or simply run pg_ctl
reload.
The question is what happens to all active clients when all backends get the
signal.
I ran such client process which was
> -Original Message-
> From: Satoshi Nagayasu [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 10, 2003 12:26 PM
> To: Andrew Sullivan
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] 2-phase commit
>
> Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> > On Fri, Oct 10, 2003 at 09:46:35AM +09
May have posted this earlier...
It would seem that caching the plans for foreign keys has some unwanted
side effects.
test=# select version();
version
PostgreSQL 7.4beta4 on i386-portbld-fr
Andrew Dunstan wrote:
Bruce Momjian wrote:
This seems to be a bug in gcc-3.3.1. -fstrict-aliasing is enabled by
-O2 or higher optimization in gcc 3.3.1.
According to the C standard, it's illegal to access a data with a
pointer of the wrong type. The only exception is "char *".
This can be used
Robert Treat wrote:
> On Thu, 2003-10-09 at 19:54, Bruce Momjian wrote:
> >
> > I signed up for an account, and it has already been helpful. I wish I
> > had known about this years ago. I will probably put together a little
> > sourceforge project so I can get access to their Solaris and OS X
>
OK, I committed a fix so it will not segfault on root starting it.
---
Christopher Browne wrote:
> In the last exciting episode, [EMAIL PROTECTED] (Markus Bertheau) wrote:
> > Forwarding to -hackers as per README
> >
> > ---
Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> On Fri, Oct 10, 2003 at 09:46:35AM +0900, Tatsuo Ishii wrote:
> > Satoshi, the only guy who made a trial implementation of 2PC for
> > PostgreSQL, has already showed that 2PC is not that slow.
>
> If someone has a fast implementation, so much the bette
Bruce Momjian wrote:
This seems to be a bug in gcc-3.3.1. -fstrict-aliasing is enabled by
-O2 or higher optimization in gcc 3.3.1.
Now that I think of it, they might be talking about an optimization
called register aliasing, where they are taking the structure and
mapping it to a CPU register for
On Thu, Oct 09, 2003 at 11:53:46PM -0400, Christopher Browne wrote:
>
> If 2PC gets implemented, that simply means that there will be another
> module that some will be interested in, and which many people won't
> bother using. Which shouldn't seem to be a particularly big deal.
I think the reas
On Fri, Oct 10, 2003 at 09:46:35AM +0900, Tatsuo Ishii wrote:
> Satoshi, the only guy who made a trial implementation of 2PC for
> PostgreSQL, has already showed that 2PC is not that slow.
If someone has a fast implementation, so much the better. I'm not
opposed to fast implementations!
A
--
Hi all,
I'm importing on Postgres 7.3.4 a dump and after one hour
the process is still there to perform a COPY of a table with about
~1.5M rows.
I did an strace on it and I had a lot of rt_sigprocmask
comparing to read and write operations.
What is going on?
# strace -p 6370
read(33, "\n\0\0\0|-l\
Alvaro Herrera wrote:
> On Thu, Oct 09, 2003 at 11:51:09PM -0400, Bruce Momjian wrote:
> > Alvaro Herrera wrote:
> > > I'm seeing this compile warning on today's CVS tip:
> > >
> > > $ make src/backend/commands/tablecmds.o
> > > gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-declarations -I./src/
Robert Treat writes:
> What's the last beta version that required initdb?
According to this
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/catalog/catversion.h
it was the transition from beta1 to beta2.
--
Peter Eisentraut [EMAIL PROTECTED]
---
Neil Conway wrote:
> On Mon, 2003-10-06 at 16:21, Joshua D. Drake wrote:
> > postgres=# create user with encrypted password '98wq7912a';
> > CREATE USER
> > postgres=# create user with encrypted password '98wq7912a';
> > ERROR: CREATE USER: user name "with" already exists
>
> So, what are we doin
What's the last beta version that required initdb?
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
In the last exciting episode, [EMAIL PROTECTED] (Markus Bertheau) wrote:
> Forwarding to -hackers as per README
>
> -Пересланное сообщение-
>
> From: Markus Bertheau <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: [BUGS] pg_autovacuum segv
> Date: 09 Oct 2003 17:30:48 +0200
>
> (gdb)
On Thu, 2003-10-09 at 19:54, Bruce Momjian wrote:
>
> I signed up for an account, and it has already been helpful. I wish I
> had known about this years ago. I will probably put together a little
> sourceforge project so I can get access to their Solaris and OS X
> machines so I will have even b
On Fri, Oct 10, 2003 at 16:36:56 +0900,
Curt Sampson <[EMAIL PROTECTED]> wrote:
> I just happened to try to compile 7.4beta4 on a two-month-old NetBSD-current
> system, and I get the following:
>
> In file included from timestamp.c:14:
> ../../../../src/interfaces/ecpg/include/datetime.h:7: conf
Andrew,
On Fri, Oct 10, 2003 at 08:56:51AM -0400, Andrew Dunstan wrote:
> Jason Tishler wrote:
> >Are you getting hangs or connection refused errors. The Cygwin
> >PostgreSQL README documents the following issue:
> >[snip]
>
> hangs - I have to kill the psql process to continue.
This could mean
Jason Tishler wrote:
Andrew,
On Fri, Oct 10, 2003 at 12:25:01AM -0400, Andrew Dunstan wrote:
WinXP/cygwin/gcc version 3.3.1 (cygming special)
XP Home or Pro? What version of Cygwin?
XP-HE. I ran a cygwin upgrade last night (to pick up the latest bison
and get cygutils - it picked up gc
Forwarding to -hackers as per README
-Пересланное сообщение-
From: Markus Bertheau <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [BUGS] pg_autovacuum segv
Date: 09 Oct 2003 17:30:48 +0200
(gdb) run
Starting program: /root/src/postgresql-7.4beta4/contrib/pg_autovacuum/pg_autovacuum
Andrew,
On Fri, Oct 10, 2003 at 12:25:01AM -0400, Andrew Dunstan wrote:
> WinXP/cygwin/gcc version 3.3.1 (cygming special)
XP Home or Pro? What version of Cygwin?
> gives these
>
> tablecmds.c:3528: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> [snip]
FWIW,
There's a new version available at
http://www.dunslane.net/~andrew/Initdb_In_C.html - I think it takes care of
all of Peter's comments. I removed initdb-scripts.h - the smaller scripts
were moved into initdb.c with SQL comments turned into C comments, and the
large script to set up system views be
I was wondering whether we need to keep WAL online for 2PC,
or whether only something like clog is sufficient.
What if:
1. phase 1 commit must pass the slave xid that will be used for 2nd phase
(it needs to return some sort of identification anyway)
2. the coordinator m
So it seems I got bitten today by this to-do list item:
Have AFTER triggers execute after the appropriate SQL statement in a
function, not at the end of the function
Under normal circumstances, delaying this stuff until the end of the
function doesn't bother me; in fact I've even used it
I just happened to try to compile 7.4beta4 on a two-month-old NetBSD-current
system, and I get the following:
In file included from timestamp.c:14:
../../../../src/interfaces/ecpg/include/datetime.h:7: conflicting types for `dtime_t'
/usr/include/sys/types.h:186: previous declaration of `dtime_t'
29 matches
Mail list logo
