All I can tell you, based on this information, Nitin, is that your
postmaster is not started, and it is failing to start for some
reason. Without any additional information, there is absolutely
nothing I can tell you. Try listing the /var/lib/pgsql/data folder.
Verify that it does exist and that it does contain the postgres
configuration files, at least.
I don't have time to teach you everything you need to know to
administer a Un*x system or to be a DBA. If you were encountering a
specific error, I'm sure someone could help you isolate it. However,
this is the bugs list, as I pointed out before, it is not the correct
list for determining how to configure your server. Once you get the
server started, you should be able to dump your database and upgrade
your software.
On Aug 18, 2007, at 12:40 PM, Nitin Saxena wrote:
Sir ,
plz reply
regards:
nitin
On 8/18/07, Nitin Saxena <[EMAIL PROTECTED]> wrote:
Dear Sir,
please find the attached file.:
This error is of boot.log file which i had attach with mail
Aug 18 13:33:19 imap postgresql: Starting postgresql service: failed
Aug 18 13:39:21 imap postgresql: postmaster shutdown failed
Aug 18 13:39:23 imap postgresql: Checking postgresql installation:
succeeded
Aug 18 13:39:25 imap postgresql: Starting postgresql service: failed
Aug 18 13:41:44 imap postgresql: postmaster shutdown failed
Aug 18 13:41:46 imap postgresql: Checking postgresql installation:
succeeded
Aug 18 13:41:48 imap postgresql: Starting postgresql service: failed
Aug 18 13:49:01 imap postgresql: postmaster shutdown failed
Aug 18 13:49:03 imap postgresql: Checking postgresql installation:
succeeded
Aug 18 13:49:05 imap postgresql: Starting postgresql service: failed
Aug 18 14:44:56 imap postgresql: postmaster shutdown failed
Aug 18 14:44:58 imap postgresql: Checking postgresql installation:
succeeded
Aug 18 14:45:00 imap postgresql: Starting postgresql service: failed
output of different commands
[EMAIL PROTECTED] /]# pg_ctl status
/usr/bin/pg_ctl: [: -lt: unary operator expected
pg_ctl: postmaster is running (pid: )
options are:
/usr/bin/postmaster
-p 5432
-D /var/lib/pgsql/data
-B 64
-b /usr/bin/postgres
-i
-N 32
[EMAIL PROTECTED] /]# pg_ctl stop
/usr/bin/pg_ctl: [: -lt: unary operator expected
kill: usage: kill [-s sigspec | -n signum | -sigspec] [pid |
job]... or kill -l [sigspec]
postmaster successfully shut down.
[EMAIL PROTECTED] /]# pg_ctl start
pg_ctl: It seems another postmaster is running. Try to start
postmaster anyway.
pg_ctl: Cannot start postmaster. Is another postmaster is running?
I dont have postgresql.conf file in any of my directory
I had only pg_hba.conf file.
My application was working fine till yesterday.
plzz help
Regards:
Nitin Saxena
On 8/18/07, Douglas Toltzman <[EMAIL PROTECTED] > wrote:
At this point, I'd have to have more information to be able to tell
you what to fix. Does the server give any reason why it fails to
start? There could be a configuration error or a permissions error
on one of the database configuration files. Does the server give a
detailed error message? Check your error logs, also, for clues.
On Aug 18, 2007, at 11:45 AM, Nitin Saxena wrote:
Hi,
I have done it on my system
drwxrwxrwt 2 root root 4096 Aug 18 19:06 tmp
still getting the same error.
[EMAIL PROTECTED] /]# /etc/rc.d/init.d/postgresql restart
Stopping postgresql service: FAILED]
Checking postgresql installation: OK ]
Starting postgresql service: FAILED]
Now what to do sir?
looking forward for your support.
Regards
Nitin
On 8/18/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
"Douglas Toltzman" <[EMAIL PROTECTED]> writes:
> In any case, the server specifically calls out an error creating
> "/tmp/.s.PGSQL.5432". I would start by creating a world-
writable /tmp
> folder.
FWIW the correct permissions for /tmp on Unix machines is 1777. It
should look
like this (note the "t" in place of the last "x"):
$ ls -ld /tmp
drwxrwxrwt 8 root root 12288 Aug 18 16:30 /tmp
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
--
NItin Saxena
Douglas Toltzman
[EMAIL PROTECTED]
(910) 526-5938
--
NItin Saxena
--
NItin Saxena
Douglas Toltzman
[EMAIL PROTECTED]
(910) 526-5938
