I tried setting my postgresql.conf file as yours (below). No luck. I've read through
the manual that is how I knew about the "TCP/IP_SOCKET" setting. I then went through
the "postgresql.conf" file adding comments describing what each of the settings were
for. I did change the maximum connect
Ok.
This is the section concerning connection parameters of the
/var/lib/pgsql/data/postgresql.conf file. It works fine on my server.
There are many other options in this conf file. The best thing to do is
to read the Admin manual, if you want to understand the meaning of these
parameters.
fr
Alright, the problem was still there when I set the following (before I changed the
.../init.d/postgresql file):
PORT = 5432 ( this is the default, but I un-commented the line anyway)
TCPIP_SOCKET = true (this is what is supposed to determine if it will accept TCP/IP
connections, unless I am rea
Hi,
yes, it's working. But as Gordon mentionned it in an earlier post, your
init script will be destroyed when the rpms are updated.
I think you really should edit your postgresql.conf and configure it
correctly, in addition there are lots of interesting options you cannot
pass with the command
O.K. so how I got the problem fixed will be broken again if U get an update. The
original question still hasn't been answered then. You say to configure the TCP
socket . . .
Can you please be a little more forthcoming as to how this is done?
>>> [EMAIL PROTECTED] 11/22/02 10:15AM >>>
On Thu,
I think I've solved the problem. Here is how I did it
I edited the "/etc/rc.d/init.d/postgresql" file and added "-o -i" to the start and
restart command lines. The "-o" is a "pg_ctl" option for passing directives, in this
case "-i" to the "postmaster".
Just in case I also added an entry in th
Hi,
My mistake, you're perfectly right Gordon.
My workstation is indeed not configured to accept tcp/ip connections,
but the server (my other PC, with httpd php...) is. I wasn't looking in
the right machine !
As Gordon say, you should edit the postgresql.conf file and modify the
part called "C
On Thu, 2002-11-21 at 23:57, FredBriand wrote:
>
> I may mystake because I configured my serveur some times ago (i'm still
> using RH73!) and that's not the kind of thing I modify for fun, but if I
> remember well, and I think I do, postgresql's default conf is not to
> accept tcp/ip connection
Hi,
all this seems quite strange. In my configuration files, only pg_hba was
modified, as for postgresql.conf, every line is commented.
What is the exact error message when you try to connect? Because even if
postmaster start without the -i option, you should still be able to
connect to the se
On Thu, 2002-11-21 at 14:28, Daniel WELLS wrote:
> O.K. Maybe I haven't expressed myself very well. My question ,
> while you may have given me an answer, it wasn't clear enough for me
> to follow.
The advice was incorrect, look at the file:
/var/lib/pgsql/data/postgresql.conf
--
Psyche-lis
O.K. Maybe I haven't expressed myself very well. My question , while you may have
given me an answer, it wasn't clear enough for me to follow.
Here are the active lines in the "pg_hba.conf"
local all trust
hostall 127.0.0.1 255.255.255.255 trust
If "postgresql" is set to st
On Thu, 2002-11-21 at 08:21, Daniel WELLS wrote:
> PostgreSQL starts when the computer boots but it does not
> accept TCP/IP connection. I have to stop the service and start it on
> a command line with the "-i" option to get it to work. What do I need
> to do to get the service to startup corre
I think you should edit one of the configuration files:
/var/lib/pgsql/data/pg_hba.conf
and read carefully what's in.
fred
Daniel WELLS a écrit:
I'm at the dangerous level of between newbie and intermediate, so some of my questions may sound kinda dumb. I am doing some PHP / pgsql development
13 matches
Mail list logo