[ADMIN] ERROR: fmgr_info: function 19104: cache lookup failed

2000-06-26 Thread Michael Fraley
Hello, I just upgraded from 6.5.2 to 7.0.2 on SuSE 6.4 Linux, and now I get this message when trying to insert records: ERROR: fmgr_info: function 19104: cache lookup failed This only happens on tables that use refint.so (under contrib/spi in the source distribution). There is a trigger that c

Re: [ADMIN] Administration tips

2000-06-26 Thread Dmitry Morozovsky
On 26 Jun 2000, Camm Maguire wrote: CM> Both of these basically depend on 'pg_dump | psql'. From what I CM> understand now, the pg_dump has to be executed on the db host unless CM> user checking across the network is disabled with a 'trust' entry in CM> hba.conf, as pg_dump needs to connect as p

[ADMIN] Administration tips

2000-06-26 Thread Camm Maguire
Greetings! Being new to this list, and moderately new to postgresql, I would like to ask those with experience about the best ways to maintain postgresql databases. What I am principally concerned with are 1) the ease of (nightly) backups and replications 2) ease of upgrades to future postgresq

[ADMIN] connection time-out

2000-06-26 Thread stanislas pinte
hello, I am running postgresql with the JDBC7.0 driver, and I get a connection time-out after some idle time...where is it possible to set the time-out parameter? thanks a lot? Stan.

Re: [ADMIN] Unable to get psql compiled

2000-06-26 Thread thierry
On Fri, 23 Jun 2000, Guoben Li wrote: > tab-complete.o(.text+0x74): undefined reference to > `rl_completion_append_character' > >Any hint/help is appreciated. > install 'GNU readline' library. -- Thierry Boudet -=- GNU/Linux operator -=- http://www.123immo.com/ [EMAIL PRO