Обсуждение: Access with a management tool
I have got a tool for managing the postgres from postgres. When trying to register server and/or database I get the message, that I should check if the server is listening on 5432. Well, I do not really know. I know only that I've got access from a linux shell, but I am trying to operate from a windows client. Who can help? Per
I could add the question: where must the postgresql.conf file be located. I only have it under a var/lib-folder Regards Per "Per M�nster" <nospam@nowhere.com> skrev i en meddelelse news:3f98ffc1$0$29343$edfadb0f@dread15.news.tele.dk... > I have got a tool for managing the postgres from postgres. When trying to > register server and/or database I get the message, that I should check if > the server is listening on 5432. Well, I do not really know. I know only > that I've got access from a linux shell, but I am trying to operate from a > windows client. > > Who can help? > > Per > >
I found out that I have got 3 conf-files all located in the /var/lib/pgsql library, which to my eyes seem to be the right. The postgresql.conf has the port 5432 mentionend and the service is running all right. But I can not connect. /Per "Per M�nster" <nospam@nowhere.com> skrev i en meddelelse news:3f98ffc1$0$29343$edfadb0f@dread15.news.tele.dk... > I have got a tool for managing the postgres from postgres. When trying to > register server and/or database I get the message, that I should check if > the server is listening on 5432. Well, I do not really know. I know only > that I've got access from a linux shell, but I am trying to operate from a > windows client. > > Who can help? > > Per > >
edit your pg_hba.conf
regards,
Oli
-----Ursprüngliche Nachricht-----
Von: Per Münster [mailto:nospam@nowhere.com]
Gesendet: Freitag, 24. Oktober 2003 12:32
An: pgsql-admin@postgresql.org
Betreff: [ADMIN] Access with a management tool
I have got a tool for managing the postgres from postgres. When trying to
register server and/or database I get the message, that I should check if
the server is listening on 5432. Well, I do not really know. I know only
that I've got access from a linux shell, but I am trying to operate from a
windows client.
Who can help?
Per
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
if it's a pg_hba issue, he should get a FATAL "authentication
failed"-ish message. I'd check for tcpip_socket=true in postgresql.conf
first.
Robert Treat
On Fri, 2003-10-24 at 11:00, Oliver Scheit wrote:
> edit your pg_hba.conf
>
> regards,
> Oli
>
> -----Ursprüngliche Nachricht-----
> Von: Per Münster [mailto:nospam@nowhere.com]
> Gesendet: Freitag, 24. Oktober 2003 12:32
> An: pgsql-admin@postgresql.org
> Betreff: [ADMIN] Access with a management tool
>
>
> I have got a tool for managing the postgres from postgres. When trying to
> register server and/or database I get the message, that I should check if
> the server is listening on 5432. Well, I do not really know. I know only
> that I've got access from a linux shell, but I am trying to operate from a
> windows client.
>
> Who can help?
>
> Per
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Thanks,
I came one step further. Not I get the FATAL, saying that I do not have an
entry in pg_hba.conf for my user and computer.
I gues that I will have to put in a line like:
host all 192.168.1.39 255.255.255.255 trust at the end of
the file - am I right?
Regards
Per
"Robert Treat" <xzilla@users.sourceforge.net> skrev i en meddelelse
news:1067019276.2069.14818.camel@camel...
> if it's a pg_hba issue, he should get a FATAL "authentication
> failed"-ish message. I'd check for tcpip_socket=true in postgresql.conf
> first.
>
> Robert Treat
>
> On Fri, 2003-10-24 at 11:00, Oliver Scheit wrote:
> > edit your pg_hba.conf
> >
> > regards,
> > Oli
> >
> > -----Urspr�ngliche Nachricht-----
> > Von: Per M�nster [mailto:nospam@nowhere.com]
> > Gesendet: Freitag, 24. Oktober 2003 12:32
> > An: pgsql-admin@postgresql.org
> > Betreff: [ADMIN] Access with a management tool
> >
> >
> > I have got a tool for managing the postgres from postgres. When trying
to
> > register server and/or database I get the message, that I should check
if
> > the server is listening on 5432. Well, I do not really know. I know only
> > that I've got access from a linux shell, but I am trying to operate from
a
> > windows client.
> >
> > Who can help?
> >
> > Per
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
Thanks.
My assumptions seem to have been right. I am connected now. It seems a bit
more open than working directly on the shell-line. The interesting question
is how will I be able to access the databases.
I do have a developers handbook on my desk, but it is a giant of a book.
Regards
Per
"Robert Treat" <xzilla@users.sourceforge.net> skrev i en meddelelse
news:1067019276.2069.14818.camel@camel...
> if it's a pg_hba issue, he should get a FATAL "authentication
> failed"-ish message. I'd check for tcpip_socket=true in postgresql.conf
> first.
>
> Robert Treat
>
> On Fri, 2003-10-24 at 11:00, Oliver Scheit wrote:
> > edit your pg_hba.conf
> >
> > regards,
> > Oli
> >
> > -----Urspr�ngliche Nachricht-----
> > Von: Per M�nster [mailto:nospam@nowhere.com]
> > Gesendet: Freitag, 24. Oktober 2003 12:32
> > An: pgsql-admin@postgresql.org
> > Betreff: [ADMIN] Access with a management tool
> >
> >
> > I have got a tool for managing the postgres from postgres. When trying
to
> > register server and/or database I get the message, that I should check
if
> > the server is listening on 5432. Well, I do not really know. I know only
> > that I've got access from a linux shell, but I am trying to operate from
a
> > windows client.
> >
> > Who can help?
> >
> > Per
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>