Re: [GENERAL] Autostart PostgreSQL in Ubuntu

2007-10-01 Thread Johann Maar
Hi, > /var/run/ might be on a temporary file system. So you need to adjust > your init script to create that directory if it doesn't exist. That is what I tried now and it works for now. I never had installed the Debian's PostgreSQL packages and I once manually installed those init.d-script. As

Re: [GENERAL] Autostart PostgreSQL in Ubuntu

2007-09-26 Thread Martijn van Oosterhout
On Wed, Sep 26, 2007 at 10:05:21PM +0200, Peter Eisentraut wrote: > > I tried to change the location of the PID target directory in > > postgresql.conf, but then clients like psql still try to find the PID > > file in /var/run/ postgresql and fail. > > You must be mistaken about this. psql shoul

Re: [GENERAL] Autostart PostgreSQL in Ubuntu

2007-09-26 Thread Peter Eisentraut
Johann Maar wrote: > 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 a

Re: [GENERAL] Autostart PostgreSQL in Ubuntu

2007-09-26 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Carlos Moreno wrote: > Johann Maar wrote: >> 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 direct

Re: [GENERAL] Autostart PostgreSQL in Ubuntu

2007-09-26 Thread Martin Marques
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 ru

Re: [GENERAL] Autostart PostgreSQL in Ubuntu

2007-09-26 Thread Carlos Moreno
Johann Maar wrote: 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

[GENERAL] Autostart PostgreSQL in Ubuntu

2007-09-26 Thread Johann Maar
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