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$
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?
-- Hugh
At 04:40 PM 11/20/02 +1000, you wrote:
> >> biko:/usr/bin# psql -U postgres template1
>
>Maybe try : biko:/usr/bin# psql tempate1 -U postgres
>
>I use PG on Debian too. I much prefer to compile from source. It's very
>easy why don't you give it a try.
>I've never had a problem compiling from source, just make sure to follow
>the instruction's carefully in the INSTALL file.
>
>Good luck
>Regards Rudi.