I give up PLEASE help

holek · Posted: Mon Jun 02, 2003 8:28 pm Post subject: I give up PLEASE help

I've got this problem with postgresql:

I emerged it and everything went fine, then I did this ebuild /var/db/..../postgres-7.3.2.ebuild config
It went good too.
I've added postgresql to default runlevel ok also.
postgres starts fine [ OK ]
BUT it did not start really !
when I execute netstat -lt there is no postgresql listening

I don't know what else to do.
I tried to find an answer, and yes a lot of people had this, but only when they had /bin/false in /etc/passwd, I've got /bin/bash so it's not it.

If somebody have a clue please help.
_________________
... and the aliens sent an android down to earth, to slow down mankind's development ... and they named it Bill Gates.

incubus · n00b Joined: 12 Dec 2002 Posts: 20 Location: Sheffield, UK

Hi there,

I don't know much about pgsql... have you tried looking at the logs? If I get similar behaviour with apache I always check /var/log/apache/error_log. Does pgsql have something similar?

Cheers,
incubus
_________________
Drink like it's payday

holek · Posted: Mon Jun 02, 2003 8:43 pm Post subject:

logs give me no error at all it's just a standard:
"database system is ready" and such.

_________________
... and the aliens sent an android down to earth, to slow down mankind's development ... and they named it Bill Gates.

holek · Posted: Mon Jun 02, 2003 9:01 pm Post subject:

I also noticed that it starts really fast (to fast i would say).
when I tun pg_ctl by myself it's also the same

Oh also there are processes running (postmaster) so I don't know what is it really

Looks like the postgresql is broken or something

Maybe I'm missing something obvious here, maybe some more configuration should be made ?
_________________
... and the aliens sent an android down to earth, to slow down mankind's development ... and they named it Bill Gates.

H0bb3z · Posted: Mon Jun 02, 2003 9:12 pm Post subject:

If you run a process list (like 'ps -aux' or similar), does the postgresql daemon show up somewhere? If it does, it may indeed be running, but you may need to specifically configure it to listen on a port.

I usually do a 'netstat -an |grep LISTEN' to see what's going on (in case there is a listener open on a stream instead of a specific TCP or UDP port)

If you can't find the pgsql process running anywhere, you may need to try starting it with a few debug options to see if it will spit out some better info when you attempt to start it. You may try to start it manually from a command prompt and pass it parameters to enable debug messages. It should output to the screen instead of a log file.
_________________
-H0bb3z-
-----------
Intel QX9770 | 6Gb DDR3 | ATI 4870 HD 1Gb | 2xSeagate 1Tb SATAs
Running Funtoo Core2 build

holek · Posted: Mon Jun 02, 2003 10:10 pm Post subject:

ok maybe we're getting somewhere

when I did 'netstat -an |grep LISTEN' I have one interesting line :

holek · Posted: Mon Jun 02, 2003 10:18 pm Post subject:

Doh

I just realized that it could mean that server is running only locally, or am I wrong again

And where should I set it to run on a tcp port ?
I cannot connect to a pgsql from PHP because I have to pass a port to pg_connect(). BUT the postgresql is running, I mean I can create datebases and stuff. This is truly weird

_________________
... and the aliens sent an android down to earth, to slow down mankind's development ... and they named it Bill Gates.

H0bb3z · Posted: Mon Jun 02, 2003 10:30 pm Post subject:

Ah yes -- here's what I found on google groups:

holek · Posted: Mon Jun 02, 2003 10:38 pm Post subject:

Worked

A minute before u post your answer I found that the line:

handsomepete · Posted: Mon Jun 02, 2003 11:12 pm Post subject:

Don't feel stupid. Because I read this post, now I can tell the next person who has this question how it can be fixed, or they'll (hopefully) search and find out on their own. That's a Good Thing.

pilla · Posted: Tue Jun 03, 2003 12:09 pm Post subject:

Moving to OTG
_________________
"I'm just very selective about the reality I choose to accept." -- Calvin