please help postgres IDENT error

khayll

Hi all!

PLease if somebody knows postgres:

i have in my pg_hba.conf (version 7.4.7):

local all all trust

and
createdb mydb
createuser myuser

but still I have the IDENT error with psql:

psql -U myuser mydb
psql: FATAL: IDENT authentication failed for user "myuser"

anybody have some tips, please?

thx,
Khayll

khayll

meanwhile i solved the problem...
I edited the wrong pg_hba.conf

the one postgres was using is
/var/lib/postgres/data/pg_hba.conf

and NOT

/etc/postgresql/pg_hba.conf

dunno why though...

Sxooter

It sounds like you have >1 versions of postgresql installed.

khayll

strange, cause I always use apt-get to install software, maybe an earlier version used /etc/postgres and now newer versions use the postgres data dir to store these files, or maybe when calling initdb postgres copies files from /etc/postgres...

Sxooter

But an upgrade / uninstall of the old version should take care of those files. Running a copy from source maybe?

khayll

well the init.d srcipt launches one postgres only, and i see no other running, and there seems to be only one binary in
/usr/lib/postgresql/bin/pg_dump

and there are links of them in the /usr/bin (actually they link to /usr/bin/pg_wrapper)

Sxooter

Yeah, just wondering really. Do you find duplicates of other common pg files like postgresql.conf pr the pg_xlog directory with locate?

(i.e. locate pg_xlog)

khayll

hm it seems postresql.conf can be found only in /etc/postgres no pg_xlog present

locate postgresql.conf
/etc/postgresql/postgresql.conf
/etc/postgresql/postgresql.conf.dpkg-dist
/usr/share/doc/postgresql/README.postgresql.conf
/usr/share/postgresql/postgresql.conf.in
/usr/share/postgresql/postgresql.conf.sample
/var/lib/dpkg/info/postgresql.conffiles
/var/lib/dpkg/info/postgresql.config
/var/lib/ucf/cache/:etc:postgresql:postgresql.conf

Sxooter

you'll need to be root or postgres to find those files that are locked away in a postgres owned dir with locate btw...

khayll

did it as root no pg_xlog

Sxooter

That's unpossible! Seriously, unless you're running a really REALLY old version of Postgresql, you have to have a pg_xlog directory, it's part and parcel of the db server, used for write ahead logging. It can't even start up without that directory.

😉

khayll

ok you're right there is, but locate does not show it:

www:~# whoami
root
www:~# locate pg_xlog
www:~# find / -name pg_xlog
/var/lib/postgres/data/pg_xlog

Sxooter

Yeah, it's likely in a directory that's excluded from updatedb / locate access.

khayll

yes, and it still looks like there is only one pg installed, and postgres.conf is loaded from /etc/postgres !

can it be, that when there is a pg_hba.conf in the data dir, then it overrides the default one in /etc/postgres ?

Sxooter

I'm not real familiar with the way debian / postgresql works, so I can't really say. I would expect that the pg_hba.conf in the data directory would be the one to be used. it might at one time have been linked to the one in /etc...

I do know that the debian team is working on a system that will allow a machine to have multiple postgresql packages installed in different data directories do you can have V 7.4.x and V 8.0.x installed at the same time using packages. i doubt that you are running into that, as it is still in the early stages of development from what I've read.

khayll

well, it seems to work fine now...
thanks for your help!