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 get the same
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
-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
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
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).
-Tony
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?
What is
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 that
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
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 (e.g.
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. What can
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
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 Solaris patch
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
17 matches
Mail list logo