On Tue, 2004-08-10 at 19:30, lec wrote:
Chris Travers wrote:
The first hardware that got replaced was the SCSI controller. After
that there were still hardware hanging and eventually the system
engineers replaced the whole server and they weren't sure what the fault
was. The lost
David Garamond wrote:
Can psql be told to exit immediately after an error (especially when
doing commands from a file, -f)? This is the default behaviour of the
mysql client, except when we give it -f option (force).
\set ON_ERROR_STOP on
Look into the psql man page for additional semantic
Dear Group,
We have a java front-end for postgresql 3.4. When
we monitor the system usage using top we find couple of postmasters
taking up close to 90% of the CPU time in total. I would like to know
which are the queries that are currently running at this point of time.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
has anyone encountered an error when running a slony_setup.pl generated script
to set up a master?
The problem I hit is that the xxid.v73.sql file aborts with the following
error:
Aug 10 20:57:57 ibserver postgres[9749]: [12] ERROR:
TL == Tom Lane [EMAIL PROTECTED] writes:
serious testing; very large databases and lots of
traffic.
Note that Afilias paid for the development of Slony-I;
TL ... because they were quite unhappy with erServer ...
The major point Jan brings up when you talk about this is that
eRServer
(gdb) bt
#0 0x284f9dcf in kill () from /lib/libc.so.5
#1 0x284ee878 in raise () from /lib/libc.so.5
#2 0x28566f82 in abort () from /lib/libc.so.5
#3 0x08226a6a in errfinish ()
#4 0x08226953 in errfinish ()
#5 0x0822f54d in GetUserNameFromId ()
#6 0x081183a3 in
Chris Ochs [EMAIL PROTECTED] writes:
I think that we're trying to report the current session authorization to
the client (which is something that happens automatically on any change)
and it's referencing a deleted user. Is it possible that your setup is
deleting the user that the entire
--- Tom Lane [EMAIL PROTECTED] wrote:
Jeff Eckermann [EMAIL PROTECTED] writes:
That probably won't impress your bosses. If you
need
a track record, then erServer might be what you
need.
erServer is a commercially produced product that
was
(is still?) used by Afilias, the provider of
Liam Lesboch wrote:
Thes slashdots post today about the beta releases of 8.0 caught the
attention of my boss and I. Many comments about the replicator issue
and saw many posts about Slony-I in particular. Maybe this is the
only viable option in PostgreSQL? There are others that cost money
but
Granted...
Liam's bosses want something with a history of
successful use in a serious production situation, and
erServer at least has that. Slony has been around for
too short a time to make that claim, yet.
There is also Mammoth Replicator which is an integrated replication
approach that does
Hi all,
I should have explained it better:
Why don't I just insert each line in the table and let copy to do its
thing inserting a new line char (lf) at the end of each line?
Because I need the file lines to be in a certain order. Copy to will
copy the lines in its own order.
Until now I'm
From: Joshua D. Drake [EMAIL PROTECTED]
To: Jeff Eckermann [EMAIL PROTECTED]
CC: Tom Lane [EMAIL PROTECTED],Liam Lesboch [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: [GENERAL] Replication options?
Date: Wed, 11 Aug 2004 13:38:54 -0700
Granted...
Liam's bosses want something with a history
From: Peter Eisentraut [EMAIL PROTECTED]
To: Liam Lesboch [EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: Re: [GENERAL] Replication options?
Date: Wed, 11 Aug 2004 21:54:28 +0200
Liam Lesboch wrote:
Thes slashdots post today about the beta releases of 8.0 caught the
attention of my boss and I.
We're trying to figure out how we can implement a reasonably simple cluster
of postgres servers on a private network at our store locations. The idea
is to have a group of 2-6 PCs each be able to share data in a replicated
manner. Having a separate database server is not an option due to the
From: Jeff Eckermann [EMAIL PROTECTED]
To: Tom Lane [EMAIL PROTECTED]
CC: Liam Lesboch [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [GENERAL] Replication options? Date: Wed, 11 Aug 2004 12:38:34
-0700 (PDT)
--- Tom Lane [EMAIL PROTECTED] wrote:
Jeff Eckermann [EMAIL PROTECTED] writes:
On Wed, 11 Aug 2004, [iso-8859-1] Clodoaldo Pinto Neto wrote:
I should have explained it better:
Why don't I just insert each line in the table and let copy to do its
thing inserting a new line char (lf) at the end of each line?
Because I need the file lines to be in a certain order. Copy
Christian Traber [EMAIL PROTECTED] writes:
Maybe its only win32 version?
Well, I can't reproduce it on Unix. It seems awfully odd though that
you can create tables in that tablespace to begin with but can't move
them there. I'm cc'ing this to the pgsql-hackers-win32 to see if anyone
there has
On 11 Aug 2004 13:51:49 -0400 Robert Treat [EMAIL PROTECTED] wrote:
On the upside, you have already been given pg-replicator as a starting
point, all you need to do is being it up to speed.
i have to rewrite it in a different language. it depends on tcl-dp, an unsupported
(and reportedly
Here's my issue:
Data comes in and is inserted into the database automatically, into a base
table A. Later a human looks at the records, fills in some data, and now the
records are assigned to some derived table, B or C. In some cases there is
no way for the software to know at import time which
On Wed, Aug 11, 2004 at 09:57:58PM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
I'm thinking I should only put the latest, greatest on the bt
server, but if others think otherwise, I'd be happy to put up
more.
The 8.0 beta and the latest stable (7.4.3, soon 7.4.4) would
Been playing with the 8.0 beta of Postgres. It seems really nice. One
new thing I noticed is 'psql' displays RULE definitions in the \d
viewname output. This is nice compared to 7.3.x's inability to see
RULE definitions at all.
However, this makes the output of \d completely useless. Maybe
Scott Ribe [EMAIL PROTECTED] writes:
1) Is there any way to change a row of table A into one of the inherited
types, other than deleting and inserting?
Nope.
2) If I must delete insert, is there any shortcut to somehow say rec2.A =
rec1 rather than referencing the columns of the base table
Can't you do something like
INSERT INTO B SELECT *, some-more-values FROM A WHERE ...
Yes, that works. I didn't think of trying that because I also need to check
for existence of A and change some values in it if it exists, so I select it
into a record type, and
insert into B docrec.*,
On Aug 11, 2004, at 12:02 PM, Tom Lane wrote:
Jeff Eckermann [EMAIL PROTECTED] writes:
That probably won't impress your bosses. If you need
a track record, then erServer might be what you need.
erServer is a commercially produced product that was
(is still?) used by Afilias, the provider of
Dear Richard,
Thankyou for you immediate reply, I did set
the stats_command_string=true and tried select * from pg_stat_activity;
It gave me the desired result. In the mean while you had mentioned
about reading the monitoring activity chapter. Please tell me where I
Dear Jan Poslusny,
Thank you for you immediate reply, in
regards to the shared_buffers, what is the optimum value and how do I
calculate it. Thanking you,
Yours sincerely,
Shan.
Jan Poslusny wrote:
Hi Shan,
please, check your postgresql.conf and find
Are there known issues and how do I get around installing the PostGreSQL
7.4.3 binaries on RH 8?
I tried installing it and it needed dependencies. So I got the
dependencies, which included OpenSSL, but it wouldn't let me update
OpenSSL because the current version is needed for other programs.
It
27 matches
Mail list logo