Re: Autostart PostgreSQL in Ubuntu

Поиск
Список
Период
Сортировка
От Martin Marques
Тема Re: Autostart PostgreSQL in Ubuntu
Дата
Msg-id 46FA8FA5.1070006@bugs.unl.edu.ar
обсуждение исходный текст
Ответ на Autostart PostgreSQL in Ubuntu  (Johann Maar <johann.maar@gmx.net>)
Список pgsql-general
Johann Maar wrote:
> Hi folks,
>
> sorry I do not get it right and I have to ask now.
>
> I manually compiled PostgreSQL on my Kubuntu machine to /usr/local/opt/
> pgsql and did all this stuff like creating a "postgres" user and I
> have a startup script in /etc/init.d.
> But if I try to start PostgreSQL by running "sudo /etc/init.d/
> postgresql start" it will fail because it tries to write a PID file to
> "/var/run/postgresql" which does not exist. If I create this directory
> and set the permissions for postgres to write it works (!), but after
> the next restart of the machine the directory is already gone.

You should try to find out why the /var/run/postgresql directory
disappears after reboot.

--
  21:50:04 up 2 days,  9:07,  0 users,  load average: 0.92, 0.37, 0.18
---------------------------------------------------------
Lic. Martín Marqués         |   SELECT 'mmarques' ||
Centro de Telemática        |       '@' || 'unl.edu.ar';
Universidad Nacional        |   DBA, Programador,
     del Litoral             |   Administrador
---------------------------------------------------------

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Filesystem crash - corupted database
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Duplicate public schema and user tables