Re: Starting Postmaster - Mailing list pgsql-novice
From | radha.manohar@ndsu.nodak.edu |
---|---|
Subject | Re: Starting Postmaster |
Date | |
Msg-id | 1051542800.3ead4510e6cfc@webmail.ndsu.NoDak.edu Whole thread Raw |
Responses |
Re: Starting Postmaster
(Tom Lane <tgl@sss.pgh.pa.us>)
|
List | pgsql-novice |
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
pgsql-novice by date: