On Tue, Aug 26, 2003 at 18:10:10 +0200,
javier garcia - CEBAS <[EMAIL PROTECTED]> wrote:
> # su - postgres
> (I don't know the meaning of a "login shell", but this is not my problem)
> And then appears the message (in spanish):
> "su: atention: we can't change to the directory /var/lib/pgsql: the directory
> or file doesn't exists"
>
> Previously I had postgres databases in /var/lib/pgsql. But I've uninstalled
> the previously the 7.2 version and I don't know why this happens.
>
> Could anyone guide me with this?
/var/lib/pgsql is the home directory for the postgres user.
You can avoid this problem by not using the - in the su command.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
