On Wed, 2004-05-19 at 02:19, Tom Lane wrote:
> Nico De Ranter <[EMAIL PROTECTED]> writes:
> > \connect: FATAL: IDENT authentication failed for user "nico"
>
> > I changed /etc/postgresql/pg_hba.conf so it only contains
> > localall all trust=20
> > and restarted postgres but I still g
Hi,
I've a "little" problem while trying to access any pg database trough our
VPN. It simply refuse the connection. Otherwise, The connection works fine
on our server put in the DMZ with a classical connection.
Our setup is:
client: Eclipse with a JDBC driver trough VPN
server: Pg SQL 7.4.2 with a
On Wed, 19 May 2004 11:03:11 +0300, Olivier Hubaut
<[EMAIL PROTECTED]> wrote:
Hi,
I've a "little" problem while trying to access any pg database trough our
VPN. It simply refuse the connection. Otherwise, The connection works
fine
on our server put in the DMZ with a classical connection.
Our
Hallo Lists,
yesterday our database-server crashed (raid-error). After reparing the
filesystem (ext2) we have a problem with our lagest table in the database.
vaccuum aborts with the following meassage (sorry it is in German):
DEBUG: vacuume »messungen.massendaten«
HINWEIS: Relation »massendate
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 5:19 PM
To: Nico De Ranter
Cc: postgres-list
Subject: Re: [ADMIN] "IDENT authentication failed" but I'm not using
ident
Nico De Ranter <[EMAIL PROTECTED]> writes:
> \connect: FATAL: IDENT authenti
According to the document of rule:
CREATE RULE rulename AS ON delete TO mytablename DO
(
delete from aaa where id=OLD.id;
Delete from bbb where id=OLD.id;
Delete from ccc where id=OLD.id
);
Should work, but it doesn't, what wrong with it?
Even I use { }
Jie Liang
-
Sorry, wrong question.
-Original Message-
From: Jie Liang
Sent: Wednesday, May 19, 2004 10:20 AM
To: Tom Lane
Cc: postgres-list; [EMAIL PROTECTED]
Subject: [ADMIN] rules
According to the document of rule:
CREATE RULE rulename AS ON delete TO mytablename DO
(
delete from aaa where id=OL
> Hi,
>
> the certificate was create in the directori of data, an the permision its
> to user postgres.
>
> but the database not start
>
Print the postmaster log file (I think it's $PGDATA/serverlog). It
should tell you specifically why the SSL mode can't start
(permissions/existence/etc).
-To
On Wed, 19 May 2004, Jie Liang wrote:
> According to the document of rule:
>
> CREATE RULE rulename AS ON delete TO mytablename DO
> (
> delete from aaa where id=OLD.id;
> Delete from bbb where id=OLD.id;
> Delete from ccc where id=OLD.id
> );
>
>
> Should work, but it doesn't, what wrong with it?
Bill Chandler <[EMAIL PROTECTED]> writes:
> LOG: invalid entry in pg_hba.conf file at line 60,
> token "255.255.255.255"
> I have found that if I change this value to anything
> other than "255.255.255.255" (e.g. "255.255.255.254")
> the message goes away.
Bizarre. AFAICS this must indicate th
Hello list,
I know this is a complicated issue, but I'll throw it out there...
Our DB box has 3GB of ram - which is supposed to be used by
postgres. Whenever I use top, it only shows about 800MB being
used with 2.2GB free. What can I do to tell postgres to use more
of that memory - maybe 2GB ?
I
Hello,
Running 7.4.2 on Solaris 8 (binaries were built on
a different Solaris 8 box).
I keep getting the following message when trying to
connect to server:
FATAL: missing or erroneous pg_hba.conf file
HINT: see server log for details.
Server log contains message:
LOG: invalid entry in pg_hba.
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Tom Lane) belched out:
> Bill Chandler <[EMAIL PROTECTED]> writes:
>> LOG: invalid entry in pg_hba.conf file at line 60,
>> token "255.255.255.255"
>
>> I have found that if I change this value to anything
>> other than "255.255.255.255"
Oops! [EMAIL PROTECTED] was seen spray-painting on a wall:
> Hello list,
>
> I know this is a complicated issue, but I'll throw it out there...
> Our DB box has 3GB of ram - which is supposed to be used by
> postgres. Whenever I use top, it only shows about 800MB being
> used with 2.2GB free. Wha
Stefan Holzheu <[EMAIL PROTECTED]> writes:
> yesterday our database-server crashed (raid-error). After reparing the
> filesystem (ext2) we have a problem with our lagest table in the database.
> vaccuum aborts with the following meassage (sorry it is in German):
> DEBUG: vacuume »messungen.mass
Christopher Browne <[EMAIL PROTECTED]> writes:
> After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Tom Lane) belched out:
>> Bill Chandler <[EMAIL PROTECTED]> writes:
>>> Interestingly the same 7.4.1 binary running on a different machine did
>>> not exhibit the problem. Could it be a So
OK, TODO updated:
* Allow col IS TRUE/FALSE use an index like col = TRUE/FALSE
---
Greg Johnson wrote:
> I just ran into this yesterday also. I was trying
> select * from foo where expired IS TRUE
> and the index
I had instal postgresql on suse Linux,now i want to Instal phpPgAdmin so
what is the procedure
_
Best of Indian handicrafts.
http://www.fabmall.com/affiliatehtml/redir/nl8.asp At MSN Shopping.
---(end of b
18 matches
Mail list logo