From: "jasiek" <jasiek@lamer.pl>
To: Hugh Esco <hesco@greens.org>, pgsql-sql@postgresql.org
Subject: Re: Problems invoking psql. Help please.
Date: Wed, 20 Nov 2002 08:30:12 +0800
Message-Id: <20021120083012.M85101@lamer.pl>
In-Reply-To: <5.1.0.14.0.20021120015822.041515d0@petra.cagreens.org>
References: <5.1.0.14.0.20021116140623.031cbec0@petra.cagreens.org>
	<5.1.0.14.0.20021116140623.031cbec0@petra.cagreens.org>
	<5.1.0.14.0.20021118232418.03868810@petra.cagreens.org>
	<18156.1037685401@sss.pgh.pa.us>
	<5.1.0.14.0.20021119105355.0297a630@petra.cagreens.org>
	<5.1.0.14.0.20021120001957.04247c40@petra.cagreens.org>
	<5.1.0.14.0.20021120015822.041515d0@petra.cagreens.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2

> Here are the results from reversing the arguments.
> 
> >hesco@biko:~$ su postgres
> >Password:
> >postgres@biko:/home/hesco$ cd
> >postgres@biko:~$ cd /usr/bin
> >postgres@biko:/usr/bin$ psql tempate1 -U postgres
> >Could not execv /usr/lib/postgresql/bin/psql
> >postgres@biko:/usr/bin$ psql template1 -U postgres
> >Could not execv /usr/lib/postgresql/bin/psql
> >postgres@biko:/usr/bin$
Check the permissions. Psql is only a symbolic link to pg_wrapper. You should 
have:
ls -al /usr/bin/pg_wrapper
-rwxr-xr-x    1 root     root         6584 sie 25 23:55 /usr/bin/pg_wrapper

> If I compile from source, will the apt-get database know what I've 
> done?  Or will I have to do the updates from source as well?
No. If you want to create package .deb from your sources, look at debian 
packages source site. There is special debian patch in postgres directory. 
Apply it, compile your sources and create .deb package. The last step is to 
install this package with dpkg.

Regards, Tomasz Myrta