> 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