By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,372 Members | 1,950 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,372 IT Pros & Developers. It's quick & easy.

Error since powerouttage

P: n/a
Running a RH 9 system with postgres 7.3.2-3

I come back after vacation and my system shutdown cause of a powerouttage on
the block.

I restart and i get this trying to access the database:
"Warning: pg_connect() unable to connect to PostgreSQL server: could not
connect to server: Connection refused Is the server running on host
database.lhasi.org and accepting TCP/IP connections on port 5432? in
/var/www/html/dealingwithcrohns/phpBB2/db/postgres7.php on line 79
phpBB : Critical Error

Could not connect to the database"
If someone could help me that be great.

I don't believe I saw postgres start on startup...but don't I have to start
it by the pgsql user?

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

http://archives.postgresql.org

Nov 22 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Tue, Jan 13, 2004 at 14:08:14 -0500,
"Daniel E. Fisher" <da*******@bwkip.com> wrote:
Running a RH 9 system with postgres 7.3.2-3

I come back after vacation and my system shutdown cause of a powerouttage on
the block.

I restart and i get this trying to access the database:
"Warning: pg_connect() unable to connect to PostgreSQL server: could not
connect to server: Connection refused Is the server running on host
database.lhasi.org and accepting TCP/IP connections on port 5432? in
/var/www/html/dealingwithcrohns/phpBB2/db/postgres7.php on line 79
phpBB : Critical Error

Could not connect to the database"
If someone could help me that be great.

I don't believe I saw postgres start on startup...but don't I have to start
it by the pgsql user?

-Dan


What might have happened is that some other service started during the reboot
that was previously used by the postgres postmaster before the outage.
This would prevent postgres from starting up.

You can avoid this by removing the pid file on reboot, but you want to make
sure that this only gets done on reboots, not service level changes or
you may end up with two postmasters running and trash your database.

The init script for postgres should handle starting it as the correct user.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #2

P: n/a
On Tue, Jan 13, 2004 at 14:50:25 -0500,
"Daniel E. Fisher" <da*******@bwkip.com> wrote:
Well...
Its a good idea to keep these discussions on list, so that other people
can contribute.

I removed the pid from here /var/lib/pgsql/data/
rebooted
I did see postgresql start this time but still getting that error
Was this the first time it was started by the start up script?
One possibility is that it is only listening on domain sockets or
on some other socket than 5432. But if this is the case now, I would
wonder how it worked previously. Unless you manually started it correctly.

-Dan

-----Original Message-----
From: Bruno Wolff III [mailto:br***@wolff.to]
Sent: Tuesday, January 13, 2004 2:26 PM
To: Daniel E. Fisher
Cc: PGSQL List
Subject: Re: [GENERAL] Error since powerouttage
On Tue, Jan 13, 2004 at 14:08:14 -0500,
"Daniel E. Fisher" <da*******@bwkip.com> wrote:
Running a RH 9 system with postgres 7.3.2-3

I come back after vacation and my system shutdown cause of a powerouttage

on
the block.

I restart and i get this trying to access the database:
"Warning: pg_connect() unable to connect to PostgreSQL server: could not
connect to server: Connection refused Is the server running on host
database.lhasi.org and accepting TCP/IP connections on port 5432? in
/var/www/html/dealingwithcrohns/phpBB2/db/postgres7.php on line 79
phpBB : Critical Error

Could not connect to the database"
If someone could help me that be great.

I don't believe I saw postgres start on startup...but don't I have to

start
it by the pgsql user?

-Dan


What might have happened is that some other service started during the
reboot
that was previously used by the postgres postmaster before the outage.
This would prevent postgres from starting up.

You can avoid this by removing the pid file on reboot, but you want to make
sure that this only gets done on reboots, not service level changes or
you may end up with two postmasters running and trash your database.

The init script for postgres should handle starting it as the correct user.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.