January 6th, 2004, 12:27 AM
please tell me how do i start postgresql
during the startup the postmaster tries to start and fails
it is a redhatlinux machine and it is the server
i have my own userid and passwd
i tried starting it using
but gives an error as file not found
the postgress is installed in the system already
Last edited by kavya; January 6th, 2004 at 04:08 AM.
January 6th, 2004, 10:24 AM
I use pg_ctl to start postgres. You can specify a log filename with the -l option.
pg_ctl -l /usr/local/pgsql/logfile.txt start
Try this, and then look at the contents of logfile.txt. If there's an error at the end of the log file, post it here and I'll try to help.
January 6th, 2004, 12:57 PM
did U do the initdb step?
January 6th, 2004, 11:20 PM
hai thax for the reply
i tried using the
pg_ctl -l /usr/bin/postgreql/lib/logfile.txt start
but the error i get is
bash : pg_ctl : command not found
and bash : initdb :command not found
please reply for this
January 7th, 2004, 12:14 AM
You need to find out where these files are. Assuming you're using Unix, try
find / -name pg_ctl
Those files are in /usr/local/pgsql/bin on my computer. Once you know where they are, add their directory to your PATH variable. For instance, using my postgres directory:
Now you should be able to use initdb. Let us know if this works.
January 7th, 2004, 12:54 AM
thanx for the reply
i tried them as follows
1. locate pg_ctl
gave the following o/p
locate:warning:database 'var/lib/locate/locatedb' is more than 8 days old
2. export PATH=$PATH:/usr/lib/postgresql/bin
gave the following message
initdb: you must identify where the data for this database system will reside. do this with either a -D invocation option or a PGDATA environment variable
January 7th, 2004, 07:46 AM
Okay, there's a manual section for what you're doing. It clearly states two solutions to make the initdb command work. If you keep reading, it will tell you how to get Postgres working.
The manual isn't fantastic, but taking the time to read it before you post a question will save you time.
January 8th, 2004, 05:23 AM
thanx for the link
November 28th, 2012, 11:26 AM
Running INITDB command
I installed PostgresSQL 9.2 on Windows XP and want to run INITDB command. In order to run the command I opened and logged on SQL Shell and am at the command prompt 'postgres-#'. What should I type to run it?