X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 77CA09DCC80 for ; Thu, 16 Feb 2006 14:21:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51354-04 for ; Thu, 16 Feb 2006 14:21:36 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id C5A3F9DC9B8 for ; Thu, 16 Feb 2006 14:21:34 -0400 (AST) Received: from genetics.utah.edu (m.genetics.utah.edu [155.101.150.49]) by svr4.postgresql.org (Postfix) with ESMTP id 50F945AF066 for ; Thu, 16 Feb 2006 18:21:35 +0000 (GMT) Received: from [155.101.150.155] ([155.101.150.155]) by genetics.utah.edu with Microsoft SMTPSVC(6.0.3790.1830); Thu, 16 Feb 2006 11:22:25 -0700 Mime-Version: 1.0 (Apple Message framework v746.2) Content-Transfer-Encoding: 7bit Message-Id: <3DAF6869-77A4-4B3F-ADCF-DBF36ACA5E41@genetics.utah.edu> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-admin@postgresql.org From: Barry Moore Subject: Trouble starting server Date: Thu, 16 Feb 2006 11:23:21 -0700 X-Mailer: Apple Mail (2.746.2) X-OriginalArrivalTime: 16 Feb 2006 18:22:25.0830 (UTC) FILETIME=[EFE66C60:01C63325] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/200 X-Sequence-Number: 20621 I have a PostgreSQL 7.4.8 installation running on RedHat Enterprise 4 that I've been using for some time now, and haven't had any trouble with. Recently the system went down, and now I can't seem to restart it. I've tried running these commands as postgres user: nohup postmaster -D /var/lib/pgsql/data > /var/lib/pgsql/logfile 2>&1 & and pg_ctl start -D /var/lib/pgsql/data -l /var/lib/pgsql/logfile and they both reply that the 'postmaster successfully started', but then in the logfile I find 'FATAL: could not create lock file "/ tmp/.s.PGSQL.5432.lock": Permission denied'. And if I try to run psql I get: 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"? So with my minimal system admin skills I'm guessing that '/ tmp/.s.PGSQL.5432' is lock file where the system puts a lock on port 5432 for postmaster to listen, but the pg_ctl and postmaster commands can't create that file because /tmp is writeable only by root (drwxr- xr-x 11 root root 4096 Feb 16 11:06 tmp). Of course I can't start the postmaster as root, so I'm a bit perplexed as to what to do, and why I never had this problem before. Any suggestions. Barry