7.1-1 installation from RPM
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
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
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
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 16This 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
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>
}
}