Re: running postgresql as a linux service - Mailing list pgsql-php
From | Ron St-Pierre |
---|---|
Subject | Re: running postgresql as a linux service |
Date | |
Msg-id | 405F15E2.4040109@syscor.com Whole thread Raw |
In response to | Re: running postgresql as a linux service ("Raul Secan" <raul@zerosoft.ro>) |
List | pgsql-php |
I haven't had access to my mail over the last few days, so in case you are still having a problem, check below. Raul Secan wrote: >I saw that in /etc/init.d/ dir I already have postgresql, so the service is >installed, bu wehn try to run: > >service postgresql start > >I receive: > >Initializing database: [FAILED] >Starting postgresql service: pg_ctl: no operation mode specified >Try "pg_ctl --help" for more information. >-sh: line 2: -p: command not found > >Anyway I just edit the postgresql file and see something anormal there I >think: > >export PGDATA=/var/lib/pgsql/data > >But my Postgresql data dir is /usr/local/pgsql/data. > >Can someone tell me what is going on? >Thanks. > > This is why you have to copy over the 'postgres' file in /etc/init.d cp contrib/start-scripts/linux /etc/init.d/postgres If you have properly installed postgres then the file that you are copying over from contrib/start-scripts/ will be properly configured with the correct environment variables. I would also recommend that you delete anything in your /var/lib/pgsql/ directory if you haven't already done so (after backing up any databases you may have). >----- Original Message ----- >From: "Ron St-Pierre" <rstpierre@syscor.com> >To: "Raul Secan" <raul@zerosoft.ro>; <pgsql-php@postgresql.org> >Sent: Thursday, March 18, 2004 5:57 PM >Subject: Re: [PHP] running postgresql as a linux service > > >Raul Secan wrote: > > > >>Hello, I have succesfuly installed PostgreSQL 7.4.1, on my OS which is >>Red Hat Linux 9.0. >> >>I start the server with: >>$ pg_ctl -D /usr/local/pgsql/data -l logfile start >> >>And stop it with: >>$ pg_ctl -D /usr/local/pgsql/data stop -m fast >> >>There are two questions here, which I want to put to you guys: >>1. How can make PostgreSQL run as a Linux service so database server >>starts at each reboot >> >> > >Below are the steps I use when I manually install PostgreSQL to have it >running when the server starts. However I don't use Red Hat, I use >Mandrake instead. You should be able to find the corresponding files on >your server if you know the installation directories for your >PostgreSQL, or use utilities like 'locate' or 'find' to find out where >they are installed. > ><start> > >*as root*: >- Configure the PostgreSQL SysV Script. This script is useful for >starting, stopping, and checking the status of PostgreSQL. > ># cd /usr/local/src/postgresql-7.x ># cp contrib/start-scripts/linux /etc/init.d/postgres ># chmod 755 /etc/init.d/postgres >.... then edit the file to specify the data directory, etc. and sets the >environment variabes (PGDATA etc). The file is well documented. If you >installed Postgres manually, it should have the correct values already set. > >- To have PostgreSQL start automatically when the computer boots add >symbolic links from the correct /etc/rc*.d/ directories to >/etc/init.d/postgres. If the normal runlevel is 3 then you really only >need to add it to rc3.d: > ># ln -s /etc/init.d/postgres /etc/rc2.d/S85postgres ># ln -s /etc/init.d/postgres /etc/rc3.d/S85postgres > >etc ... > >- Start PostgreSQL for the first time: > ># /etc/init.d/postgres start > ><\start> > > > >>2. How can I register the PGDATA environment variable, so I don't have >>to use -D /usr/local/pgsql/data parameter (and don't use -l logfile if >>it is posible) when run the start command >> >> >> > >If step 1. works correctly, the PGDATA variable is set properly. >Otherwise edit the /etc/init.d/postgres file. > > > >>Thanks, Raul Secan. >> >> > > >Ron > > > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster > > > >