On Wed, Aug 28, 2002 at 06:50:17AM -0700, Merlita Maricuelo wrote:
> Then I entered $initdb -D /usr/local/pgsql/data hoping to fix the
> problem. It didn't. I'm not sure what to do?
>
> BTW, I am using Postresql in Linux RH 7.3.
As root,
# /etc/rc.d/init.d/postgresql start
If this doesn't work, check your system logs (/var/log/syslog or
/var/log/messages) and check if there's anything that can explain why
the PostgreSQL daemon is not starting up.
> Here's the error I received: "Warning: Unable to connect to PostgreSQL
> server: 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"? in
> /var/www/html/php_session_files/postgresql_sessions.inc on line 4
> Can't connect to the database"
This sounds like your PostgreSQL daemon isn't running.
Or ...
I don't have a RedHat box so I can't verify, but on Debian the Unix
domain socket of PostgreSQL is not in /tmp but in /var/run/postgresql.
Your software (PHP, in this case) will need to be configured to know
where to look for the Unix domain socket if it's not where it should be.
If your PostgreSQL master is running but does not put its Unix domain
socket "file" in /tmp then you'll need to work this reconfiguration of
PHP out.
--> Jijo
--
Federico Sevilla III : http://jijo.free.net.ph
Network Administrator : The Leather Collection, Inc.
GnuPG Key ID : 0x93B746BE
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
