First of all, thanks Tom for your information regarding memory contexts
Now, I have a problem.
I had set the debug option on in the postgres.conf file.
Now, when I start the Postmaster, I get the following: (I have copied
the screen dump here)
-----------------------screen dump starts-----------------------------
manohar@midas-05:~/postgresql-7.3$$HOME/pgsql/bin/pg_ctl -D
$HOME/pgsql/data st
art
postmaster successfully started
manohar@midas-05:~/postgresql-7.3$
DEBUG: /home/manohar/pgsql/bin/postmaster: P
ostmasterMain: initial environ dump:
DEBUG: -----------------------------------------
DEBUG: PWD=/home/manohar/postgresql-7.3
DEBUG: MANPATH=/home/manohar/pgsql/man:
DEBUG: USER=manohar
DEBUG: MAIL=/var/mail/manohar
DEBUG: LANG=C
DEBUG: SSH_CLIENT=134.129.89.1 52738 22
DEBUG: LOGNAME=manohar
DEBUG: SHLVL=2
DEBUG: SHELL=/bin/bash
DEBUG: HOME=/home/manohar
DEBUG: TERM=vt100
DEBUG: PGDATA=/home/manohar/pgsql/data
DEBUG:
PATH=/home/manohar/pgsql/bin:/usr/local/bin:/usr/bin:/bin:/usr/b
in/X11:/usr/games
DEBUG: SSH_TTY=/dev/pts/0
DEBUG: _=/home/manohar/pgsql/bin/postmaster
DEBUG: -----------------------------------------
DEBUG: FindExec: found "/home/manohar/pgsql/bin/postgres" using argv
[0]
DEBUG: invoking IpcMemoryCreate(size=1417216)
DEBUG: FindExec: found "/home/manohar/pgsql/bin/postmaster" using argv
[0]
LOG: database system was shut down at 2003-04-25 12:05:51 CDT
LOG: checkpoint record is at 0/7CB074
LOG: redo record is at 0/7CB074; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 574; next oid: 16892
LOG: database system is ready
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
----------------------------------screen dump ends--------------------
I don't know why this is happening. Also, I am not able to use psql
(the interactive application to enter SQL commands).
The main thing I would like to say here is that postgres is installed
in my home directory not in the root, as I don't have permission to
access root directory. Also, this is because, I am going to be the
sole user of postgres. That is why, I installed it in my home
directory.
Please provide a solution to this problem. Your solution to this
problem will be very much appreciated and will be of great help to me.
Thanks in advance.
Regards,
Radha Manohar