[FUGSPBR] Postgresql

[Johnny Johnny]

Agradeco a ajuda de todos.
O pgsql já esta rodando.

[ ]'s


>eu tenho este postgres.sh
>
>#! /bin/sh
>
># Permissao do Arquivo postgres.log
>chown postgres /var/log/postgres.log
>
># 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/server.log"
>PGLOG="/var/log/postgres.log"
>
>## 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: "Johnny Johnny" <johnnyuba em hotmail.com>
>To: <fugspbr em fugspbr.org>
>Sent: Monday, September 15, 2003 5:36 PM
>Subject: Re: [FUGSPBR] Postgresql
>
>
> >
> > Olá,
> >
> > Estou usando a versao 7.3.2
> >
> > Estou iniciando ele da seguinte maneira:
> > su pgsql -c '/usr/local/bin/pg_ctl -D /usr/local/pgsql/data start'
> >
> > postmaster successfully started
> > # FATAL:  File /usr/local/pgsql/data/PG_VERSION is missing. This is not 
>a
>
> > valid data directory.
> >
> > O diretorio data já está com as devidas permissoes como manda a doc.
> >
> > [ ]'s
> >
> > >----- Original Message -----
> > >From: "Johnny Johnny" <johnnyuba em hotmail.com>
> > >To: <fugspbr em fugspbr.org>
> > >Sent: Monday, September 15, 2003 2:46 PM
> > >Subject: [FUGSPBR] Postgresql
> > >
> > >
> > > > Olá instalei o postgresql mas estou tomando um coro p/ iniciar ele.
>Ele
> > > > criou um script no rc.d mas quando eu tento dar um start nele ele me
> > >retorna
> > > >
> > > > pg_ctl: postmaster does not start
> > > >
> > > > pelo pg_ctl na unha tb ta o mesmo erro
> > > >
> > > > Alguem já passou por isso ???
> > > >
> > > > [ ]'s
> > > >
> > > > _________________________________________________________________
> > > > MSN Hotmail, o maior webmail do Brasil.  http://www.hotmail.com
> > > >
> > > > _______________________________________________________________
> > > > Sair da Lista: http://www2.fugspbr.org/mailman/listinfo/fugspbr
> > > > Historico: http://www4.fugspbr.org/lista/html/FUG-BR/
> > > >
> > >
> >
> > _________________________________________________________________
> > MSN Hotmail, o maior webmail do Brasil.  http://www.hotmail.com
> >
> > _______________________________________________________________
> > Sair da Lista: http://www2.fugspbr.org/mailman/listinfo/fugspbr
> > Historico: http://www4.fugspbr.org/lista/html/FUG-BR/
> >
> >
>
>
>_______________________________________________________________
>Sair da Lista: http://www2.fugspbr.org/mailman/listinfo/fugspbr
>Historico: http://www4.fugspbr.org/lista/html/FUG-BR/

_________________________________________________________________
MSN Hotmail, o maior webmail do Brasil.  http://www.hotmail.com

_______________________________________________________________
Sair da Lista: http://www2.fugspbr.org/mailman/listinfo/fugspbr
Historico: http://www4.fugspbr.org/lista/html/FUG-BR/