Anothony is right.
Here's a startup script that you might find useful:
#! /bin/sh
#
# chkconfig: 2345 97 02
# description: PostgreSQL Database Server
# processname: postmaster
# pidfile: /usr/local/pgsql/data/postmaster.pid
#
# This is an example of a start/stop script for SysV-style init, such
# as is used on Linux systems. You should edit some of the variables
# and maybe the 'echo' commands.
#
# Place this file at /etc/init.d/postgresql (or
# /etc/rc.d/init.d/postgresql) and make symlinks to
# /etc/rc.d/rc0.d/K02postgresql
# /etc/rc.d/rc1.d/K02postgresql
# /etc/rc.d/rc2.d/K02postgresql
# /etc/rc.d/rc3.d/S98postgresql
# /etc/rc.d/rc4.d/S98postgresql
# /etc/rc.d/rc5.d/S98postgresql
# Or check out the chkconfig program, if you have it.
#
# Proper init scripts on Linux systems normally require setting lock
# and pid files under /var/run as well as reacting to network
# settings, so you should treat this with care.
# Original author: Ryan Kirkpatrick <[EMAIL PROTECTED]>
# $Header: /home/projects/pgsql/cvsroot/pgsql/contrib/start-scripts/linux,v
1.2 2001/04/19 19:17:44 petere Exp $
## EDIT FROM HERE
# Installation prefix
prefix=/usr/local/pgsql
# Data directory
PGDATA="/usr/local/pgsql/data"
# Who to run pg_ctl as, should be "postgres".
PGUSER=postgres
# Where to keep a log file
PGLOG="$PGDATA/serverlog"
## STOP EDITING HERE
# Check for echo -n vs echo \c
if echo '\c' | grep -s c >/dev/null 2>&1 ; then
ECHO_N="echo -n"
ECHO_C=""
else
ECHO_N="echo"
ECHO_C='\c'
fi
# The path that is to be used for the script
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
# What to use to start up the postmaster
DAEMON="$prefix/bin/pg_ctl"
set -e
# Only start if we can find pg_ctl.
test -f $DAEMON || exit 0
# Parse command line parameters.
case $1 in
start)
$ECHO_N "Starting PostgreSQL: "$ECHO_C
su - $PGUSER -c "$DAEMON start -o "-i" -D '$PGDATA' -s -l $PGLOG"
echo "ok"
;;
stop)
echo -n "Stopping PostgreSQL: "
su - $PGUSER -c "$DAEMON stop -D '$PGDATA' -s -m fast"
echo "ok"
;;
restart)
echo -n "Restarting PostgreSQL: "
su - $PGUSER -c "$DAEMON restart -D '$PGDATA' -s -m fast"
echo "ok"
;;
status)
su - $PGUSER -c "$DAEMON status -D '$PGDATA'"
;;
*)
# Print help
echo "Usage: $0 {start|stop|restart|status}" 1>&2
exit 1
;;
esac
exit 0
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Anthony E. Greene
Sent: Thursday, February 07, 2002 5:38 PM
To: [EMAIL PROTECTED]
Subject: Re: Postgres Problem
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Thu, 7 Feb 2002, [iso-8859-9] Burak ÖZLER wrote:
>I'm trying to implement an e-biz solution with PHP + PostgreSQL. I
>get the i-386 ISO's of enigma & installed it. We are using a Debian
>2.2 (Our ISP provide it) gateway for Internet access. When we are
>trying to work with PGSQL we can't connect it except connecting
>locally.
Look into the script that starts PostgreSQL and add teh "-i" option.
>Which list should I ask this kind of problems?
One of the mailing lists available from postgresql.org.
Tony
- --
Anthony E. Greene <[EMAIL PROTECTED]> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
Chat: AOL/Yahoo: TonyG05
Linux. The choice of a GNU generation <http://www.linux.org/>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Anthony E. Greene <[EMAIL PROTECTED]> 0x6C94239D
iD8DBQE8YywLpCpg3WyUI50RAsx1AJ9QVa5DY9Slfr5VfQI68qAd8LrRNQCfcijX
MN2PIKZxy3FknRzfL7Uv6rM=
=DlhF
-----END PGP SIGNATURE-----
_______________________________________________
Redhat-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-list
_______________________________________________
Redhat-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-list
