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 199
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 Conference:
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 ve
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
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:
>
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 us
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 Compa
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
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.
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 ther
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 ma
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 o
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
Is the server running locally and accepting
> connections on Unix 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
>
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 sta
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
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
> w
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:
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 iden
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(). Cons
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
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
> user
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.
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 (nic
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
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
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
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 f
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: http://stage.linuxports.com/projects/practicalpostgresql/book1.htm>
Practical PostgreSQL
[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).
Thi
34 matches
Mail list logo
