Обсуждение: Postmaster not starting
Hi Bruce, some great steps forward. Actually postgres is called from postmaster and display's the usage() from postgres. I have compared it with older version's but can't see anything strange here. Postgres itself runs if called with a database. BTW how should I stop it. I have tried stop, exit, bye, quit, and halt. ^C worked! marliesle# su - postgres marliesle$ postmaster -i 2>&1 & [1] 15187 marliesle$ Usage: /usr/local/pgsql/bin/postgres [options] [dbname] -B buffers set number of buffers in buffer pool -C supress version info -D dir data directory -E echo query before execution -F turn off fsync -P port set port file descriptor -Q suppress informational messages -S buffers set amount of sort memory available -d [1|2|3] set debug level -e turn on European date format -o file send stdout and stderr to given filename -s show stats after each query -v version set protocol version being used by frontend [1]+ Exit 1 postmaster -i 2>&1 -Egon
On Tue, 9 Jun 1998, Egon Schmid wrote: > Hi Bruce, > some great steps forward. Actually postgres is called from postmaster > and display's the usage() from postgres. I have compared it with older > version's but can't see anything strange here. > > Postgres itself runs if called with a database. BTW how should I stop > it. I have tried stop, exit, bye, quit, and halt. ^C worked! > > marliesle# su - postgres > marliesle$ postmaster -i 2>&1 & > [1] 15187 > marliesle$ Usage: /usr/local/pgsql/bin/postgres [options] [dbname] > -B buffers set number of buffers in buffer pool > -C supress version info > -D dir data directory > -E echo query before execution > -F turn off fsync > -P port set port file descriptor > -Q suppress informational messages > -S buffers set amount of sort memory available > -d [1|2|3] set debug level > -e turn on European date format > -o file send stdout and stderr to given filename > -s show stats after each query > -v version set protocol version being used by frontend > [1]+ Exit 1 postmaster -i 2>&1 I start mine up with something like: #!/bin/tcsh setenv HOMEDIR /home/db ${HOMEDIR}/bin/postmaster -o "-F -o ${HOMEDIR}/errout" \ -i -p 5000 -D${HOMEDIR}/data & First thing I'd try is adding the -D<dir> switch so that postmaster knows where your databases are...
I added '-D /usr/local/pgsql/data' my first time I ever know. It worked! But this means that the environment variables (PGDATA) are ignored. The version I took was from 5:30am GMT (after Bruce's commit's to postmaster.c). -Egon On Tue, 9 Jun 1998, The Hermit Hacker wrote: > I start mine up with something like: > > #!/bin/tcsh > setenv HOMEDIR /home/db > ${HOMEDIR}/bin/postmaster -o "-F -o ${HOMEDIR}/errout" \ > -i -p 5000 -D${HOMEDIR}/data & > > First thing I'd try is adding the -D<dir> switch so that postmaster knows > where your databases are...
> > On Tue, 9 Jun 1998, Egon Schmid wrote: > > > Hi Bruce, > > some great steps forward. Actually postgres is called from postmaster > > and display's the usage() from postgres. I have compared it with older > > version's but can't see anything strange here. > > > > Postgres itself runs if called with a database. BTW how should I stop > > it. I have tried stop, exit, bye, quit, and halt. ^C worked! > > > > marliesle# su - postgres > > marliesle$ postmaster -i 2>&1 & > > [1] 15187 > > marliesle$ Usage: /usr/local/pgsql/bin/postgres [options] [dbname] > > -B buffers set number of buffers in buffer pool > > -C supress version info > > -D dir data directory > > -E echo query before execution > > -F turn off fsync > > -P port set port file descriptor > > -Q suppress informational messages > > -S buffers set amount of sort memory available > > -d [1|2|3] set debug level > > -e turn on European date format > > -o file send stdout and stderr to given filename > > -s show stats after each query > > -v version set protocol version being used by frontend > > [1]+ Exit 1 postmaster -i 2>&1 OK, I now realize it is still broken. Working on it now. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)
> > On Tue, 9 Jun 1998, Egon Schmid wrote: > > > Hi Bruce, > > some great steps forward. Actually postgres is called from postmaster > > and display's the usage() from postgres. I have compared it with older > > version's but can't see anything strange here. > > > > Postgres itself runs if called with a database. BTW how should I stop > > it. I have tried stop, exit, bye, quit, and halt. ^C worked! > > > > marliesle# su - postgres > > marliesle$ postmaster -i 2>&1 & > > [1] 15187 > > marliesle$ Usage: /usr/local/pgsql/bin/postgres [options] [dbname] > > -B buffers set number of buffers in buffer pool > > -C supress version info > > -D dir data directory > > -E echo query before execution > > -F turn off fsync > > -P port set port file descriptor > > -Q suppress informational messages > > -S buffers set amount of sort memory available > > -d [1|2|3] set debug level > > -e turn on European date format > > -o file send stdout and stderr to given filename > > -s show stats after each query > > -v version set protocol version being used by frontend > > [1]+ Exit 1 postmaster -i 2>&1 > > I start mine up with something like: OK, I have just made another fix for this. I missed some of the handling I needed. Please try again. Thanks. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)
> > I added '-D /usr/local/pgsql/data' my first time I ever know. It worked! > But this means that the environment variables (PGDATA) are ignored. The > version I took was from 5:30am GMT (after Bruce's commit's to > postmaster.c). > Still, the problem was that the exec() with three args fix was broken because it was exec'ing postgres, not postmaster. Fixed now. It worked because your addition of -D dir added the needed three args. It will work properly now. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)