Re: Autostart PostgreSQL in Ubuntu

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Johann Maar <johann(dot)maar(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Autostart PostgreSQL in Ubuntu
Date: 2007-09-26 16:58:13
Message-ID: 46FA8FA5.1070006@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
---------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-09-26 17:03:03 Re: Duplicate public schema and user tables
Previous Message Martijn van Oosterhout 2007-09-26 16:40:22 Re: Filesystem crash - corupted database