This has certainly been discussed before.
IIRC the real argument against that was, that fork() isn't the most
expensive thing to do anymore. And Postgres does lots of other stuff
after accept(), namely connecting to a certain database,
authenticating the user, etc..
Ok. I knew that. I made
Zenaan Harkness wrote:
Hi, a friend of mine on Windows, is attempting to convert to using
PostgreSQL (and of course, I'm helping him).
The installation gave an option to run as an application, rather than as
a service.
Turns out, my friends login account has Admin privs, and postgres.exe
will
Paul Mendoza wrote:
Here is a problem I'm having with a function I've created. It should be
returning a varchar value no matter what the input is but I'm getting a null
value back. Then it says in the error that I'm using nonstandard use of
escape in a string literal at character 9. What do you
--- Original Message ---
From: Zenaan Harkness [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: 08/09/07, 06:03:54
Subject: [GENERAL] replacing Access/ Approach etc
Is there a way to achieve this, on windows?
Yes, 8.2 will start under a admin
account just fine.
Is
Zenaan Harkness wrote on 08.09.2007 07:03:
Hi, a friend of mine on Windows, is attempting to convert to using
PostgreSQL (and of course, I'm helping him).
The installation gave an option to run as an application, rather than as
a service.
Turns out, my friends login account has Admin privs,
On Sat, Sep 08, 2007 at 08:26:04AM +0100, Richard Huxton wrote:
Zenaan Harkness wrote:
Hi, a friend of mine on Windows, is attempting to convert to using
PostgreSQL (and of course, I'm helping him).
The installation gave an option to run as an application, rather than as
a service.
Turns
On Sat, Sep 08, 2007 at 08:49:28AM +0100, Dave Page wrote:
From: Zenaan Harkness [EMAIL PROTECTED]
Is there a way to achieve this, on windows?
On Sat, Sep 08, 2007 at 09:52:04AM +0200, Thomas Kellerer wrote:
Zenaan Harkness wrote on 08.09.2007 07:03:
Hi, a friend of mine on Windows, is attempting to convert to using
PostgreSQL (and of course, I'm helping him).
The installation gave an option to run as an application, rather than as
Hello,
I am looking for a tool which is able to generate a database diagramm
including the relationships from an existing database schema. The only
tool I know for this purpose is the Clay database plugin for eclipse.
Are there any other tools which can help me?
Best regards,
Thorsten
am Sat, dem 08.09.2007, um 11:44:17 +0200 mailte Thorsten Kraus folgendes:
Hello,
I am looking for a tool which is able to generate a database diagramm
including the relationships from an existing database schema. The only
tool I know for this purpose is the Clay database plugin for
2007/9/8, Denis Gasparin [EMAIL PROTECTED]:
This has certainly been discussed before.
IIRC the real argument against that was, that fork() isn't the most
expensive thing to do anymore. And Postgres does lots of other stuff
after accept(), namely connecting to a certain database,
On 9/8/07, Thorsten Kraus [EMAIL PROTECTED] wrote:
Hello,
I am looking for a tool which is able to generate a database diagramm
including the relationships from an existing database schema. The only
tool I know for this purpose is the Clay database plugin for eclipse.
Are there any other
On 9/8/07, Zenaan Harkness [EMAIL PROTECTED] wrote:
A lack of a sense of control is simply one more barrier to potential
switchers. Make sense?
But by starting postgresql under an administrative account, the user
would, in effect, be giving up that control to PostgreSQL to simply do
as it
On Sat, Sep 08, 2007 at 09:45:21AM -0500, Scott Marlowe wrote:
On 9/8/07, Zenaan Harkness [EMAIL PROTECTED] wrote:
A lack of a sense of control is simply one more barrier to potential
switchers. Make sense?
But by starting postgresql under an administrative account, the user
would, in
On 9/7/07, Max Zorloff [EMAIL PROTECTED] wrote:
On Fri, 07 Sep 2007 10:58:36 +0400, Marko Kreen [EMAIL PROTECTED] wrote:
The pgpool (I tried 3.1, 3.4 and pgpool-II 1.2) works fine but has the
following problem - after some time it
just hangs, and if I try to connect to it with psql it just
What happens when a database needs to scale beyond a single server? Is this
something PostgreSQL can do?
Further, does a database need to be designed differently if it's going to be
used on more than one server? I know there are many issues that might effect
a database's ability to scale; but
On 9/8/07, novnov [EMAIL PROTECTED] wrote:
What happens when a database needs to scale beyond a single server? Is this
something PostgreSQL can do?
Further, does a database need to be designed differently if it's going to be
used on more than one server? I know there are many issues that
Yes, I realize that scaling must be a large and complicated topic. And that
PostgresSQL is not as scaleable as Oracle etc.
I know after reading your post that Postgres cannot match RAC. I'm still not
sure if Postgres can operate a database from more than one box, at all. If
it can, how? I mean
I suppose you could set up a batch file to start Postgresql, create a short-cut
to pg_ctl and then modify the properties of the shortcut to run as under
different credentials (or use runas with a batch file). That'll require that
your friend enter the password for that account every time he
On 9/8/07, novnov [EMAIL PROTECTED] wrote:
Yes, I realize that scaling must be a large and complicated topic. And that
PostgresSQL is not as scaleable as Oracle etc.
Depends on how we're defining scalability. :)
I didn't explicitly say that RAC will outscale postgresql. It's just
one
On 9/8/07, Zenaan Harkness [EMAIL PROTECTED] wrote:
On Sat, Sep 08, 2007 at 09:45:21AM -0500, Scott Marlowe wrote:
On 9/8/07, Zenaan Harkness [EMAIL PROTECTED] wrote:
A lack of a sense of control is simply one more barrier to potential
switchers. Make sense?
But by starting postgresql
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Given past history of this project and its relation to
Stonebraker, I was tempted earlier today to suggest that
the Postgres vs. PostgreSQL renaming argument be dropped
in favor of renaming the database Horizontica.
That name could be
Scott Marlowe [EMAIL PROTECTED] writes:
On 9/8/07, Zenaan Harkness [EMAIL PROTECTED] wrote:
In the meantimem, is there any option to allow pg to run in a privileged
account on windows?
Your friend has the following choices in the matter. He can stop
running as an administrator and then run
On 9/7/07, Greg Smith [EMAIL PROTECTED] wrote:
... renaming the database Horizontica.
Following the naming convention, wouldn't it be Horizonta?
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
On 9/8/07, Tom Lane [EMAIL PROTECTED] wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
On 9/8/07, Zenaan Harkness [EMAIL PROTECTED] wrote:
In the meantimem, is there any option to allow pg to run in a privileged
account on windows?
Your friend has the following choices in the matter. He
On 9/8/07, Greg Sabino Mullane [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Given past history of this project and its relation to
Stonebraker, I was tempted earlier today to suggest that
the Postgres vs. PostgreSQL renaming argument be dropped
in favor
Yes the trx would be akin to banking operations.
This is good: Can you partition your data to multiple servers? That's kind
of my question! g I've not dealt with RAC, data partitioning, any of those
topics; just haven't had exposure. But since you're asking me if the data
can be partitioned to
On 9/8/07, novnov [EMAIL PROTECTED] wrote:
Yes the trx would be akin to banking operations.
This is good: Can you partition your data to multiple servers? That's kind
of my question! g I've not dealt with RAC, data partitioning, any of those
topics; just haven't had exposure. But since
I have a trigger function that I want to apply to several tables, hence
my use of TG_RELNAME. I just want the record to get inserted if an
UPDATE comes from my view rule if the record for the client doesn't
already exist. This is what I have, but I'm finding the FOUND is not
returned for EXECUTE.
You're right, that's not how I understood your partitioning question. I'd not
be eager to implement that kind of split in the db, though I can see that
it's an example of how to spread the load around.
But basically, it seems that the answer to one of my questions is that there
is currently no
On 07/09/2007, Filip Rembiałkowski [EMAIL PROTECTED] wrote:
2007/9/5, Raj A [EMAIL PROTECTED]:
correction:
The result I'm expecting for the above to be
notification_time| finished_time | actual
++-
On 9/8/07, novnov [EMAIL PROTECTED] wrote:
But basically, it seems that the answer to one of my questions is that there
is currently no way with postgres to spread a single database over multiple
servers, ala a loadbalanced apache cluster, where requests are forwarded to
different boxes.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/08/07 19:58, novnov wrote:
You're right, that's not how I understood your partitioning question. I'd not
be eager to implement that kind of split in the db, though I can see that
it's an example of how to spread the load around.
But
Is there a way to pass a query to PostgreSQL to check if the
TSeasrch2 search text is valid? For example,
SELECT to_tsquery('default', '!');
returns an error. I want to know if there is a way get true/false
for the '!' portion of the query?
Benjamin
---(end of
There are two useful functions - numnode() and querytree()
More details in http://www.sai.msu.su/~megera/postgres/fts/doc/fts-query.html
Oleg
On Sat, 8 Sep 2007, Benjamin Arai wrote:
Is there a way to pass a query to PostgreSQL to check if the TSeasrch2 search
text is valid? For example,
35 matches
Mail list logo