Re: Help with PostgreSQL startup

2002-11-22 Thread Daniel WELLS
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

Re: Help with PostgreSQL startup

2002-11-22 Thread FredBriand
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

Re: Help with PostgreSQL startup

2002-11-22 Thread Daniel WELLS
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

Re: Help with PostgreSQL startup

2002-11-22 Thread FredBriand
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

Re: Help with PostgreSQL startup

2002-11-22 Thread Daniel WELLS
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,

Re: Help with PostgreSQL startup

2002-11-22 Thread Daniel WELLS
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

Re: Help with PostgreSQL startup

2002-11-22 Thread FredBriand
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

Re: Help with PostgreSQL startup

2002-11-22 Thread Gordon Messmer
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

Re: Help with PostgreSQL startup

2002-11-22 Thread FredBriand
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

Re: Help with PostgreSQL startup

2002-11-21 Thread Gordon Messmer
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

Re: Help with PostgreSQL startup

2002-11-21 Thread Daniel WELLS
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

Re: Help with PostgreSQL startup

2002-11-21 Thread Gordon Messmer
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

Re: Help with PostgreSQL startup

2002-11-21 Thread FredBriand
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