Thread: 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/
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/ >
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/ > > > >
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/
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]
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/ > >
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] > >
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