Обсуждение: Re: problems installing postgresql 8.0 on Mac OS

John DeSoi <desoi@pgedit.com> wrote:

> I think the easiest approach to get you started is to
> download and   install the startup item. Then reboot your
> computer. You won't need   to know the postgres user
> password to start the server and it will be   started
> automatically when your computer starts.
>
> http://sourceforge.net/project/showfiles.php?
> group_id=133151&package_id=147282

Hello John,

OK, it installed fine, restarted fine, but postgres does not
appear in Activity
Monitor. I can't use Creat User in the Client tools (or any
other tool). It says:

Database connection failed:
could not connect to server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

pgAdmin III likewise can't connect to the postgres server.

Cheers!

Joe

On Jun 11, 2007, at 11:41 PM, Joe Barwell wrote:

> OK, it installed fine, restarted fine, but postgres does not
> appear in Activity
> Monitor. I can't use Creat User in the Client tools (or any
> other tool). It says:
>
> Database connection failed:
> could not connect to server: Connection refused
> Is the server running on host "localhost" and accepting
> TCP/IP connections on port 5432?

See if there is an error message in the console log (/Applications/
Utilities/Console). The startup command was:

su -m postgres -c '/Library/PostgreSQL8/bin/pg_ctl start -D /Library/
PostgreSQL8/data -l /Library/PostgreSQL8/log/PostgreSQL8.log -o -i'

Is there a valid cluster created in /Library/PostgreSQL8/data? You
should also be able find what went wrong by looking in the PostgreSQL
log file which is the path specified by -l above.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL