Skip site navigation (1) Skip section navigation (2)

Re: BUG #1156: Database is not initializing

From: Mr sangameswar m <sangameswarm(at)yahoo(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Subject: Re: BUG #1156: Database is not initializing
Date: 2004-05-27 13:56:09
Message-ID: 20040527135609.33611.qmail@web50408.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello Sir,

The following error is comming when i want to get into
the database.
$./psql
psql: connectDBStart() -- connect() failed: No such
file or directory
        Is the postmaster running locally
        and accepting connections on Unix socket
'/tmp/.s.PGSQL.5432'?

if i type the following command i am getting the
following :
$ pg_ctl status -D /home1/market/postgres/data
pg_ctl: postmaster is running (pid: 1295)
Command line was:
/home1/market/postgres/postgresql-7.2.3/bin/postmaster
'-i' '-D' '/home1/market/postgres/data'

when i type following command then this error is
comming:
$ createdb stu
psql: connectDBStart() -- connect() failed: No such
file or directory
        Is the postmaster running locally
        and accepting connections on Unix socket
'/tmp/.s.PGSQL.5432'?
createdb: database creation failed
If type another command like this then :

$pg_ctl start -D /home1/market/postgres/data
pg_ctl: Another postmaster may be running.  Trying to
start postmaster anyway.
Lock file "/home1/market/postgres/data/postmaster.pid"
already exists.
Is another postmaster (pid 1295) running in
"/home1/market/postgres/data"?
pg_ctl: cannot start postmaster
Examine the log output.

I had examined the output then following is there

Lock file "/home1/market/postgres/data/postmaster.pid"
already exists.
Is another postmaster (pid 1295) running in
"/home1/market/postgres/data"?

--- Richard Huxton <dev(at)archonet(dot)com> wrote:
> Mr sangameswar m wrote:
> > Hello sir, 
> >    How can i initialize the postmaster server.
> Some
> > given hint that the Postmaster server is down. How
> can
> > i know where the data base directory is stored.
> Can
> > you give me any hints about it.
> 
> If Postgresql was installed via RPM then you can see
> what it is doing by 
> using the standard command (the # mark means to run
> as root):
>   # service postgresql status
> To start the service you should run:
>   # service postgresql start
> If you need to restart the server (e.g. because of
> configuration changes)
>   # service postgresql restart
> The standard /etc/rc.d/... files can be used to
> automatically start/stop 
> the server along with your redhat server.
> 
> If you installed from source, the quickest way might
> be:
>   # ps auxw | grep postgres
> 
> If you don't see any error messages on starting the
> server, your files 
> are probably in /var/lib/pgsql/...
> Documentation (if installed) will probably be in 
> /usr/share/doc/postgresql-7.2.3/ and your logging
> should occur in /var/log/
> 
> You will then want to read the manuals regarding
> installation and 
> administration, particularly "client authentication"
> (tip - you will 
> want to set local to trust while you get things
> working).
> 
> The main website has the manuals:
>    http://www.postgresql.org/
> It also has links for the odbc/jdbc/etc drivers
> 
> There are some more user-written materials here:
>    http://techdocs.postgresql.org/
> You will also find online books linked from here.
> 
> There are a number of mailing lists described at the
> page below. Can I 
> suggest the novice or general lists?
>    http://www.postgresql.org/lists/
> 
> Finally, a good book on linux might be useful. I
> liked the O'Reilly book 
> "Running Linux" but you may find a redhat-specific
> one more use.
> 
> Best of luck, see you on the mailing lists.
> 
> -- 
>    Richard Huxton
>    Archonet Ltd



	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 

pgsql-bugs by date

Next:From: PostgreSQL Bugs ListDate: 2004-05-30 21:23:32
Subject: BUG #1158: tsearch2 trigger crashes machine
Previous:From: Martin PittDate: 2004-05-27 07:53:50
Subject: Re: Fwd: Bug#249083: postgresql: Postgres SIGSEGV if wins in nsswitch.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group