Re: TCP/IP database connection problem with pgaccess - Mailing list pgsql-interfaces

1) Do you start the server as postgres user?
2) Do a netstat -na and make sure port 5432 is listening
3) as postgres user make sure you can connect using psql  --- psql template1


----- Original Message -----
From: "Hong Jin" <h1jin@ucsd.edu>
To: "'PG Explorer'" <pgmail@pgexplorer.com>
Sent: Monday, March 18, 2002 10:28 PM
Subject: RE: [INTERFACES] TCP/IP database connection problem with pgaccess


> I had Redhat 7.2 linux and postgresql 7.2 installed, following Kevin
Kemp's
> instructions in his artical of "Getting Start with Postgresql on Redhat
> 7.0", I edited /var/lib/pgsql/data/postmaster.opts
>
> From:
> /usr/bin/postmaster
>
> To:
> /usr/bin/postmaster
> -p 5432
> -D /var/lib/pgsql/data
>   -B 64
> -B /usr/bin/postgres
> -i
> -N 32
>
> My PGACCESS_HOME=/usr/local/pgaccess in main.tcl
>
> I created a soft link: ln -s /usr/local/pgaccess/pgaccess
/usr/bin/pgaccess
>
> The last two lins in file /var/lib/pgsql/data/pg_hba.conf, I changed to:
>
> Local all trust
> host all <client IP address> 255.255.255.0 trust
>
> In file /var/lib/pgsql/data/postgresql.conf, I uncommented the following
two
> lines:
>
> tcpip_socket =true
> port=5432
>
>
> After I did all these, I still cann't connect to my database via pgaccess,
> and I got the same error message. I really don't know how to connect.
Please
> help me to figure it out. Thanks a lot.
>
> Another problem I encounted is if I login as 'root', I can stop the
> potgresql server by using the command "service postgresql stop", but after
> then I cann't restart it again by using "service postgresql start". I got
> the error message:
>
> 'root' execution of the postgresql server is not permitted. The server
must
> be started under an unprivileged user id to prevent a possible system
> security compromise. See the documentation for more information on how to
> properly start the server
>
>
> Where can I find the documentation and why 'root' is allowed to stop but
not
> restart the server? How can I properly start the server?
>
> --------------------------------------------
>
> Hong Jin
> h1jin@ucsd.edu
>
> > -----Original Message-----
> > From: pgsql-interfaces-owner@postgresql.org
> > [mailto:pgsql-interfaces-owner@postgresql.org]On Behalf Of PG Explorer
> > Sent: Tuesday, March 12, 2002 1:02 PM
> > To: h1jin@ucsd.edu; pgsql-interfaces@postgresql.org
> > Subject: Re: [INTERFACES] TCP/IP database connection problem with
> > pgaccess
> >
> >
> > Have a look at my FAQ's it might be of help
> >
> > http://www.pgexplorer.com/faqs.php
> >
> >
> >
> >
> > http://www.pgexplorer.com
> > Gui Tool for Postgres
> >
> > ----- Original Message -----
> > From: "Hong Jin" <h1jin@ucsd.edu>
> > To: <pgsql-interfaces@postgresql.org>
> > Sent: Tuesday, March 12, 2002 9:00 PM
> > Subject: [INTERFACES] TCP/IP database connection problem with pgaccess
> >
> >
> > > All:
> > >
> > > I installed pgaccess and was able to bring up the
> > interface. But when I
> > try
> > > to open a database, I got an error message of "Error trying
> > to connect to
> > > database databasename on host IPaddress. Is the server
> > running on host
> > > ...(host IP address or localhost) and accepting TCP/IP
> > connections on port
> > > 5432?".
> > > Is anyone knows how to configure and get my database connected via
> > pgaccess?
> > > Thanks for help!
> > >
> > > --------------------------------------------
> > >
> > > Hong Jin
> > > h1jin@ucsd.edu
> > >
> > >
> > > ---------------------------(end of
> > broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> > majordomo@postgresql.org
> >