Re: [SQL] psql: FATAL: Ident authentication failed for user postgres

2008-09-08 Thread Filip Rembiałkowski
2008/9/8 VG [EMAIL PROTECTED]: Hi, I have installed postgresql-serve using yum hba.conf group and owner were postgres then i changed it to root. when i type psql -U postgres command ( as root user) I get: psql: FATAL: Ident authentication failed for user postgres read

Re: [SQL] psql: FATAL: Ident authentication failed for user postgres

2008-09-08 Thread Milen A. Radev
VG написа: Hi, I have installed postgresql-serve using yum hba.conf group and owner were postgres then i changed it to root. Why? when i type psql -U postgres command ( as root user) I get: psql: FATAL: Ident authentication failed for user postgres Most probably the default

[SQL] problem with pg_stat_activity view

2008-09-08 Thread Sofer, Yuval
Hello, postgres version: 8.2.0.4 platform windows: server 2008 I check connections using: SELECT pg_stat_get_backend_idset() Now, I take the output and try to get the ip addresses using select pg_stat_get_backend_client_addr(integer); but for a local connection (simple

Re: [SQL] problem with pg_stat_activity view

2008-09-08 Thread Tom Lane
Sofer, Yuval [EMAIL PROTECTED] writes: postgres version: 8.2.0.4 ERROR: invalid input syntax for type inet: fe80::104d:416e:a8dc:c02e%12 This is fixed in 8.2.5 and later. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make

Re: [SQL] psql: FATAL: Ident authentication failed for user postgres

2008-09-08 Thread Devrim GÜNDÜZ
On Mon, 2008-09-08 at 15:39 +0530, VG wrote: hba.conf group and owner were postgres then i changed it to root. when i type psql -U postgres command ( as root user) I get: psql: FATAL: Ident authentication failed for user postgres First, revert the owner/group change. Then, su - postgres

[SQL] psql: FATAL: Ident authentication failed for user postgres

2008-09-08 Thread VG
Hi, I have installed postgresql-serve using yum hba.conf group and owner were postgres then i changed it to root. when i type psql -U postgres command ( as root user) I get: psql: FATAL: Ident authentication failed for user postgres My file permission are: drwx-- 5 postgres postgres

[SQL] PL/pgSQL function syntax question?

2008-09-08 Thread Ruben Gouveia
i get the following error when i try and create the following function: Basically, i am trying to have two different dates compared and only the most recent returned to me. This seems pretty straight forward, what I am doing wrong here? create or replace function fcn_pick_date(v_dt date)

Re: [SQL] PL/pgSQL function syntax question?

2008-09-08 Thread Adrian Klaver
-- Original message -- From: Ruben Gouveia [EMAIL PROTECTED] i get the following error when i try and create the following function: Basically, i am trying to have two different dates compared and only the most recent returned to me. This seems pretty

Re: [SQL] PL/pgSQL function syntax question?

2008-09-08 Thread imad
I see v_dt is not initialized before comparison, there should be some value in it before it is useful. --Imad On Tue, Sep 9, 2008 at 8:47 AM, Adrian Klaver [EMAIL PROTECTED] wrote: -- Original message -- From: Ruben Gouveia [EMAIL PROTECTED] i get the

Marilah cari Duit Rm10,Rm100,RM1000.00..

2008-09-08 Thread ehsan08
Marilah cari Duit Rm10,Rm100,RM1000.00.. Ini bukan pelaburan skim cepat kaya. Namun dengan hanya RM10 sahaja, peserta boleh menjana dana sehingga RM 1,000,000 yang bergantung kepada usaha dan kesungguhan dengan menggunakan sistem 5 peringkat penajaan yang telah disediakan. lihat dulu link di