Thread: 7.0.2 questions on encoding and compilation

7.0.2 questions on encoding and compilation

From
Date:
Currently, I'm using the the 7.0.2 rpms from the postgresql.org
on a RH6.2 install.

I have a few questions on it and the use of the -E flag.

1 - can 7.0.2 be optimized for i686 architecture or is
it only possible to compile for i386 architecture?

2 - Can createdb -E someencoding be used "straight out of the box"
with Postgresql 7.0.2 or does support need to be compiled into
the function?

3 - What are the list of arguments which can be taken with the
command createdb -E  ?



Thanks!




Max Pyziur                                     BRAMA - Gateway Ukraine
pyz@brama.com                                  http://www.brama.com/

Re: 7.0.2 questions on encoding and compilation

From
Dana Hudes
Date:
I have compiled for i686 by hacking up my RPM compile environment.

On Wed, 30 Aug 2000 pyz@panix.com wrote:

> Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> on a RH6.2 install.
>
> I have a few questions on it and the use of the -E flag.
>
> 1 - can 7.0.2 be optimized for i686 architecture or is
> it only possible to compile for i386 architecture?
>
> 2 - Can createdb -E someencoding be used "straight out of the box"
> with Postgresql 7.0.2 or does support need to be compiled into
> the function?
>
> 3 - What are the list of arguments which can be taken with the
> command createdb -E  ?
>
>
>
> Thanks!
>
>
>
>
> Max Pyziur                                     BRAMA - Gateway Ukraine
> pyz@brama.com                                  http://www.brama.com/
>


Re: 7.0.2 questions on encoding and compilation

From
Max Pyziur
Date:

On Wed, 30 Aug 2000, Dana Hudes wrote:

> I have compiled for i686 by hacking up my RPM compile environment.

Exactly, what settings do you use?

MP

> On Wed, 30 Aug 2000 pyz@panix.com wrote:
>
> > Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> > on a RH6.2 install.
> >
> > I have a few questions on it and the use of the -E flag.
> >
> > 1 - can 7.0.2 be optimized for i686 architecture or is
> > it only possible to compile for i386 architecture?
> >
> > 2 - Can createdb -E someencoding be used "straight out of the box"
> > with Postgresql 7.0.2 or does support need to be compiled into
> > the function?
> >
> > 3 - What are the list of arguments which can be taken with the
> > command createdb -E  ?
> >
> >
> >
> > Thanks!
> >
> >
> >
> >
> > Max Pyziur                                     BRAMA - Gateway Ukraine
> > pyz@brama.com                                  http://www.brama.com/
> >
>
>


Re: 7.0.2 questions on encoding and compilation

From
"Igor N. Avtaev"
Date:
pyz@panix.com wrote:

> Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> on a RH6.2 install.
>
> I have a few questions on it and the use of the -E flag.
>
> 1 - can 7.0.2 be optimized for i686 architecture or is
> it only possible to compile for i386 architecture?

Yes. Changed C compilation flags in template file for your operating
system.

>
> Max Pyziur                                     BRAMA - Gateway Ukraine
> pyz@brama.com                                  http://www.brama.com/


Re: [SQL] Re: 7.0.2 questions on encoding and compilation

From
Max Pyziur
Date:

On Thu, 31 Aug 2000, Igor N. Avtaev wrote:

> pyz@panix.com wrote:
>
> > Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> > on a RH6.2 install.
> >
> > I have a few questions on it and the use of the -E flag.
> >
> > 1 - can 7.0.2 be optimized for i686 architecture or is
> > it only possible to compile for i386 architecture?
>
> Yes. Changed C compilation flags in template file for your operating
> system.

Could you please specify which flags are necessary?

Thanks!


> >
> > Max Pyziur                                     BRAMA - Gateway Ukraine
> > pyz@brama.com                                  http://www.brama.com/
[recycle]



RE: 7.0.2 questions on encoding and compilation

From
Max Pyziur
Date:

On Wed, 6 Sep 2000, vijayendra mohan agrawal wrote:

> 2. createdb -E option can be used, but it seems it needs a re-compilation
> which will make "pg_encoding" in your pgsql/bin directory. configure
> with --enable-multibyte option and re-install postgreSQL... it should serve
> the purpose.

What if you just want to use single byte encodings such as
Windows-CP1251?  Which configuration option should you use?

> 3. execute "createdb --help" for more details. --encoding=ENCODING should be
> given for creating db with encoding, here "ENCODING" is the type of encoding
> you want...
>
> Hope this helps...
>
> Thanks and regards,

Thanks!  and I have read the README.mb file.

> Vijay

Max Pyziur


> -----Original Message-----
> From: pgsql-admin-owner@hub.org [mailto:pgsql-admin-owner@hub.org]On
> Behalf Of pyz@panix.com
> Sent: Thursday, August 31, 2000 2:33 AM
> To: pgsql-sql@postgresql.org; pgsql-admin@hub.org
> Subject: [ADMIN] 7.0.2 questions on encoding and compilation
>
>
> Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> on a RH6.2 install.
>
> I have a few questions on it and the use of the -E flag.
>
> 1 - can 7.0.2 be optimized for i686 architecture or is
> it only possible to compile for i386 architecture?
>
> 2 - Can createdb -E someencoding be used "straight out of the box"
> with Postgresql 7.0.2 or does support need to be compiled into
> the function?
>
> 3 - What are the list of arguments which can be taken with the
> command createdb -E  ?
>
>
>
> Thanks!
>
>
>
>
> Max Pyziur                                     BRAMA - Gateway Ukraine
> pyz@brama.com                                  http://www.brama.com/
>
>


Re: [SQL] Re: 7.0.2 questions on encoding and compilation

From
Dana Hudes
Date:
RTFM for gcc
-mcpu=i686

On Wed, 6 Sep 2000, Max Pyziur wrote:

>
>
> On Thu, 31 Aug 2000, Igor N. Avtaev wrote:
>
> > pyz@panix.com wrote:
> >
> > > Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> > > on a RH6.2 install.
> > >
> > > I have a few questions on it and the use of the -E flag.
> > >
> > > 1 - can 7.0.2 be optimized for i686 architecture or is
> > > it only possible to compile for i386 architecture?
> >
> > Yes. Changed C compilation flags in template file for your operating
> > system.
>
> Could you please specify which flags are necessary?
>
> Thanks!
>
>
> > >
> > > Max Pyziur                                     BRAMA - Gateway Ukraine
> > > pyz@brama.com                                  http://www.brama.com/
> [recycle]
>
>


Re: [SQL] Re: 7.0.2 questions on encoding and compilation

From
"Igor N. Avtaev"
Date:
Max Pyziur wrote:

> On Thu, 31 Aug 2000, Igor N. Avtaev wrote:
>
> > pyz@panix.com wrote:
> >
> > > Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> > > on a RH6.2 install.
> > >
> > > I have a few questions on it and the use of the -E flag.
> > >
> > > 1 - can 7.0.2 be optimized for i686 architecture or is
> > > it only possible to compile for i386 architecture?
> >
> > Yes. Changed C compilation flags in template file for your operating
> > system.
>
> Could you please specify which flags are necessary?

For my OS - SCO UnixWare 2.1.3 (with SCO SDK):
    -K pentium
or
    -K p6

> Thanks!
>
>
> > >
> > > Max Pyziur                                     BRAMA - Gateway Ukraine
> > > pyz@brama.com                                  http://www.brama.com/
> [recycle]
>

Best regards, Igor