Thread: postgresql 7.3 will not start, no error message given

postgresql 7.3 will not start, no error message given

From
"Martin Matusiak"
Date:
> I tried installing postgre 7.3... Since the Gentoo distro I'm using is
> largely automated, there are config scripts to take care of copying the
> files to the right place and so on, the config is all default values. I
> should also mention it compiles all the software on the spot. So I
installed
> postgre but I can't seem to be able to start the server. Running
> /etc/init.d/postgresql start shows a fail code but no error message. Also,
> there are no logs, the path declared in the conf file at
> /etc/conf.d/postgresql (/var/lib/postgresql/data/postgresql.log) doesn't
> exist (file isn't there) so I've no idea how to retrieve the error
message.
>
>
> /etc/conf.d/postgresql....
>
> ===
>
> # PostgreSQL's Database Directory
> PGDATA=/var/lib/postgresql/data
>
> # Logfile path: (NOTE: This must be uid/gid owned by the value of
$PGUSER!)
> PGLOG=/var/lib/postgresql/data/postgresql.log
>
> # Run the PostgreSQL user as:
> PGUSER=postgres
>
> # Extra options to run postmaster with.
> # If you want to enable TCP/IP for PostgreSQL, add -i to the following:
> PGOPTS="-N 1024 -B 2048"
>
> ===
>
>
> /etc/init.d/postgresql...
>
> ===
>
> depend() {
>         need net
> }
>
> start() {
>         ebegin "Starting postgres"
>         su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA' -s -l
> '$PGLOG' -o '$PGOPTS'"
>         eend $?
> }
>
> stop () {
>         ebegin "Stopping postgres"
>         su - $PGUSER -c "/usr/bin/pg_ctl stop -D '$PGDATA' -s -m fast"
>         eend $?
> }
>
> svc_restart () {
>         ebegin "Restarting postgres"
>         su - $PGUSER -c "/usr/bin/pg_ctl restart -D '$PGDATA' -s -m
fast -l
> '$PGLOG' -o '$PGOPTS'"
>         eend $?
> }
>
> ===
>
> Running the command from the init file above on the command line gives no
> return value but it still doesn't start the server.
>
> I tried running /usr/bin/pg_ctl status -D '/var/lib/postgresql/data' and
it
> tells me the server isn't running but I still don't know why.
>
> $PGDATA and its subdir is owned by postgres:postgres. postgres has an
entry
> in /etc/passwd too.
>
> *help*
>
>
> Martin
>
> Ps. System is a Gentoo1.4, kernel 2.4.19 on a Pentium 166.
>
>
>



Re: postgresql 7.3 will not start, no error message given

From
Robert Treat
Date:
what does the output of /usr/bin/postmaster tell you?

Robert Treat

On Fri, 2003-02-14 at 03:25, Martin Matusiak wrote:
> > I tried installing postgre 7.3... Since the Gentoo distro I'm using is
> > largely automated, there are config scripts to take care of copying the
> > files to the right place and so on, the config is all default values. I
> > should also mention it compiles all the software on the spot. So I
> installed
> > postgre but I can't seem to be able to start the server. Running
> > /etc/init.d/postgresql start shows a fail code but no error message. Also,
> > there are no logs, the path declared in the conf file at
> > /etc/conf.d/postgresql (/var/lib/postgresql/data/postgresql.log) doesn't
> > exist (file isn't there) so I've no idea how to retrieve the error
> message.
> >
> >
> > /etc/conf.d/postgresql....
> >
> > ===
> >
> > # PostgreSQL's Database Directory
> > PGDATA=/var/lib/postgresql/data
> >
> > # Logfile path: (NOTE: This must be uid/gid owned by the value of
> $PGUSER!)
> > PGLOG=/var/lib/postgresql/data/postgresql.log
> >
> > # Run the PostgreSQL user as:
> > PGUSER=postgres
> >
> > # Extra options to run postmaster with.
> > # If you want to enable TCP/IP for PostgreSQL, add -i to the following:
> > PGOPTS="-N 1024 -B 2048"
> >
> > ===
> >
> >
> > /etc/init.d/postgresql...
> >
> > ===
> >
> > depend() {
> >         need net
> > }
> >
> > start() {
> >         ebegin "Starting postgres"
> >         su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA' -s -l
> > '$PGLOG' -o '$PGOPTS'"
> >         eend $?
> > }
> >
> > stop () {
> >         ebegin "Stopping postgres"
> >         su - $PGUSER -c "/usr/bin/pg_ctl stop -D '$PGDATA' -s -m fast"
> >         eend $?
> > }
> >
> > svc_restart () {
> >         ebegin "Restarting postgres"
> >         su - $PGUSER -c "/usr/bin/pg_ctl restart -D '$PGDATA' -s -m
> fast -l
> > '$PGLOG' -o '$PGOPTS'"
> >         eend $?
> > }
> >
> > ===
> >
> > Running the command from the init file above on the command line gives no
> > return value but it still doesn't start the server.
> >
> > I tried running /usr/bin/pg_ctl status -D '/var/lib/postgresql/data' and
> it
> > tells me the server isn't running but I still don't know why.
> >
> > $PGDATA and its subdir is owned by postgres:postgres. postgres has an
> entry
> > in /etc/passwd too.
> >
> > *help*
> >
> >
> > Martin
> >
> > Ps. System is a Gentoo1.4, kernel 2.4.19 on a Pentium 166.
> >
> >
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org