Re: postgres db deleted and recreated... "No directory,

Hi,

On Sat, 2006-05-06 at 12:26 -0700, operationsengineer1@yahoo.com wrote:
> user@7[/]$ su root
> Password:
> root@7[/]# psql -U postgres
> psql: FATAL:  Ident authentication failed for user
> "postgres"

Run su - postgres and then psql for ident auth.

See

http://www.postgresql.org/docs/8.1/static/client-authentication.html

about client authentication details.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/