Re: [ADMIN] [SOLVED] pg_hba.conf + all + trust = Ident authentication failed

2006-03-06 Thread Andy Shellam
You could always symlink the debian config files to your correct ones. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ow Sent: Monday, 06 March, 2006 3:46 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] [SOLVED] pg_hba.conf + all + trust = Id

Re: [ADMIN] [SOLVED] pg_hba.conf + all + trust = Ident authentication failed

2006-03-06 Thread ow
--- Stephan Szabo <[EMAIL PROTECTED]> wrote: > Are you sure you're using the configuration below (ie, you're editing the I was sure... :-) > correct file and have at least used sighup after the change)? It sure > looks like the server thinks the method is ident which would be the > default for

Re: [ADMIN] pg_hba.conf + all + trust = Ident authentication failed for user "postgres"

2006-03-06 Thread Andy Shellam
To me it would suggest that pgSQL is not looking at the pg_hba.conf you think it is - as it shouldn't prompt for a password when trust authentication is set (it doesn't on my box when connecting via a socket.) Also you mention that your listen_address looks like "#listen_addresses" - in which case

Re: [ADMIN] pg_hba.conf + all + trust = Ident authentication failed

2006-03-06 Thread Stephan Szabo
On Mon, 6 Mar 2006, ow wrote: > PostgreSQL 8.1.0 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 2005 > (prerelease) (Debian 4.0.2-4) > > > Hi, > > Can't get pg_hba.conf with trust to work: > > [EMAIL PROTECTED]:~$ psql -U postgres > psql: FATAL: Ident authentication failed for user

Re: [ADMIN] pg_hba.conf + all + trust = Ident authentication failed for user "postgres"

2006-03-06 Thread ow
In postgresql.conf I have "#listen_addresses = 'localhost'" and I am logged in directly into the box, without telnet, ssh or whatever. But "psql -U postgres -h localhost" DID WORK (after I entered the password) and that's a big step forward, thanks. I'm still not sure why I needed to enter the p

Re: [ADMIN] pg_hba.conf + all + trust = Ident authentication failed for user "postgres"

2006-03-06 Thread Andy Shellam
No you're right, there shouldn't be anything in pg_ident.conf. Check in your postgresql.conf file, and set "listen_interfaces" to *, so it listens on TCP/IP (if not already.) Then try connecting with "psql -U postgres -h localhost" and see if that lets you on. Also check your postgresql.conf fil

Re: [ADMIN] pg_hba.conf + all + trust = Ident authentication failed for user "postgres"

2006-03-06 Thread ow
No, pg_ident.conf is empty (i.e. contains only comments). My impression was that with "trust" nothing was needed in pg_ident.conf, no? Thanks --- Andy Shellam <[EMAIL PROTECTED]> wrote: > Does your pg_ident.conf contain anything with reference to testusr? As it > seems to be trying Ident authe

Re: [ADMIN] pg_hba.conf + all + trust = Ident authentication failed for user "postgres"

2006-03-06 Thread Andy Shellam
Does your pg_ident.conf contain anything with reference to testusr? As it seems to be trying Ident authentication over everything else and failing. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ow Sent: Monday, 06 March, 2006 1:02 PM To: pgsql-adm

[ADMIN] pg_hba.conf + all + trust = Ident authentication failed for user "postgres"

2006-03-06 Thread ow
PostgreSQL 8.1.0 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 2005 (prerelease) (Debian 4.0.2-4) Hi, Can't get pg_hba.conf with trust to work: [EMAIL PROTECTED]:~$ psql -U postgres psql: FATAL: Ident authentication failed for user "postgres" If I do "su postgres" and then "psq

[ADMIN] need commands for "Log on as a service" and folder rights

2006-03-06 Thread Mohamed Fazil
Hello all,   I am facing two more problems while trying to incorporate postgres in my application. As mentioned earlier i am trying to deploy Potgres8.1.1 through a program. While doing so i am facing following issues on:   1. How do I provide "Log on as a service" rights to the user created