Re: installation..

On Tue, 2002-12-03 at 19:30, Miro Kralovic wrote:

> I've just installed RedHat 7.3 with PgSQL packages and I don't really know
> where to start now.

I'm in a very similar situation, but a little farther along...

> 1. how do I add users and hosts?

I did it with webmin's postgresql module. It's part of the main webmin
download from http://www.webmin.com

> 2. how do I run client?

psql? I'm not real sure about that.

> 3. when trying to run PgAccess client, it tell's me I need libpgtcl.so. I
> found a package that has it, installed it but still can't run pgaccess.. is
> there anything else I've missed?

To solve that, I did a google search for libpgtcl.so. There were several
versions available, but one looked like version 7.2, so I grabbed it and
installed it, and pgaccess started working.

This is where I'm stuck. Pgaccess says the connection is refused when
asked to connect to a server at port 5432 on localhost.
If I leave the hostname empty, pgaccess fills the hostname field with
"local (sockets)" and opens the database.
Telnet localhost 5432 also says the connection is refused.
Webmin's postgresql module connects to the server. I can set server
config options and create databases and tables with webmin, and webmin
can start and stop the server.
If I run psql with no arguments, it connects to a database named ghe (my
username).
I ran an nmap tcp SYN scan of ports 1-65535 on localhost. 5432 is not
open, and examining all the open ports with fuser, ps, and grep accounts
for all of them - and neither postgresql nor postmaster is using any of
the active ports.
When the system boots, the postgresql startup script says it is
successful, and there is nothing to the contrary in the system log.
Iptables says it is accepting and forwarding everything.
I've tried as user ghe and as user postgres.
I've installed 7.2.2 that came in an RPM with RedHat 8.0, and I've
downloaded and installed 7.3 from the web site.

Help, please??

--
Glenn English
ghe@slsware.com