Re: Problems invoking psql. Help please.

I did this tonight

dpkg --purge postgresql
apt-get install postgresql

and am now still getting the following:

>biko:/usr/bin# psql -U postgres
>No database specified
>biko:/usr/bin# psql -U postgres template1
>Could not execv /usr/lib/postgresql/bin/psql
>biko:/usr/bin# psql -U postgres template0
>Could not execv /usr/lib/postgresql/bin/psql
>biko:/usr/bin# psql -U postgres ggp_test
>Could not execv /usr/lib/postgresql/bin/psql
>biko:/usr/bin#

My pg_hba.conf temporarily reads:
>local all trust
>host all 127.0.0.1 255.255.255.255 trust
>host template1 192.168.2.21 255.255.255.0 trust
>host all 0.0.0.0 0.0.0.0 reject

(Eventually, before I take this live, I'll figure out the crypt part).

The postgresql installation is at 192.168.10. I'm working from a shell at
192.168.2.21. But I also tried running this from the application server at
2.10 as well and got the same errors.

And now pgAdmin II is giving me a connection error:
>An error has occured in pgAdmin II:frmConnect.cmdConnect_Click
>Number -2147467259
>Description: Could not connect to the server;
>Could not connect to remote socket.

/etc/postgresql/postgresql.conf includes a line reading:
>tcpip_socket = 1

which I assume means that I _should_ be able to make a TCP connection
across the network. Although I cannot seem to do so.

Working in Debian 3.0 Woody, with postgreSQL 7.2. Still looking for clues,
in fact I seem to be looking for more clues now than I was yesterday.

-- Hugh

At 05:20 PM 11/19/02 +0000, you wrote:
>Did you install your package using apt-get ?
>All the instalations that I do are using those tools from debian. You have
>to see all the packages that you have instaled in your computer like:
>
>dpkg -l | grep postgresql
>ii postgresql 7.2.1-2 Object-relational SQL database, descended fr
>ii postgresql-cli 7.2.1-2 Front-end programs for PostgreSQL
>ii postgresql-con 7.2.1-2 Additional facilities for PostgreSQL
>
>Then you do: dpkg --purge postgresql. You can now run the first command to
>see if something is still installed. If some are instaled, the you remove
>it using again dpkg --purge.
>
>Luis Sousa
>
>Hugh Esco wrote:
>
>>I have reinstalled before. I wonder though, how I ensure that I have
>>cleanly un-installed it first, so that I leave no residue from the
>>previously botched installation around to mess things up the next time.
>>
>>-- Hugh Esco
>>
>>At 09:03 AM 11/19/02 +0000, Luis Sousa wrote:
>>
>>>Tom Lane wrote:
>>>Start over: delete your PG installation and reinstall the Debian
>>>package. It seems very clear that you've got an incomplete package.
>>>regards, tom lane
>>>I agree with Tom Lane. Probably is the best thing to do. When you
>>>install all it over, in theory, all the problems will solve by them selfs.
>>>
>>>Luis Sousa