Here are the results from reversing the arguments.
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?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$
-- 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.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org