Hi,
With the bump of the major version number of the
libraries in 8.0.2 it would be nice to have the
rpm packages named so as to allow both the
pg 7 and pg 8 versions of the libraries installed.
Appended is a patch that does this to the rhel-es-3.0
specfile. It changes the name of the rpm
postgres
Tom Lane wrote:
> Brandon Craig Rhodes <[EMAIL PROTECTED]> writes:
> > And the disputed point:
>
> > - If the drive holding the WAL fails, then the database engine
> > will shut down cleanly by writing everything in RAM out to
> > the real database tables, and no
the number one aim at the moment is to have "always-up-to-date" copy
of our main DB with minial performance impact on replication (as I
guess, single master - slave setup will work the best in this case).
Eventually I it's likely that we'll want to unload the database server
by splitting requests b
On Wed, 4 May 2005 20:49:59 -0400 Vlad <[EMAIL PROTECTED]> wrote:
> Hello,
> in need to increase reliability of the service (and perhaps eventually
> offload main DB server) we are looking to setup replication for the
> database server. I found two solutions:
> Slony ( http://gborg.postgresql.or
A few additional caveats about trying to support both PostgreSQL and
Firebird:
1) I was unable to find a large text field type (equivalent to
varchar() or TEXT) in Firebird. All Varchar fields require a length
specifyer.
2) I found stored procedures to be a serious pain in Firebird.
3) Post
Hello,
in need to increase reliability of the service (and perhaps eventually
offload main DB server) we are looking to setup replication for the
database server. I found two solutions:
Slony ( http://gborg.postgresql.org/project/slony1/projdisplay.php )
PGCluster ( http://pgfoundry.org/projects/
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Ragnar Hafstað wrote:
>> On Wed, 2005-05-04 at 09:01 -0700, Jeff Eckermann wrote:
>>> If I understand right, oids are globally
>>> unique within your database.
>>
>> I am affraid not
> oids are globally unique within the catalog.
... until the OID
Ragnar Hafstað wrote:
On Wed, 2005-05-04 at 09:01 -0700, Jeff Eckermann wrote:
If I understand right, oids are globally
unique within your database.
I am affraid not
oids are globally unique within the catalog.
gnari
---(end of broadcast)---
TIP 4
On Wed, 2005-05-04 at 09:01 -0700, Jeff Eckermann wrote:
> If I understand right, oids are globally
> unique within your database.
I am affraid not
gnari
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
When accessing Postgres boolean fields (in the TD
dictionaries) in plpythonu, their values are '0' or
'1'. IIRC, in PHP their values would be 't' or 'f'.
How are boolean values actually stored in Postgres?
CSN
Discover Yahoo!
Stay in touch with email, IM, photo sharing and more
Aaron Steele wrote:
i'm having the same problem running pg8.0.1 on redhat enterprise linux
AS 3 (2.4.21-27.0.4.ELsmp).
shutting off my firewall via 'service iptables stop' solves the
problem... what needs to be modified in the iptables to allow remote pg
connections?
You will need to open port
Hi,
We have a big project here that we originaly did in Firebird 1.0, it worked
well, though was missing tons
of features like built in functions, temp tables etc etc. We then updated to
Firebird 1.5 and again it worked good.
We always had issues with the stupid Firbird OAT (oldest active transa
I was just curious about the following scenario:
- Unix user has their own tablespace (and corresponding database)
stored in /home/someuser/mydata
- Quotas are enabled on /home
- /home runs out of disk space
What happens to the user's tablespace? How does postgres handle this scenario?
-
i'm having the same problem running pg8.0.1 on redhat enterprise linux
AS 3 (2.4.21-27.0.4.ELsmp).
shutting off my firewall via 'service iptables stop' solves the
problem... what needs to be modified in the iptables to allow remote pg
connections?
Richard Huxton wrote:
Michael Korotun wrote:
H
Hello. Thanks for answers...
After considering all proposed, I think that it is probably possible to give
MS Acces some composite primary keys while linking views as tables, in order
to help Access not to fall into "#deleted#", but it would take some extra
time to experiment with every view.
In
On Wed, May 04, 2005 at 11:48:44AM -0700, Benjamin Smith wrote:
>
> As a long-time user of Postgres, (First started using it at 7.0) I'm reading
> recently that Firebird has been taking off as a database.
>
> Perhaps this is not the best place to ask this, but is there any compelling
> advanta
An observation: the one recent study that pumped up Firebird seemed to come
out of nowhere, and its findings have yet to be corroborated elsewhere. While
as others have noted, Firebird is a fine product (and has a longer history on
the Windows platform), I think a little skepticism as to its m
LOL! (thanks)
Redfaced, and going back to check compiler flags,
-- Ross
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 3:42 PM
To: Mohan, Ross
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres vs Firebird?
Mohan, Ro
Mohan, Ross wrote:
while we're on "scalability", any thoughts on needs/plans for 64-bit PG?
You mean beyond the fact that we have supported 64-bit for a couple of
years?
Sincerely,
Joshua D. Drake
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ma
while we're on "scalability", any thoughts on needs/plans for 64-bit PG?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe
Sent: Wednesday, May 04, 2005 3:19 PM
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pos
On Wed, 2005-05-04 at 13:48, Benjamin Smith wrote:
> As a long-time user of Postgres, (First started using it at 7.0) I'm reading
> recently that Firebird has been taking off as a database.
>
> Perhaps this is not the best place to ask this, but is there any compelling
> advantage to using Fire
Benjamin Smith wrote:
As a long-time user of Postgres, (First started using it at 7.0) I'm reading
recently that Firebird has been taking off as a database.
Perhaps this is not the best place to ask this, but is there any compelling
advantage to using Firebird over Postgres?
Firebird is a nic
Why not try both, by configuring a database and running your
applications against both systems? Kick the plug out of the wall during
the middle of a transaction. Run a simulated load of 10,000 users
against it. If you are growing exponentially, it will be much cheaper
to do your experiments now
As a long-time user of Postgres, (First started using it at 7.0) I'm reading
recently that Firebird has been taking off as a database.
Perhaps this is not the best place to ask this, but is there any compelling
advantage to using Firebird over Postgres? We have a large database (almost
100 tab
On Wed, May 04, 2005 at 18:24:53 +0200,
Hervé Piedvache <[EMAIL PROTECTED]> wrote:
>
> Why I get 26927405 nonremovable row versions in 185707 pages ?
> How to remove them ? I need to free the space quickly !
Those rows will still be visible to transactions that started before
the delete was com
On Wed, May 04, 2005 at 11:47:12 -0400,
Greg Stark <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III <[EMAIL PROTECTED]> writes:
>
> > > How do I create sequence ?
> >
> > You can't create a sequence for a view. You would need to have it in a
> > table that is joined as part of the view.
>
> Sure y
Hi,
I have a strange problem ...
Look at what I have done ...
# select count(*) from domains_ranks;
count
26927405
(1 row)
# DELETE from domains_ranks where date_rank < now() - '3 days'::interval;
DELETE 26232918
# select count(*) from domains_ranks;
count
694487
(1 row)
#
--- Zlatko Matic <[EMAIL PROTECTED]> wrote:
> I asked this question several weeks ago, but nobody
> proposed a solution, so
> I am repeating the same question again...
> I have an MS Access front-end for a database on
> PostgreSQL.
> I could use pass-through queries as record sources
> for reports
Hello!
create or replace function trigger_keywords_maintain() returns trigger as $$
return 'MODIFY'
$$ language plpythonu;
update table set id = id where id = 7
ERROR: invalid input syntax for type timestamp: "2005-05-03
14:07:33,279213"
I see that Python's timestamp format is no
Devrim GUNDUZ wrote:
rpmbuild --rebuild --target i686 ...src.rpm
will work.
src rpm link below
ftp://ftp.us.postgresql.org/pub/mirrors/postgresql/binary/v8.0.2/linux/srpms/fedora/fedora-core-3/postgresql-8.0.2-1PGDG.src.rpm
---(end of broadcast)---
TI
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> > How do I create sequence ?
>
> You can't create a sequence for a view. You would need to have it in a
> table that is joined as part of the view.
Sure you can. You can have any expression you want, including nextval('seq')
in your view. The problem
On Tue, 2005-05-03 at 23:21, Lipy Reis wrote:
> Hello everyone,
>
> Anyone can help me find out RPM packs for Postgre 8.0 , i need it for
> Linux "i586"
>
> I just find RPMs for version i686 :(
>
> Anybody more luck than me?
>
Can you find them for i386? That's usually the other class mo
Am 2005-05-04 13:55:35, schrieb Hegyvari Krisztian:
> Didi you notice rekall<>recall? :-) :-) What is the correct name anyway?
The correct name is "rekall" and I have found it,
but it is in Debian EXPERIMENTAL.
Maybe it works for SARGE and SID.
Greetings
Michelle
--
Linux-User #280138 with the
On Wed, May 04, 2005 at 10:56:25 +0200,
Zlatko Matic <[EMAIL PROTECTED]> wrote:
> I will try...if it will be useless, I will quite. Then the only solution
> will be make-table query based on nested pass-through query, so I will be
> working on local JET tables that will be refreshed from server
On May 4, 2005, at 20:50, Randal L. Schwartz wrote:
Well, yes. I was (falsely?) recalling that there was a pure SQL way
to do this though.
Here's a pure SQL method. There might be more performant ways of
rewriting the query, but this should do what you want.
test=# create table persons (
per
Didi you notice rekall<>recall? :-) :-) What is the correct name anyway?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michelle
Konzack
Sent: Wednesday, May 04, 2005 1:08 PM
To: pgsql-general
Cc: debian-devel
Subject: Re: [GENERAL] Rekall for Debian ?
A
> "Harald" == Harald Fuchs <[EMAIL PROTECTED]> writes:
Harald> Using a temporary sequence for that would avoid naming conflicts.
>> P.S. I'm sure you can wrap it in plperl stored procedure :)
Well, yes. I was (falsely?) recalling that there was a pure SQL way
to do this though.
And the poi
Michael Korotun wrote:
Hi Guys,
I can't get working remote tcp connections on default port 5432.
Environment is as follows
OS: Fedora Core 3
DB: Postgresql 8.0.1
1) The listen_addresses is set to '*' in postgresql.conf
2) pg_hba.conf is edited with client host ip, (the one which tries to
eastabli
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Well, if you don't need the ranks to be sequential, merely ordered:
CREATE TABLE ranker (id INT, age INT);
...
SELECT b.w-a.age AS rank, a.id, a.age
FROM (SELECT * FROM ranker ORDER BY age DESC, id) AS a,
(SELECT max(age)+1 AS w FROM ranker) as b;
In article <[EMAIL PROTECTED]>,
Lyubomir Petrov <[EMAIL PROTECTED]> writes:
> create sequence seq_tmp;
> select nextval('seq_tmp') as rank, a.id, a.name from (select id, name
> from t order by name desc) a;
> drop sequence seq_tmp;
Using a temporary sequence for that would avoid naming conflicts.
Am 2005-05-04 13:31:48, schrieb Devrim GUNDUZ:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> Hi,
>
> On Wed, 4 May 2005, Michelle Konzack wrote:
>
> >does anyone know, whether there is a
> >Debian Package for Rekall or not ?
>
> There seems so:
>
> $ apt-cache search rekall
> rekall
>> Zlatko Matic wrote:
>>
>>> I asked this question several weeks ago, but nobody proposed a
>>> solution, so I am repeating the same question again...
>>> I have an MS Access front-end for a database on PostgreSQL.
>>> I could use pass-through queries as record sources for reports and it
>>> works
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 4 May 2005, Michelle Konzack wrote:
does anyone know, whether there is a
Debian Package for Rekall or not ?
There seems so:
$ apt-cache search rekall
rekall - graphical database front-end
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org, devri
Hello all,
does anyone know, whether there is a
Debian Package for Rekall or not ?
Thanks and nice afternoon
Michelle
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM
Hi,
On Wed, 4 May 2005, Devrim GUNDUZ wrote:
Why don't use rebuild RPMs from SRPMs?
would be
" Why don't rebuild RPMs from SRPMs?"
rpmbuild --rebuild --target i686 ...src.rpm
will work.
--
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com.tr
Hi,
On Wed, 4 May 2005, Lipy Reis wrote:
Anyone can help me find out RPM packs for Postgre 8.0 , i need it for Linux
"i586"
I just find RPMs for version i686 :(
Anybody more luck than me?
Why don't use rebuild RPMs from SRPMs?
--
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gundu
Hi Guys,
I can't get working remote tcp connections on default port 5432.
Environment is as follows
OS: Fedora Core 3
DB: Postgresql 8.0.1
1) The listen_addresses is set to '*' in postgresql.conf
2) pg_hba.conf is edited with client host ip, (the one which tries to
eastablish connection)
Wor
I will try...if it will be useless, I will quite. Then the only solution
will be make-table query based on nested pass-through query, so I will be
working on local JET tables that will be refreshed from server on each
session. But I would like to avoid local tables, if possible...
How do I crea
You mean VB.NET ?
- Original Message -
From: "Keith Worthington" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc: ; <[EMAIL PROTECTED]>
Sent: Wednesday, May 04, 2005 5:58 AM
Subject: Re: [INTERFACES] calculated identity field in views, again...
Zlatko Matic wrote:
I asked t
I read the reason for the 5 out of 10 as "little win32 post-install
specific documentation", which is quite true, and few google hits on
"postgresql getting started" (which is kind of true - 600k vs 2.5M for
mysql vs 2.6M for oracle. But it can be debated wether 600,000 pages
should actually be enu
On Tue, 3 May 2005, Dann Corbit wrote:
http://www.cs.cmu.edu/~harchol/Papers/actual-icde-submission.pdf
thanks, interesting analysis. I've seen many papers where PostgreSQL
was used as a research database and wondering why we have no code
submission from their projects. For example, materialized vi
51 matches
Mail list logo
