Thread: login problem

login problem

From
Ernesto Jardim
Date:
Hi

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 can I overcome the problem ??

As far as I understand using the command line it is connecting to
localhost in port 5432 ...

Regards

EJ




Re: login problem

From
"Josh Berkus"
Date:
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@localhost > pg_ctl -o "-i" -l /log/file/name -D
/pgsql/data/directory start

-Josh Berkus



Re: login problem

From
Ernesto Jardim
Date:
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@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