pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Raul Secan <raul@zerosoft.ro>
To: Ron St-Pierre <rstpierre@syscor.com>
To: pgsql-php@postgresql.org
Subject: Re: running postgresql as a linux service
Date: Fri, 19 Mar 2004 11:49:36 +0200
Message-ID: <006b01c40d97$7d6106b0$0a10a8c0@zerosoft.ro> (raw)
References: <001b01c40cfc$c6af5dd0$0a10a8c0@zerosoft.ro>
	<4059C6D5.3010201@syscor.com>

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.

----- 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




view thread (7+ messages)  latest in thread

Message-ID: <006b01c40d97$7d6106b0$0a10a8c0@zerosoft.ro>
Permalink:  ../006b01c40d97$7d6106b0$0a10a8c0@zerosoft.ro/
Also on:    postgresql.org/message-id/006b01c40d97$7d6106b0$0a10a8c0@zerosoft.ro

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: raul@zerosoft.ro, rstpierre@syscor.com
  Subject: Re: running postgresql as a linux service
  In-Reply-To: <006b01c40d97$7d6106b0$0a10a8c0@zerosoft.ro>
  References: <001b01c40cfc$c6af5dd0$0a10a8c0@zerosoft.ro> <4059C6D5.3010201@syscor.com> <006b01c40d97$7d6106b0$0a10a8c0@zerosoft.ro>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox