[ADMIN] problem trying to su - postgres

2004-05-07 Thread Neil . Thompson
I'm a newbie to all things linux and have the following problem running red hat linux 9 i log into my pc, change to su - and type the password, all is ok and i get [EMAIL PROTECTED] I'm trying now to configure postgresql, which i installed with linux and it says to su - postgres, i do

Re: [ADMIN] problem trying to su - postgres

2004-05-07 Thread Radu-Adrian Popescu
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: | I'm a newbie to all things linux and have the following problem | | running red hat linux 9 i log into my pc, change to su - and type the | password, all is ok and i get [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] | | I'm

Re: [ADMIN] problem trying to su - postgres

2004-05-07 Thread Karel Zak
On Fri, May 07, 2004 at 09:54:42AM +0100, [EMAIL PROTECTED] wrote: I'm a newbie to all things linux and have the following problem running red hat linux 9 i log into my pc, change to su - and type the password, all is ok and i get [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] I'm trying

Re: [ADMIN] problem trying to su - postgres

2004-05-07 Thread Radu-Adrian Popescu
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: | many thanks | | For info I've installed it all from cd. | | I tried the whoami, and although the command prompt thing says -bash-2.05b$ | it did return postgres as the user, THANKS! | | also tried the rpm -qa | grep postgres,

[ADMIN] OID Overflow for large objects

2004-05-07 Thread Jeff Boes
We had a puzzling situation occur last weekend. Subsequently, I figured out how to work around it for now, but of course those who sign my checks want to know how we can nail down forever the possibility that something like that will ever happen again ... The OID value for large objects crossed

Re: [ADMIN] OID Overflow for large objects

2004-05-07 Thread Tom Lane
Jeff Boes [EMAIL PROTECTED] writes: I found some indication of the problem referenced in the Pg FAQ (http://www3.sk.postgresql.org/docs/faqs/FAQ.html): OIDs are stored as 4-byte integers, and will overflow at 4 billion. No one has reported this ever happening, and we plan to have the limit

[ADMIN] FW: Help installing pgSQL 7.4.2 on Solaris 9

2004-05-07 Thread Jeff Stout
I am trying to install pgSQL 7.4.2 on Solaris 9 I am using gcc 3.3.2, readline 4.3, perl 5.8, my full PATH is /usr/local/bin:/usr/local/sbin:/usr/ccs/bin:/usr/dt/bin:/usr/openwin/bin: \ /usr/bin:/usr/sbin After downloading and un-taring/un-ziping I run ./configure I don't see any errors.

Re: [ADMIN] FW: Help installing pgSQL 7.4.2 on Solaris 9

2004-05-07 Thread Jim Seymour
Jeff Stout [EMAIL PROTECTED] wrote: I am trying to install pgSQL 7.4.2 on Solaris 9 I am using gcc 3.3.2, readline 4.3, perl 5.8, my full PATH is /usr/local/bin:/usr/local/sbin:/usr/ccs/bin:/usr/dt/bin:/usr/openwin/bin: \ /usr/bin:/usr/sbin After downloading and un-taring/un-ziping