[WYLUG-help] PostgreSQL and SQL-Ledger

[Stephen]

On 03 Jun 06, Mike Goodman (mike.goodman at zen.co.uk) wrote:
> postgres at server:~$ psql \l
> psql: FATAL:  database "l" does not exist

Ah, not quite, run psql first and that'll give you a postgres (sql) command
line.

> Does anyone have any experience of installing postgresql with apt? Does
> it complete the post-install routines including setting paths correctly?
> The reason I ask is because as user postgres commands like pg_ctl are
> simply not recognised, yet are the standard way of doing things
> according to the manual. Also, the data directories are not as in the
> manual's quoted paths.

Some of the odd admin binaries go in /usr/lib/postgresql which isn't pathed.
The apt postgres 8.1 works just fine (I've got it running here).

-- 
Stephen Patterson :: steve at patter.mine.nu :: http://patter.mine.nu/
GPG: E3E8E974 :: Jabber: patter at jabber.earth.li 
"At night, the razor weasels come."