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 semanti
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: parser:
> "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
>
> > (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
"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 e
--- 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,
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
>
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 n
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 in
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
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 an
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
imme
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]>
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.
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 ha
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 fla
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 d
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.
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
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 my rule
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
> 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 regi
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
co
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 "shared_buffe
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
26 matches
Mail list logo
