Hello,
PostgreSQL is going to have a booth at LISA:
http://www.usenix.org/event/lisa08/
http://www.usenix.org/event/lisa08/exhibition.html
Currently we are confirmed for Joshua Drake and Richard Broeserma.
However due to an excessive travel schedule by me, it would be great to
find a few folks
Hello,
We finally got around to releasing Replicator as FOSS. It is BSD
licensed and available here:
https://projects.commandprompt.com/public/replicator/wiki
(Yes it is a self signed cert, its on the list to fix).
Enjoy folks!
Sincerely,
Joshua D. Drake
--
The PostgreSQL Company since
On October 20th 2007 the first annual PostgreSQL Conference: West
commenced. It was a single day, single room event.
On March 29th and 30th the first annual PostgreSQL Conference: East
commenced. It was a two day, three room event which.
On October 10-12th the second annual PostgreSQL
On Fri, 03 Oct 2008 21:02:27 +0200
Jörn Heid [EMAIL PROTECTED] wrote:
So, nobody knows how to make the official Postgres without
Installer to work with a normal Windows installation?
http://www.postgresql.org/docs/faqs.FAQ_MINGW.html
Have fun.
Joshua D. Drake
--
The PostgreSQL Company
On Fri, 3 Oct 2008 15:18:26 -0500
Eduardo Arévalo [EMAIL PROTECTED] wrote:
Hi I am trying to install the portgres of 64btis in centos 5.6 but at
the next command ./postgresql-8.3.4-1-linux-x64.bin
the results are as follows:
We don't distribute .bin files I would strongly suggest using
On Fri, 3 Oct 2008 22:12:08 +0100
Dave Page [EMAIL PROTECTED] wrote:
On Fri, Oct 3, 2008 at 9:31 PM, Joshua Drake [EMAIL PROTECTED]
wrote:
On Fri, 3 Oct 2008 15:18:26 -0500
Eduardo Arévalo [EMAIL PROTECTED] wrote:
Hi I am trying to install the portgres of 64btis in centos 5.6
On Fri, 3 Oct 2008 22:14:22 +0100
Dave Page [EMAIL PROTECTED] wrote:
Yes we do - and simply switching to the RPM distro is unlikely to
solve the problem as the OP is obviously not aware of the what the
problem is and will probably grab the latest version available.
Where do we
On Sat, 4 Oct 2008 00:00:03 +0100
Dave Page [EMAIL PROTECTED] wrote:
On Fri, Oct 3, 2008 at 10:46 PM, Joshua Drake [EMAIL PROTECTED]
wrote:
http://www.postgresql.org/download/linux
No that is a link to another vendors open source software. That is
not a .Org file.
By the same token
The PostgreSQL Conference: West is being held at Portland State
University on October 10th - 12th. The West Coast PostgreSQL
conference is currently seeking more Lightning Talks.
Lightning talks are an exciting way to get involved in the conference
with very little commitment on the speakers end.
On Mon, 29 Sep 2008 19:06:46 -0400 (EDT)
Bruce Momjian [EMAIL PROTECTED] wrote:
I agree with Tom; either we make the pg_start_backup() checkpoint
immediate or leave the behavior unchanged.
Personally I think immediate makes more sense because issuing
pg_start_backup() seems like it should
While recently seeking feedback on the conference schedule from Josh
Berkus and David Fetter I was asked, Are there going to be lightning
talks?. To which I replied, What?.
I know of lightning talks; in a similar manage of how I know of the
existence of competitors to PostgreSQL. They are there
On Tue, 16 Sep 2008 11:54:18 -0500
Roberts, Jon [EMAIL PROTECTED] wrote:
I wasn't kidding up there. Setting view permissions on plpgsql (or
any pl code really) would be understandable. If you're not a super
user or the owner, you need permission to see it.
How can I make that a
On Wed, 10 Sep 2008 23:17:40 +0800
Amber [EMAIL PROTECTED] wrote:
1. Some kind of MPP.
2. No single point of failure.
3. Convenient and multiple access interfaces.
And following the is the solutions we have examined:
http://www.greenplum.com/
Joshua D. Drake
--
The PostgreSQL Company
On Wed, 10 Sep 2008 23:33:44 +0800
Amber [EMAIL PROTECTED] wrote:
Yes, we know both Greenplum and Netezza are PostgreSQL based MPP
solutions, but they are commercial packages. I'd like to know are
there open source ones, and I would suggest the PostgreSQL Team to
start a MPP version of
On Wed, 03 Sep 2008 15:55:17 -0400
William Garrison [EMAIL PROTECTED] wrote:
So I expected scanning the index was faster, and still had everything
it needed to do the count. Or perhaps it was because I said COUNT(*)
so it needs to look at the other columns in the table? I really just
wanted
On Wed, 3 Sep 2008 14:58:45 -0700
Akhtar Yasmin-B05532 [EMAIL PROTECTED] wrote:
Hi,
I am using the following command to start the database:
pg_ctl start -p 5432 -D /home/data/www/pg7/data
Yes I know, 7.2 is a very old version, but that's what we have to work
with for now..
So what
On Wed, 3 Sep 2008 15:19:25 -0700
Akhtar Yasmin-B05532 [EMAIL PROTECTED] wrote:
It says,
pg_ctl: 5432: not found
postmaster successfully started
pg_ctl doesn't take a -p argument for the port. -p is reserved for the
path to the postmaster. Try:
pg_ctl -D /home/data/www/pg7/data start
domain socket /tmp/.s.PGSQL.5432?
-Original Message-
From: Joshua Drake [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 03, 2008 3:25 PM
To: Akhtar Yasmin-B05532
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres does not start, gives no error
On Wed, 3 Sep
On Thu, 28 Aug 2008 16:06:14 -0600
Scott Marlowe [EMAIL PROTECTED] wrote:
On Thu, Aug 28, 2008 at 3:38 PM, Bill [EMAIL PROTECTED] wrote:
I am new to PostgreSQL but it seems to me that lastval() will only
work if the insert does not produce side effects that call
nextval(). Consider the
On Thu, 28 Aug 2008 15:29:51 -0700
Bill [EMAIL PROTECTED] wrote:
The PostgresSQL 8.3 help file clearly shows that lastval() does not
take a sequence as a parameter and the description i is Return the
value most recently returned by |nextval| in the current session.
This function is identical
On Thu, 28 Aug 2008 16:46:19 -0600
Scott Marlowe [EMAIL PROTECTED] wrote:
On Thu, Aug 28, 2008 at 4:18 PM, Joshua Drake [EMAIL PROTECTED]
wrote:
On Thu, 28 Aug 2008 16:06:14 -0600
Scott Marlowe [EMAIL PROTECTED] wrote:
No, setval, currval, and lastval all require as an argument
On Mon, 25 Aug 2008 10:21:54 -0400
John T. Dow [EMAIL PROTECTED] wrote:
By bad data, I mean a character that's not UTF8, such as hex 98.
As far as I can tell, pg_dump is the tool to use. But it has
serious drawbacks.
If you dump in the custom format, the data is compressed (nice) and
On Mon, 25 Aug 2008 13:37:13 -0400
John T. Dow [EMAIL PROTECTED] wrote:
Joshua
The TOC feature sounds good, as does converting a single table to
plain text.
But I can't find documentation for the TOC feature under pg_dump or
pg_restore. I'm looking in postgresql-8.2.1-US.pdf.
The
On Mon, 25 Aug 2008 17:05:53 -0400
John T. Dow [EMAIL PROTECTED] wrote:
Joshua
Thank you very much for answering these various questions.
I guess the compressed format is the best overall solution, except
for roles. I find myself having a table with other information about
users
On Tue, 26 Aug 2008 09:25:09 +0800
Phoenix Kiula [EMAIL PROTECTED] wrote:
Slony. Any simple instructions on installing it and getting it
working?
Why is PG so complex! It's a such a lovely database. If only at least
the installation and upgrade could be made more humane..
Well the
On Thu, 21 Aug 2008 10:16:21 -0700
Alan Hodgson [EMAIL PROTECTED] wrote:
Any hint to track down the problem?
1) Define slow.
2) Tell us what your disk subsystem consists of.
3) Are there any delete triggers on the tables?
And the EXPLAIN ANALYZE
Joshua D. Drake
--
The
On Thu, 21 Aug 2008 12:40:29 +1000
Andrew Maclean [EMAIL PROTECTED] wrote:
I have a large database and I want to have several fields (among many)
that are single character fields (in fact they are bitfields).
1) Is char(1) the most efficient way to store these fields? If not
what is better?
On Fri, 01 Aug 2008 12:41:12 -0700
Alex Vinogradovs [EMAIL PROTECTED] wrote:
Guys,
I was wondering if there is a btree indexing implementation that
is not WAL-logged. I'm loading data in bulks, and index logging
is an unnecessary overhead for me (easier to rebuild on crash).
Drop the index
On Fri, 01 Aug 2008 13:07:18 -0700
Alex Vinogradovs [EMAIL PROTECTED] wrote:
By loading in bulks, I mean I load some 40-50 thousand
rows at once into a table that already has some millions.
Index rebuild on that table after each 50k inserts will
be even less efficient ;)
Fair enough, to
It looks like it took a total of 7:20 for that email to make it to me.In a case of pot calling kettle black ;P, it took your machine 5:58 to
get it to postgresql.org. Of course that's assuming everyone's clock isin sync, and the clock on the machine you sent the email from appears tobe 13 minutes
John Gibson wrote:
Hi, all.
I need to upgrade my dual Xeon PostgreSQL engine.
Assuming similar memory and disk sub-systems, I am considering a Quad
Xeon system vs. a Dual Itanium for PostgreSQL. I believe that the
PostgreSQL code is written for 32 bit and not optimized for the 64 bit
Itanium
Does that leave Red Hat the main (only?) commercial supporter of PostgreSQL?
Heh,
Hardly, there is PGSQL, Inc. and Command Prompt, Inc. (my company). We
have been around for almost four years and have provided custom
development and support for PostgreSQL (starting with Postgres95)
since that
Hello,
This is very unfortunate. I wish all of the Great Bridge employees the best.
Sincerely,
Joshua Drake
Command Prompt, Inc.
Author: a href=http://stage.linuxports.com/projects/practicalpostgresql/book1.htm
Practical PostgreSQL/a
[EMAIL PROTECTED] (Bruce Momjian) wrote in message
news
Open Docs Publishing has announced today that they plan to release their
sixth book entitled "Learning PostgreSQL: The Elephant Never Forgets" by
the first week of June. This title will include PostgreSQL Great Bridge
version 7.1 (The Linux World Editors winner for Best Database in 2000).
34 matches
Mail list logo