On Saturday 09 March 2002 01:21, Felipe Nascimento wrote:
> Is there a max length (number of characters) to column names??
>
> I received the following:
> identifier "petb_convidado_partida_participante" will be truncated to
> "petb_convidado_partida_particip"
>
> Tks
> Felipe
system identifiers a
Try this on for size... recently during a reboot (first in about 3 months for
this particular server) our entire rc.d directory failed to start... after some
hacking of the rc file to output some helpful debuggin, it was apparent that the
010.pgsql.sh script in /usr/local/etc/rc.d was timing ou
"Dave" <[EMAIL PROTECTED]> writes:
> DEBUG: Data Base System is starting up at Sat Mar 9 17:05:45 2002
> DEBUG: Data Base System was shut down at Sat Mar 9 17:05:39 2002
> DEBUG: Data Base System is in production state at Sat Mar 9 17:05:45 2002
> Fast Shutdown request at Sat Mar 9 17:05:48
Sorry, should point out that the stop is resulting from executing a ^c after
running the script manually. Since the script runs... postgres starts, but
from reading the startup script, it is waiting for the pid file to appear before
reporting suscess... and it isn't doing this. Or at least no
hold the farm...
>>> Try this on for size... recently during a reboot (first in about 3
>>months for
>>> this particular server) our entire rc.d directory failed to start...
>> after some
>>> hacking of the rc file to output some helpful debuggin, it was
>>apparent that the
>>> 010.pgsql.sh scr
On Sun, 10 Mar 2002, Dave wrote:
I use the following lines (at /usr/local/etc/rc.d/pgsql.sh)
-- 8< --
#!/bin/sh
PGBIN=/usr/local/pgsql/bin
cmd="$1"
: ${cmd:=start}
case $cmd in
start)
[ -d /usr/local/pgsql/lib ] && /sbin/ldconfig -m /usr/local/pgsql/lib
[ -x ${PGBIN}/pg_ctl ] && {
On Sun, Mar 10, 2002 at 09:11:11AM -0500 I heard the voice of
Dave, and lo! it spake thus:
> Try this on for size... recently during a reboot (first in about 3 months for
> this particular server) our entire rc.d directory failed to start... after some
> hacking of the rc file to output some he
Bingo! Dumb move. Dropped everything to password a few months back, never had
the occasion to restart after that. Will work on tweaking the pg_hba.conf
Thanks Matthew... if you are ever in Toronto, I owe you a beer.
Dave
>At a guess, you've set it up to not automatically trust local users,
so rarely have problems with postgres that setup or reconfigs are few and far
between. In reviewing the docs on this after a recent config error, I am asking
for assistance to acid test the following config file.
running version 7.0
current pg_hba.conf contains//
localall
"Dave" <[EMAIL PROTECTED]> writes:
> running version 7.0
7.0? Not even 7.0.something? You really ought to update.
But I digress...
> current pg_hba.conf contains//
> localall trust
> host sameuser127.0.0.1 255.255.255.255 pa
Hi guys,
I wonder how do I warrant group exclusion in postgres?
I'm thinking about creating a rule, but how do I get the usesysid of the
user to be added. Any hint or any other idea to solve the problem
Thanks and regards,
Denis.
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx
>> running version 7.0
>7.0? Not even 7.0.something? You really ought to update.
Havn't seen anyting critical requiring an upgrade... call it laziness or not
wanting to fix something that isn't broke and causing problems. This security
issue may end up being that reason though.
>But I digres
12 matches
Mail list logo
