Re: [ADMIN] A couple of errors encountered in 7.1.3=>7.2.1-2 data migration

2002-05-13 Thread Ray Ontko
Tom, et al, > > ERROR: cannot find attribute 1 of relation schedule_notification_log > > This is more disturbing. Can you provide the sequence of commands that > led up to it? Here are a few related datapoints. 1) We think that schedule_notification_log is the only table that we loaded fr

Re: [ADMIN] VACUUM FULL

2002-05-13 Thread Brian McCane
On Sun, 12 May 2002, Dan Langille wrote: > > On 12 May 2002 at 12:49, Brian McCane wrote: > > > I am on FreeBSD 5.0. > > There is a reason why you must be on 5.0? That is not recommended for > "sane" people. > > 5.0 is -current and not the best place to be running important > applications At p

[ADMIN] help me out on installation!!!

2002-05-13 Thread Tao Wan
Hi, all, I am installing postgresql-7.1.2 on Linux 2.4.12. I did configure with only one option --prefix= when I did make ( I am using gnu make 3.78.1 and gcc 2.95.2), I got errors below: ... gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations command.o common.o help.o input.o st

[ADMIN] upgrade?

2002-05-13 Thread Jodi Kanter
We are still running 7.1.3. Can anyone highlight the big differences or reasons to upgrade? Is there some documentation on this? Thanks Jodi ___Jodi L KanterBioInformatics Database AdministratorUniversity of Virginia(434) 924-2846[EMAIL PROTECTED]      

Re: [ADMIN] VACUUM FULL

2002-05-13 Thread Dan Langille
On 13 May 2002 at 8:20, Brian McCane wrote: > On Sun, 12 May 2002, Dan Langille wrote: > > > > > On 12 May 2002 at 12:49, Brian McCane wrote: > > > > > I am on FreeBSD 5.0. > > > > There is a reason why you must be on 5.0? That is not recommended for > > "sane" people. > > > > 5.0 is -current a

Re: [ADMIN] help me out on installation!!!

2002-05-13 Thread Tom Lane
Tao Wan <[EMAIL PROTECTED]> writes: > I am installing postgresql-7.1.2 on Linux 2.4.12. Just out of curiosity, why aren't you installing 7.2.1? Even if you have some reason to want to use a 7.1.* release, 7.1.3 would be the preferred choice. Dunno about the _fxstat problem. Looking at /usr/in

Re: [ADMIN] upgrade?

2002-05-13 Thread Tom Lane
Jodi Kanter <[EMAIL PROTECTED]> writes: > We are still running 7.1.3. Can anyone highlight the big differences or rea= > sons to upgrade? Is there some documentation on this? The release notes always mention the main improvements. Quoting from http://www.ca.postgresql.org/users-lounge/docs/7.2/p

[ADMIN] unregister steven@tie.cl

2002-05-13 Thread Steven Cuthbertson
---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] upgrade?

2002-05-13 Thread Gareth Kirwan
Yes there is documentation, yes there are changes. if you're happy with what you're on, don't bother. The main change I noticed was that it no longer allows the illegal syntax of  = NULL ( I KNOW I KNOW, but I liked using it! :p)     From the History file in Redhat RPM documentation for 7

[ADMIN] root account needed??

2002-05-13 Thread Tao Wan
Hi, all, just wonder whether I a root account required to install pgSql on Linux? Thanks Tony ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that yo

Re: [ADMIN] configure datatype name > 31?

2002-05-13 Thread Tom Lane
"Mark McEahern" <[EMAIL PROTECTED]> writes: > Tom, thanks for your reply. I am now able to create databases and users > with longer names, but I am unable to login with the long username. I think you're stuck on that, unless you want to be *really* incompatible with the rest of the world. The s

Re: [ADMIN] root account needed??

2002-05-13 Thread Stephan Szabo
On Mon, 13 May 2002, Tao Wan wrote: > just wonder whether I a root account required to install pgSql on Linux? You shouldn't need a root account to install from source, although you'll almost certainly need to give a prefix to configure to put it in some place the user has access to write to (si