Thread: Error in the starting of Postgresql

José Luiz wrote:

> href="file://C:\Arquivos de programas\Arquivos comuns\Microsoft
> Shared\Papel de carta\">

    Please please please do not use HTML email.



> I am using suse linux 6.4, and when I installed linux I installed
> postgresql distributed by suse.
>
> I installed but I did not used (neither started it).

    Have you used the RPM or compiled from source?



> Now I downloaded the new postgresql version (7.0.3) and installed it in
> the same directories where suse installed (/usr/lib/pgsql).
>
> In rc.config I used the option to start postgresql automatically when
> linux boot.
>
> During the linux boot I am receiving a message:  Starting service
> postgressu:  warnig:  cannot change directory to /usr/local/pgsql, and
> posgresql do nott start..

    Have you checked the permissions for /usr/local/pgsql?


--
   _
  / \   Leandro Guimarães Faria Corsetti Dutra         +55 (11) 3040 8913
  \ /   Amdocs at Bell Canada                          +1 (514) 786 87 47
   X    Support Center, São Paulo, Brazil          mailto:adbaamd@bell.ca
  / \   http://terravista.pt./Enseada/1989/    mailto:leandrod@amdocs.com

I found my error.

I wrote:
> Now I downloaded the new postgresql version (7.0.3) and installed it in
the > same directories where suse installed (/usr/lib/pgsql).

After this point, I made a terrible mystake.  I changed the home directory
of user postgres from /usr/lib/pgsql  to  /usr/local/pgsql.

This directory was not in my hd, and, the error message was displayed.

 Thanks for the help.