Thanks for your replies.... I'll try the script. I solve the problem by reading pgsql-novice lists archives.
Thanks Burak ----- Original Message ----- From: "Rob Finneran" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 8:22 AM Subject: RE: Postgres Problem > 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 > _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list