[ADMIN] remove

2006-06-08 Thread Thomas LeBlanc
remove > Subject: Re: [ADMIN] Database wont start anyway > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: [email protected] > Date: Thu, 8 Jun 2006 18:12:55 +0200 > > Am Donnerstag, den 08.06.2006, 11:44 +0200 schrieb Fourat Zouari: > >

Re: [ADMIN] Maximum text and bytea size?

2006-06-08 Thread Jim C. Nasby
On Thu, Jun 08, 2006 at 11:55:02AM -0400, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > On Thu, Jun 08, 2006 at 11:18:02AM +0200, Ludek Finstrle wrote: > >> I read this value in TOAST section. Is my opinion correct? > > > From http://www.postgresql.org/docs/8.1/interactive/stora

Re: [ADMIN] Database wont start anyway

2006-06-08 Thread Susanne Ebrecht
Am Donnerstag, den 08.06.2006, 11:44 +0200 schrieb Fourat Zouari: > Hello all, > My database wont start, here's the log : > > tux2:~# /etc/init.d/postgresql-8.1 start > Starting PostgreSQL 8.1 database server: main* perl: warning: Setting > locale failed. > perl: warning: Please check that your lo

Re: [ADMIN] Database wont start anyway

2006-06-08 Thread Tom Lane
"Fourat Zouari" <[EMAIL PROTECTED]> writes: > Error: The server must be started under the locale [EMAIL PROTECTED] which > does not > exist any more. > what's the problem ? The error message seems reasonably clear to me... check what you've got installed in the way of locale packages.

Re: [ADMIN] Maximum text and bytea size?

2006-06-08 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Thu, Jun 08, 2006 at 11:18:02AM +0200, Ludek Finstrle wrote: >> I read this value in TOAST section. Is my opinion correct? > From http://www.postgresql.org/docs/8.1/interactive/storage-toast.html: > "TOAST usurps the high-order two bits of the varlen

Re: [ADMIN] Maximum text and bytea size?

2006-06-08 Thread Jim C. Nasby
On Thu, Jun 08, 2006 at 11:18:02AM +0200, Ludek Finstrle wrote: > Hello, > > I'm not sure if I understand documentation the right way. > Is the maximum size for text and bytea types 2^30-1 bytes? > I read this value in TOAST section. Is my opinion correct? >From http://www.postgresql.org/docs/8

Re: [ADMIN] Database wont start anyway

2006-06-08 Thread Aaron Bono
My guess is that [EMAIL PROTECTED] is not a valid value for LANG.  You can see a list of acceptable language identifiers in the RFC at http://www.i18nguy.com/unicode/language-identifiers.html .-AaronOn 6/8/06, Fourat Zouari <[EMAIL PROTECTED]> wrote: Hello all,My database wont start, here's the lo

[ADMIN] Database wont start anyway

2006-06-08 Thread Fourat Zouari
Hello all,My database wont start, here's the log :tux2:~# /etc/init.d/postgresql-8.1 startStarting PostgreSQL 8.1 database server: main* perl: warning: Setting locale failed.perl: warning: Please check that your locale settings:     LANGUAGE = "fr_TN:fr_FR:fr:en_GB:en",    LC_ALL = (unset),

[ADMIN] Maximum text and bytea size?

2006-06-08 Thread Ludek Finstrle
Hello, I'm not sure if I understand documentation the right way. Is the maximum size for text and bytea types 2^30-1 bytes? I read this value in TOAST section. Is my opinion correct? Thanks, Luf ---(end of broadcast)--- TIP 3: Have you checked o