run this in the command line
locate postmaster.pid
or
find / -name "postmaster.pid" -print
that should locate any postmaster files and then remove whatever
looks like the postmaster.pif file
Thank you! I found postmaster.pid in usr/local/pgsql/data. I deleted
the whole pgsql directory and installed postgres again using the
following commands:
./configure
make
sudo make install
sudo mkdir /usr/local/pgsql/data
sudo chown postgres /usr/local/pgsql/data
su postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
When I then try to start the PosrgreSQL-server via
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
the terminal gets "stuck" (i.e. no prompt appears ) after six lines
of output:
LOG: database system was shut down at 2007-07-25 09:38:00 CEST
LOG: checkpoint record is at 0/42C258
LOG: redo record is at 0/42C258; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/593; next OID: 10820
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
There is no explicit error message. What can be wrong?
What directory do I have to cd to in order to execute "/usr/local/
pgsql/bin/postgres -D /usr/local/pgsql/data"?
Did I omit an important step?
Thanks for your ideas!
Christoph
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend