Re: installation.. - Mailing list pgsql-novice

Start postmaster with -i.  This will tell it to listen for tcp/ip
packets on port 5432.
On Tuesday, December 3, 2002, at 09:36  PM, Glenn English wrote:

> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>
=======================
Jeffrey Melloy
jmelloy@visualdistortion.org

http://www.visualdistortion.org
http://www.platformers.com