[vPostMaster] Vpostmaster

[Sean Reifschneider]

On Tue, Sep 18, 2007 at 12:25:10PM -0400, Sam Povilus wrote:
>postgres=# SELECT passwd FROM pg_shadow WHERE usename='vpostmster';

You mis-spelled vpostmaster above.

>going wrong with my postgres server? i also tried uncommenting this line 
>in pg_hba.conf:
>
>host    all         all         127.0.0.1/32          ident sameuser

This will probably break the ability for the vPostMaster services to login.
vPostMaster needs to use the password authentication.

As I recall in this thread, you were saying that you changed your firewall
and then you started getting the Postgres connection issues?  So the
firewall may have been the problem at that point.  I wonder if in trying to
fix things related to the firewall that you changed things like the above,
and got the firewall working but other changes caused problems once that
was fixed.

You could try re-running the appropriate setup script.  It should be safe
to re-run and may resolve the issue.  However, it was meant to be run on a
stock system, and may not be able to cope with the modifications that have
been made.

You might want to go through the setup script and hand check the
differences between it and what is currently on the system that it would
try to set up.

>but it juat said "uathentication failed" when trying "cd vpostmaster: 
>psql -d vpostmaster -h localhost"

Good, you should have to use the password to authenticate with the
database.

Sean
-- 
 Q:  What kind of dog goes "BOFH!  BOFH!"?
 A:  A rootweiler
Sean Reifschneider, Member of Technical Staff <jafo at tummy.com>
tummy.com, ltd. - Linux Consulting since 1995: Ask me about High Availability