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,

thaks for the tips.  i added

local   all         all           trust

to pg_hba.conf and so far so good.  obviously, i have
a little more to learn about this topic.  the manual
is great and all, but i find them dry.  i *really* get
along better with tutorials that have lots of specific
examples.  does anyone know of a good tutorial that
covers this topic?

also, be sure to us pg_ctl to reload when you change
pg_hba.conf or the changes to it don't take effect.

the statement required to reload:

usr/lib/postgresql/8.1/bin/pg_ctl reload -D
/var/lib/postgresql/8.1/main

is a bit excessive.  i seem to recall (from my cygwin
days ;-) there is a file where i can include this path
so i don't have to type it out each time.  can anyone
give any hints to make this easier?

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com