Edward,
We have used it for a simple mirroring of transaction data. It has worked like
a champ so far, but the number of tables is low (less than 10) and the
transactions tend to be inserts (common), updates (less so) and deletes rarely,
none of them very frequent. The two servers are quite clo
Hi
I was wondering if anyone is using the dbmirror stuff that come with
postgres versions >7.3.1. If so what kind of experiences have you had.
I am looking a small number < 10 tables that will contain a lot of very
important data and I would like a way to replicate it.
Thanks
Edward
-
On Sun, 2005-03-20 at 22:33 -0500, Christopher Browne wrote:
> After a long battle with technology, [EMAIL PROTECTED] (prakash sompura), an
> earthling, wrote:
> > Can any one tell me how do I replicate my PostgreSql database from
> > one server to another server?
You can use Mammoth Replicator o
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> On Tue, 22 Mar 2005, Ron Mayer wrote:
>> Any reason Fujitsu (http://fastware.com.au/postgresql_support.html) isn't on
>> that list?
> I don't believe they offer support for PostgreSQL per se, do they? They
> have their own "PostgreSQL based" versi
On Tue, 22 Mar 2005, Ron Mayer wrote:
Peter Eisentraut wrote:
Chris Hoover wrote:
Also, are there any other good companies to consider for support?
http://techdocs.postgresql.org/companies.php
Any reason Fujitsu (http://fastware.com.au/postgresql_support.html) isn't on
that list?
I think it adds
Peter Eisentraut wrote:
Chris Hoover wrote:
Also, are there any other good companies to consider for support?
http://techdocs.postgresql.org/companies.php
Any reason Fujitsu (http://fastware.com.au/postgresql_support.html) isn't
on that list?
I think it adds quite a bit of credibility when I tell
Chris Hoover wrote:
> Also, are there any other good companies to consider for support?
http://techdocs.postgresql.org/companies.php
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 8: explain analyze is yo
Does anyone on this list use the PostgreSQL, Inc. support services? I
am doing some preliminary looks into possibly getting "professional"
support for our PostgreSQL databases. Any comments (on or off the list)
would be appreciated.
Also, are there any other good companies to consider for sup
"Chris Hoover" <[EMAIL PROTECTED]> writes:
> The "not in (subselect)" is very slow in postgresql.
It's OK as long as the subselect result is small enough to hash, but
with 550 rows that's not going to happen :-(.
Another issue is that if there are any NULLs in the subselect then you
will prob
Hi Thomas:
Yes, Postgres is running actually and my pg_hba is configured to accept local
UNIX socket connections.
I 've postgres 7.4.5
Ubuntu Warty (4.10)
Eej-
-Mensaje original-
De: Thomas F. O'Connell [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 21 de marzo de 2005 0:25
Para: ESP
WITH: select * from partes where cedula not in (select cedula from sujetos)
Seq Scan on partes (cost=0.00..168063925339.69 rows=953831 width=109)
Filter: (NOT (subplan))
SubPlan
-> Seq Scan on sujetos (cost=0.00..162348.43 rows=5540143 width=15)
WITH: select * from partes where not exists (
PG version = 8.0 over Linux Fedora Core 3
PostgreSQL was compiled from source
Lee Wu wrote:
PG version?
Maybe worth to try NOT EXISTS instead of NOT IN
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sabio - PSQL
Sent: Tuesday, March 22, 2005 7:23 AM
To: Po
PG version?
Maybe worth to try NOT EXISTS instead of NOT IN
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sabio - PSQL
Sent: Tuesday, March 22, 2005 7:23 AM
To: PostgreSQL Admin
Subject: [ADMIN] Too slow
How can I improve speed on my queries. For examp
Sabio - PSQL wrote:
How can I improve speed on my queries. For example this query takes
one day executing itself and it has not finalized !!!
"create table tmp_partes as select * from partes where identificacion
not in (select cedula from sujetos)"
partes have 1888000 rows, an index on identific
=?ISO-8859-1?Q?K=D6PFERL_Robert?= <[EMAIL PROTECTED]> writes:
> restarting postgres on the former data directory lead to the
> situation where all databases exist but with no objects populated. No table
> no function. What can hav happened?
Possibly you managed to reset the transaction counter to
How can I improve speed on my queries. For example this query takes one
day executing itself and it has not finalized !!!
"create table tmp_partes as select * from partes where identificacion
not in (select cedula from sujetos)"
partes have 1888000 rows, an index on identificacion
sujetos have 5
On Tue, 2005-03-22 at 11:41, Jada Case wrote:
> Hello,
>
> I need to know if I add a field to an existing table within a database
> that is currently being accessed by many users, if it will effect it
> or crash it? I have researced the archives and could not find an
> answer, if there is docume
Title: Message
Hello,
I need to know if I
add a field to an existing table within a database that is currently being
accessed by many users, if it will effect it or crash it? I have researced
the archives and could not find an answer, if there is documentation on this,
will you point me i
On Tue, Mar 22, 2005 at 21:52:35 +0530,
Gourish Singbal <[EMAIL PROTECTED]> wrote:
> Can some one give me the details for the below question?.
>
> Whats the limit on the number of elements in the IN clause of
> SELECT/UPDATE/DELETE?.
I believe I have seen reports of people using thousands. How
Can some one give me the details for the below question?.
Whats the limit on the number of elements in the IN clause of
SELECT/UPDATE/DELETE?.
--
Best,
Gourish Singbal
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose
Have you considered trying pg_autovacuum, which is in contrib? It
actually sets and monitors thresholds to try to determine dynamically
when tables need vacuuming.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite
Hi,
I am concerned.
I played around with test database clusters of postgres. I wanted to
simulate a WAL-Replay. So what I did was:
I have a data dir, where some databases exist.
I stressed them to produce a couple of Wal files.
Then I shut down postgres (SIGQUIT *hm*)
created + initdb'ed another
Erase /var/lib/pgsql/data directory and all its subdirectories
Gordon A. Fox wrote:
I just upgraded a machine to Fedora Core 3 and now on startup pgsql gives
me the message "An old version of the database format was found" and
refuses to start.
I'm not entirely sure how to fix this (everything I've
[EMAIL PROTECTED] (Scott Marlowe) writes:
> On Wed, 2005-03-16 at 06:07, Dr. Roger Wießner wrote:
>> Can anyone tell me how to successfully migrate from 7.1.3. to 7.4.7.? I get
>> lots of errors...
>
> Try to have both installed at once (separate dirs, or separate machines)
> and dump the 7.1.3 db
On Mar 22, 2005, at 5:52 AM, sharma;G.S. wrote:
can any body tell me how can i insert a french character in a table of
postgre.
i have made a data base by setting UNICODE encoding.
create table a (b char(255));
I unable to set any french character in the table.
what should i do...
any hel
can any body tell me how can i insert a french
character in a table of postgre.
i have made a data base by setting
UNICODE encoding.
create table a (b char(255));
I unable to set any french character in the
table.
what should i do...
any help will be highly appericiated..
Thanx in Ad
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 21 Mar 2005, Raghunath Ganti wrote:
I am trying to install postgresql-contrib-7.4.1-1PGDG.i386.rpm on top of
Postgresql 7.4.1-1.1
The OS details are :-
Red Hat Linux Release 9 (Kernel 2.4.20-8 on an i686).
[EMAIL PROTECTED] contrib]
27 matches
Mail list logo
