Re: [PERFORM] Server Startup Error

[Richard Huxton]

Note - try to cc: the mailing list, I don't always read this inbox

Gauri Kanekar wrote:

On 2/26/07, Richard Huxton  wrote:


Gauri Kanekar wrote:
> Hi List,
>
> Machine was down due to some hardware problem.
>
> After then when i issue this command /usr/local/pgsql/bin/psql -l
> its giving me the following error
>
> psql: could not connect to server: No such file or directory
>Is the server running locally and accepting
>connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> Can anybody tell me what going wrong??

Well, it's either looking in the wrong place or the server isn't
actually running.

1. Do your startup scripts start PG?


Yes


OK - so we know it should have started, which means the logs should say 
something about our problem.



2. Is there a server process? "ps auxw | grep postgres"

This is the result given by the command
root  8907  0.0  0.1  37496  2640 ?Ss   03:47   0:00 sshd:
postgres [priv]
postgres  8910  0.0  0.0  37636  1684 ?S03:47   0:00 sshd:
[EMAIL PROTECTED]/1
postgres  8911  0.0  0.1  10152  2564 pts/1Ss+  03:47   0:00 -bash
root  9470  0.0  0.1  37500  2644 ?Ss   04:28   0:00 sshd:
postgres [priv]
postgres  9473  0.0  0.0  37640  1688 ?S04:28   0:00 sshd:
[EMAIL PROTECTED]/2
postgres  9474  0.0  0.1  10104  2412 pts/2Ss   04:28   0:00 -bash
postgres  9724  0.0  0.0   3496   892 pts/2R+   04:44   0:00 ps auxw
postgres  9725  0.0  0.0   3868   784 pts/2R+   04:44   0:00 grep
postgres


Hmm - nothing there but "ssh" connections. So, it's not started, which 
is why psql is complaining.



3. What do your logfiles say?


HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
LOG:  database system was interrupted at 2007-02-23 20:14:24 IST
LOG:  could not open file "pg_xlog/00010039001A" (log file 57,
segment 26): No such file or directory
LOG:  invalid primary checkpoint record
LOG:  could not open file "pg_xlog/000100390017" (log file 57,
segment 23): No such file or directory
LOG:  invalid secondary checkpoint record
PANIC:  could not locate a valid checkpoint record
LOG:  startup process (PID 9057) was terminated by signal 6
LOG:  aborting startup due to startup process failure
FATAL:  pre-existing shared memory block (key 5432001, ID 1900546) is still
in use
HINT:  If you're sure there are no old server processes still running,
remove the shared memory block with the command "ipcclean", "ipcrm", or 
just

delete the file "postmaster.pid".


OK - this last bit is the first thing to deal with. Find your 
postmaster.pid file and delete it. Your postmaster.pid file should be in 
your data directory - try "locate postmaster.pid" or "find /usr/local/ 
-name postmaster.pid".


Then restart postgresql (as root "/etc/init.d/postgresql start" or 
similar) and check the logs again.


--
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

   http://www.postgresql.org/about/donate

Re: [PERFORM] Server Startup Error

[Rodrigo Gonzalez]

Gauri Kanekar wrote:

Thanks,
But how to start postgres server

 
On 2/26/07, *Rodrigo Gonzalez* <[EMAIL PROTECTED] 
> wrote:


Gauri Kanekar wrote:
 > Hi List,
 >
 > Machine was down due to some hardware problem.
 >
 > After then when i issue this command /usr/local/pgsql/bin/psql -l
 > its giving me the following error
 >
 > psql: could not connect to server: No such file or directory
 > Is the server running locally and accepting
 > connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
 >
 > Can anybody tell me what going wrong??
 >
 > --
 > Regards
 > Gauri

Postgres is not running, start it and try again




--
Regards
Gauri


which OS?

compiled from source?

did you install from package?

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [PERFORM] Server Startup Error

[Richard Huxton]

Gauri Kanekar wrote:

Hi List,

Machine was down due to some hardware problem.

After then when i issue this command /usr/local/pgsql/bin/psql -l
its giving me the following error

psql: could not connect to server: No such file or directory
   Is the server running locally and accepting
   connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Can anybody tell me what going wrong??


Well, it's either looking in the wrong place or the server isn't 
actually running.


1. Do your startup scripts start PG?
2. Is there a server process? "ps auxw | grep postgres"
3. What do your logfiles say?

--
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org

Re: [PERFORM] Server Startup Error

[Gauri Kanekar]

Thanks,
But how to start postgres server


On 2/26/07, Rodrigo Gonzalez <[EMAIL PROTECTED]> wrote:


Gauri Kanekar wrote:
> Hi List,
>
> Machine was down due to some hardware problem.
>
> After then when i issue this command /usr/local/pgsql/bin/psql -l
> its giving me the following error
>
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> Can anybody tell me what going wrong??
>
> --
> Regards
> Gauri

Postgres is not running, start it and try again





--
Regards
Gauri

Re: [PERFORM] Server Startup Error

[Rodrigo Gonzalez]

Gauri Kanekar wrote:

Hi List,
 
Machine was down due to some hardware problem.
 
After then when i issue this command /usr/local/pgsql/bin/psql -l

its giving me the following error
 
psql: could not connect to server: No such file or directory

Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
 
Can anybody tell me what going wrong??


--
Regards
Gauri


Postgres is not running, start it and try again

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org