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 http:

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 defau

[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(); but for a local connection (simple login us

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 ma

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 - po

[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 40

[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) returns

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

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 bawah