Skip site navigation (1) Skip section navigation (2)

Re: login problem

From: Ernesto Jardim <ernesto(at)ipimar(dot)pt>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: login problem
Date: 2002-09-10 17:07:31
Message-ID: 1031677652.1981.12.camel@gandalf (view raw or flat)
Thread:
Lists: pgsql-novice
Hi

The command line you've described didn't work ...

I've included the option "-i" in the /etc/sysconfig/postgresql file:

POSTGRES_OPTIONS="-i"

and restarted the server using SuSE scripts and it worked out perfectly.

Thanks and regards

EJ

On Tue, 2002-09-10 at 16:51, Josh Berkus wrote:
> Ernesto,
> 
> > I'm using pg 7.2 in s SuSE 8.0 box.
> > 
> > I have no problem loging from the command line with
> > 
> > psql -U ernesto -d docmgr
> > 
> > but I'm unable to login from pgaccess or TOra. It gives an error of
> > connection refused and asks if the server is running on localhost and
> > port 5432.
> 
> How did you start PostgreSQL?   If you started it without the " -i"
> option, you will not be able to connect any way other than the command
> line on the local machine.  This sounds like your problem.
> 
> Be warned that SuSE's postgresql startup scripts are unreliable.  I
> keep meaning to pester the folks in Germany about this, but am rather
> busy ...
> 
> Start PostgreSQL with:
> 
> postgres(at)localhost > pg_ctl -o "-i" -l /log/file/name -D
> /pgsql/data/directory start
> 
> -Josh Berkus
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html



In response to

pgsql-novice by date

Next:From: Terry YaptDate: 2002-09-10 17:58:22
Subject: Re: pl/pgsql and returns timestamp type
Previous:From: Josh BerkusDate: 2002-09-10 15:51:29
Subject: Re: login problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group