On 20.09.2007 04:34, Charles.Hou wrote:
> i have installed the pgpool in the server and start it. but how can i
> know it's working? i means that the clients connected to the database
> by the pgpool.
Well, read the documentation, configure pgpool to listen on 5432 - or
whatever your PG instance
On 20/09/2007, Chester <[EMAIL PROTECTED]> wrote:
> Hi
>
> I have a question regarding foreign keys, I just cannot get it to create
> them for meI must be doing something wrong but I have no idea what
> that might be :)
>
> I have a table "clients"
>
> clientID (primary)
> ticode
> Firstname
>
Benjamin Smith wrote:
> But I am stumped as to how to create a client certificate
> that's enforced!
>
> I tried the instructions found
> http://marc.info/?l=tomcat-user&m=106293430225790&w=2
>
> and used the "ca.pem" created there as the postgres root.crt
> and although the PG daemon no long
On Thursday 20 September 2007 05:15:39 Albe Laurenz wrote:
>
> What does pg_hba.conf look like?
I don't know if I misunderstood him, but I thought he was willing to have SSL
on both sides, i.e., both the client and the server identify themselves
trough SSL certificates.
Even though one can requ
Jorge Godoy wrote:
>> What does pg_hba.conf look like?
>
> I don't know if I misunderstood him, but I thought he was
> willing to have SSL on both sides, i.e., both the client
> and the server identify themselves trough SSL certificates.
I had the same impression.
> Even though one can require c
On Wed, 2007-09-19 at 08:40 -0500, Ron Johnson wrote:
> > Yes, I think that it's a bit excessive but the company can afford it so why
> > not... :)
>
> Lucky SOB.
>
> I can't get my company to spring for a dual-core 2GB system with
> SATA drives.
>
hehe.. I'll end up running it on a low-end de
Anyone? I know this is a low-end server so have to make the best out of
it..
On Tue, 2007-09-18 at 16:06 +0800, Ow Mun Heng wrote:
> Final specs for the server is just an ordinary desktop fitted w/ 3
> 7200rpm 500GB drives & 1 7200 80GB drive / 1 GB ram / 2G processor
> (single core)
>
> number o
Felipe
--- Felipe de Jesús Molina Bravo
<[EMAIL PROTECTED]> escribió:
> Hi
>
> You are rigth, the output of "show lc_ctype;" is C.
>
> Then I did is:
>
> prueba1=# show lc_ctype;
> lc_ctype
> -
> es_MX.ISO8859-1
> (1 row)
>
> and do it
>
> % initdb -D /YOUR/PATH -
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/20/07 05:43, Ow Mun Heng wrote:
> On Wed, 2007-09-19 at 08:40 -0500, Ron Johnson wrote:
>>> Yes, I think that it's a bit excessive but the company can afford it so why
>>> not... :)
>> Lucky SOB.
>>
>> I can't get my company to spring for a dual
"Albe Laurenz" <[EMAIL PROTECTED]> writes:
> Jorge Godoy wrote:
>> Even though one can require connections using only SSL on the
>> server side, I don't see a method (in pg_hba.conf) that
>> would allow clients with SSL certificates.
> Nor do I.
If you mean *require* clients to have certificates,
Glad to hear that
I knew Novell *was* working on a port to BSD
But I havent heard about ports to other Nix platforms?
M--
- Original Message -
From: "Bill Bartlett" <[EMAIL PROTECTED]>
To: "'Martin Gainty'" <[EMAIL PROTECTED]>; "'johnf'" <[EMAIL PROTECTED]>;
Sent: Wednesday, Septembe
I haven't used it in a year or so, although I've heard that it only
keeps getting better / more mature / more complete.
According to their "Supported Platforms" page (
http://www.mono-project.com/Supported_Platforms ), their current list of
supported OS's is:
* Linux
* Mac OS X
* Sun
I have a large database used with our mail filter. The pg_dumpall
results in about 3GB with this being the only database in the system
besides templates and postgres.
I do a vacuum every night after backup and it takes about an hour, is
this normal for this size db? I also have autovacuum enabled
On Thu, Sep 20, 2007 at 09:57:30AM +0530, Gokulakannan Somsundaram wrote:
> Hi,
> Can anyone please advise on the steps that can be followed to start a
> Postgresql based database firm? I expect guidelines on the use of Postgresql
> resources and on ways to maintain relationship with the Postgr
Hi
Thank's Teodor and Marcelo
the problem is solved
regards
-Mensaje original-
De: marcelo Cortez [mailto:[EMAIL PROTECTED]
Enviado el: jue 20/09/2007 7:13
Para: MOLINA BRAVO FELIPE DE JESUS; Teodor Sigaev
CC: PostgreSQL General
Asunto: Re: [GENERAL] Tsearch2 - spanish
Felipe
---
Hi,
I think the query planner is unaware of the possibly best plan in some
situations. See the test case below:
-- --- --
CREATE TABLE tparent (
id integer NOT NULL,
ord integer NOT NULL,
CONSTRAINT par_pkey_id PRIMARY KEY (id),
CONSTRAINT
Well, the subject says it pretty well but to elaborate:
I have a database from our ERP package that uses btrieve (PervasiveSQL)
for it's database engine. I'd like to transition all of the data to
PostgreSQL. I've been having trouble finding a suitable program to
automatically get all of the da
In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
> I have a large database used with our mail filter. The pg_dumpall
> results in about 3GB with this being the only database in the system
> besides templates and postgres.
>
> I do a vacuum every night after backup and it takes about an hour
John D. Burger wrote:
Christian Schröder wrote:
Or would it be possible to tweak how the planner determines the
selectivity? I have read in the docs (chapter 54.1) that in case of
more than one condition in the where clause, independency is assumed.
In my case ("... where test like '11%' and
Hello group :)
How do a clear bits in a number in PostGreSQL?
in c++ its:
0xff00 &~ 0x
what is it in PostGreSQL from the psql command line app?
select ...
Thanx:)
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
There's NHibernate, which is a C# port of Java's Hibernate. I've got
no idea if it's any good, but using it might give you a Java Escape
Route if you needed someday to go cross platform.
-- Ilan
On Sep 19, 2007, at 1:19 PM, Scott Ribe wrote:
I'm asking this group because we tend to think al
Hi all,
I'm finding that routinely when I try to reload a database on a server
where I know there are no connections to a given DB I get the error:
$ dropdb foo && createdb foo -O bar && psql foo -f /path/to/db.out
dropdb: database removal failed: ERROR: database "foo" is being
accessed by oth
nevermind, I figured it out ...
fails:
0xff00 &~ 0x
succeeds:
0xff00 & ~ 0x
I had to add a space.
- Original Message -
From: "madhtr" <[EMAIL PROTECTED]>
To: "PostgreSQL General"
Sent: Thursday, September 20, 2007 13:01
Subject: [GENERAL] How to clear bi
Sysadmin <[EMAIL PROTECTED]> writes:
> I'm finding that routinely when I try to reload a database on a server
> where I know there are no connections to a given DB I get the error:
> $ dropdb foo && createdb foo -O bar && psql foo -f /path/to/db.out
> dropdb: database removal failed: ERROR: dat
Sysadmin wrote:
> Hi all,
>
> I'm finding that routinely when I try to reload a database on a server
> where I know there are no connections to a given DB I get the error:
>
> $ dropdb foo && createdb foo -O bar && psql foo -f /path/to/db.out
> dropdb: database removal failed: ERROR: database
On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
> In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
>
> > I have a large database used with our mail filter. The pg_dumpall
> > results in about 3GB with this being the only database in the system
> > besides templates and postgres.
> >
>
What is the correlation between PostgreSQL log severity levels and
syslog levels?
Specifically, I have PG (8.1) configured to route messages to syslog and
want to configure syslog to give me a periodic report of all error/worse
events. I configured syslog (syslog-ng) to create hourly files of
erro
Tom Lane wrote:
> Sysadmin <[EMAIL PROTECTED]> writes:
>> I'm finding that routinely when I try to reload a database on a server
>> where I know there are no connections to a given DB I get the error:
>
>> $ dropdb foo && createdb foo -O bar && psql foo -f /path/to/db.out
>> dropdb: database rem
Two vaguely helpful comments:
1. Sometimes this has happened to me when I unknowingly have two
terminal psql processes running on the same machine that I'm using to
connect to the server. Everyone but yourself may be off the database,
but there may be two instances of yourself. :)
2. I've
In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
> On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
> > That doesn't mean you're vacuuming often enough, however. Switch your
> > nightly vacuum to vacuum verbose and capture the output to see how much
> > work it has to do. Are your fsm
In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
> On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
> > In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
> >
> > > I have a large database used with our mail filter. The pg_dumpall
> > > results in about 3GB with this being the only
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bill Moran wrote:
> In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
>
>> On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
>>> In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
>>>
I have a large database used with our mail filter.
On Thu, 2007-09-20 at 16:38 -0400, Bill Moran wrote:
> In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
> Why does everyone leave of the IO subsystem? It's almost as if many
> people don't realize that disks exist ...
>
> With 2G of RAM, and a DB that's about 3G, then there's at least a G o
On Sep 20, 2007, at 3:47 PM, Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bill Moran wrote:
In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
I have a l
EnterpriseDB 8.2.4
create domain foodomain text check (value in ('val1', 'val2'));
alter table bigtable add foodomain;
I believe what's happening here is that the server doesn't realize
that the new column is going to have all nulls and that the check
constraint allows nulls. As such, the check
On 9/20/07, Robert Fitzpatrick <[EMAIL PROTECTED]> wrote:
> On Thu, 2007-09-20 at 16:38 -0400, Bill Moran wrote:
> > In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
> > Why does everyone leave of the IO subsystem? It's almost as if many
> > people don't realize that disks exist ...
> >
> >
Steve Crawford <[EMAIL PROTECTED]> writes:
> What is the correlation between PostgreSQL log severity levels and
> syslog levels?
Hmm, doesn't seem to be documented anywhere, but a look into the source
code finds
switch (edata->elevel)
{
case DEBUG5:
case DE
Jerry Sievers <[EMAIL PROTECTED]> writes:
> I believe what's happening here is that the server doesn't realize
> that the new column is going to have all nulls and that the check
> constraint allows nulls. As such, the check evidently is being
> evaluated for each row of the table.
Yup, that's ri
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> RAID5 optimizes for space, not performance or reliability. It gets
> faster but less reliable as it gets bigger. If you can afford the
> space RAID-10 is generally preferred.
RAID5 can be faster for DSS style work loads. If you're writing data to th
On 9/20/07, Collin <[EMAIL PROTECTED]> wrote:
> Well, the subject says it pretty well but to elaborate:
>
> I have a database from our ERP package that uses btrieve (PervasiveSQL)
> for it's database engine. I'd like to transition all of the data to
> PostgreSQL. I've been having trouble finding a
On Thursday 20 September 2007 11:41:00 Tom Lane wrote:
> "Albe Laurenz" <[EMAIL PROTECTED]> writes:
> > Jorge Godoy wrote:
> >> Even though one can require connections using only SSL on the
> >> server side, I don't see a method (in pg_hba.conf) that
> >> would allow clients with SSL certificates.
Tom Lane <[EMAIL PROTECTED]> writes:
> Jerry Sievers <[EMAIL PROTECTED]> writes:
>
> > I believe what's happening here is that the server doesn't realize
> > that the new column is going to have all nulls and that the check
> > constraint allows nulls. As such, the check evidently is being
> > e
Not really a question here, I just wanted to share my joy with the
group. I'm loving the new RETURNING clause in PostgreSQL. This is
really cool stuff ...
8<
CREATE OR REPLACE FUNCTION "public"."testfunc" () RETURNS bigint AS
$body$
DECLARE
my_var
On 9/21/07, D. Dante Lorenso <[EMAIL PROTECTED]> wrote:
> Not really a question here, I just wanted to share my joy with the
> group. I'm loving the new RETURNING clause in PostgreSQL. This is
> really cool stuff ...
I love it too! I have an update for out monitoring software that does
somethin
using java, PostGIS, org.postgis, I got PGgeometry object bur don't know how to
display it in GUI
45 matches
Mail list logo
