Thread: 7.1-1 installation from RPM

7.1-1 installation from RPM

From
"Mihai Gheorghiu"
Date:
I installed PostgreSQL 7.1-1 from RPM on RH7.0 (I used GNOrpm).
Then I opened a terminal and ran
/etc/rc.d/init.d/postgresql start
chkconfig --add postgresql
as per README_rpm-dist (Lamar Owen)
psql works OK, pgaccess displays an error message
(PQConnectPoll() --connect() failed... check if postmaster is running and is
listening on port 5432)
I checked postgresql.conf: it is all #'ed lines.
I uncommented and made changes so that now the uncommented lines look like:
tcpip_socket = true
ssl = false
max_connections = 32 # 1-1024
port = 5432
shared_buffers = 2*max_connections # min 16
I tried to restart postmaster:
/etc/rc.d/init.d/postgresql restart
Shutsdown OK, then
Checking postgresql installation  [OK]
Starting postgresql service  [FAILED]

Where do I need to make changes?

Thanks in advance,

 Mihai


Re: 7.1-1 installation from RPM

From
Lamar Owen
Date:
Mihai Gheorghiu wrote:
> /etc/rc.d/init.d/postgresql restart
> Shutsdown OK, then
> Checking postgresql installation  [OK]
> Starting postgresql service  [FAILED]

_I_ need to make some changes. For the time being, don't use restart.
This will be fixed for 7.1.1, which I hope to have built by this time
tomorrow.

/etc/rc.d/init.d/postgresql start by now should succeed.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Re: 7.1-1 installation from RPM

From
Peter Eisentraut
Date:
Mihai Gheorghiu writes:

> I uncommented and made changes so that now the uncommented lines look like:
> tcpip_socket = true
> ssl = false
> max_connections = 32 # 1-1024
> port = 5432
> shared_buffers = 2*max_connections # min 16

This won't work.  No arithmetic allowed.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


Re: 7.1-1 installation from RPM

From
Bruce Momjian
Date:
> Mihai Gheorghiu writes:
>
> > I uncommented and made changes so that now the uncommented lines look like:
> > tcpip_socket = true
> > ssl = false
> > max_connections = 32 # 1-1024
> > port = 5432
> > shared_buffers = 2*max_connections # min 16
>
> This won't work.  No arithmetic allowed.

Sorry, that is my fault.  I will fix it and move the 2* into the
comment.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Function to detect trigger recursion

From
Vincent Roberts
Date:
Hello:

Is there a builtin mechanism for detecting trigger recursion or more
specifically
one trigger , causing another tables trigger to fire.

Example:

Table A is updated

Table A's update trigger executes
{
    Updates the B table - (maintaining special RI etc.)
    Table B's update trigger executes
     {
           <does some stuff>
           <need to know if I was triggered from within another trigger> ?????
( Is there a function that does this? )
           <does some more stuff>
      }
}

Attachment