Re: [ADMIN] is postgresql 8 is realy mature

2005-03-28 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Tsirkin Evgeny) wrote: > Hi list! > We are using currently postgresql 7.3.4 havily and planning an upgrade. > our choices are either 7.4.x which comes with distribution (suse) or 8.0.1 . > We can allow our selfs some testing time and m

Re: [ADMIN] createlang problem with 8, what is correct?

2005-03-28 Thread Tom Lane
Tad Marko <[EMAIL PROTECTED]> writes: > However, I can make it work with > createlang -U postgres plpgsql dbname > Is the latter preferred, or do I have something misconfigured? Createlang has to be done as a superuser. regards, tom lane ---(end

[ADMIN] createlang problem with 8, what is correct?

2005-03-28 Thread Tad Marko
Howdy! createlang -U dbuser plpgsql dbname Results in: createlang: language installation failed: ERROR: permission denied for language c However, I can make it work with createlang -U postgres plpgsql dbname Is the latter preferred, or do I have something misconfigured? Thanks, Ta

Re: [ADMIN] is postgresql 8 is realy mature

2005-03-28 Thread Frank L. Parks
For SuSE, you can currently get the 8.0.1 RPMs at ftp://ftp.suse.com/pub/projects/postgresql/. I don't know when they will post the 8.0.2 RPMs. I recently upgraded from 7.3.x to 8.0.1 on 9.0 and as long as you remember to do the pg_dumpall and then the restore (psql) everything should go smoothly

Re: [ADMIN] is postgresql 8 is realy mature

2005-03-28 Thread Tom Lane
Scott Marlowe <[EMAIL PROTECTED]> writes: > On Mon, 2005-03-28 at 03:52, Tsirkin Evgeny wrote: >> So the question is if the 8.0.1 is really well tested > 7.4.7 is very stable, and has had about two years shake down time, > counting beta testing. 8.0 is quite a bit newer, and to top it off, > incl

Re: [ADMIN] is postgresql 8 is realy mature

2005-03-28 Thread Bruno Wolff III
On Mon, Mar 28, 2005 at 11:52:34 +0200, Tsirkin Evgeny <[EMAIL PROTECTED]> wrote: > > Hi list! > We are using currently postgresql 7.3.4 havily and planning an upgrade. > our choices are either 7.4.x which comes with distribution (suse) or 8.0.1 . > We can allow our selfs some testing time and m

Re: [ADMIN] is postgresql 8 is realy mature

2005-03-28 Thread Scott Marlowe
On Mon, 2005-03-28 at 03:52, Tsirkin Evgeny wrote: > Hi list! > We are using currently postgresql 7.3.4 havily and planning an upgrade. > our choices are either 7.4.x which comes with distribution (suse) or 8.0.1 . > We can allow our selfs some testing time and minor changes in applications > if ne

[ADMIN] problems with user rights

2005-03-28 Thread Zouari Fourat
Hello, i've just added a new user called xxx : create user xxx with password zzz; now am creating it's database : create database db_xxx with owner xxx; it works fine althought when logging with the user xxx i can still view other databases contents especially pg_catalog schems. is it the rig

Re: [ADMIN] PostgreSQL: ´GRANT ALL TO PUBLIC´ ?

2005-03-28 Thread John DeSoi
On Mar 22, 2005, at 12:19 PM, Dr. Roger Wießner wrote: Is there an easy way to ´GRANT ALL TO PUBLIC´? It is very tedious to write all the necessary grant-statements... You can find some functions to do this at http://pgedit.com/node/view/20 John DeSoi, Ph.D. http://pgedit.com/ Power Tools for Post

[ADMIN] is postgresql 8 is realy mature

2005-03-28 Thread Tsirkin Evgeny
Hi list! We are using currently postgresql 7.3.4 havily and planning an upgrade. our choices are either 7.4.x which comes with distribution (suse) or 8.0.1 . We can allow our selfs some testing time and minor changes in applications if needed but of course this is good to avoid . So the question is