Thread: PostgreSQl 7.4.2 not working on HP PA 11.11& HP IPF 11.22 in 64 bit build

PostgreSQl 7.4.2 not working on HP PA 11.11& HP IPF 11.22 in 64 bit build

From
"visolve postgres "
Date:
Hello All,
                    PostgreSQL 7.4.2 32 bit build and test works fine on HP PA 11.11 & IPF 11.22 . But 64 bit build
on HP PA & IPF  failed during the testing.

$ ./postmaster -D /var/opt/iexpress/postgresql &
[1]     2410
$ LOG:  could not resolve "localhost": host nor service provided, or not known
LOG:  database system was shut down at 2004-03-26 00:54:37 PST
LOG:  checkpoint record is at 0/9DE158
LOG:  redo record is at 0/9DE158; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 536; next OID: 17142
LOG:  database system is ready
$

$ ./createdb test
FATAL:  no pg_hba.conf entry for host "???", user "postgres", database "template1", SSL off
createdb: could not connect to database template1: FATAL:  no pg_hba.conf entry for host "???", user "postgres",
database "template1", SSL off

$ ./createdb -h 127.0.0.1 test
createdb: could not connect to database template1: could not connect to server: Not owner
        Is the server running on host "127.0.0.1" and accepting
        TCP/IP connections on port 5432?

Any help would be much appreciated.

Regs,
Durai.

Lycos Email has 10 MB of FREE storage space. http://mail.lycos.co.uk


"visolve postgres " <visolve_postgres@lycos.co.uk> writes:
>                     PostgreSQL 7.4.2 32 bit build and test works fine on HP PA 11.11 & IPF 11.22 . But 64 bit build
> on HP PA & IPF  failed during the testing.

You built this exactly how?

            regards, tom lane

Hi,
        I used the
following steps to
build on both HP PA
& IPF for 32 & 64
bit.

 /configure
--prefix=/opt/iexpress/postgresql
--enable-integer-datetimes
--with-openssl
--with-krb5
gmake
gmake install

On 32 bit build no
issue found.
During 64 bit build
on HPUX PA 11.11, I
got the following
error :

/usr/local/pa20_64/bin/gcc
-O2
-fno-strict-aliasing
-Wall
-Wmissing-prototypes
-Wmissing-declarations
-c tas.s
tas.s: Assembler
messages:
tas.s:2: Error:
unsupported variable
size or fill value
tas.s:2: Warning:
rest of line
ignored; first
ignored character is
`='
tas.s:3: Error:
unknown pseudo-op:
`.subspa'
tas.s:22: Error:
unknown pseudo-op:
`.subspa'
 ....

To resolve, I
removed tas.s and
created the tas.s
file using 64 bit
gcc.

/usr/local/pa20_64/bin/gcc
-O2 -S -c tas.c and
replaced ldw with
ldcwx in tas.s.

After that build is
ok. But test( 32 &
64  bit)  failed on
both PA & IPF.

$ ./postmaster -D
/var/opt/iexpress/postgresql
&
[1]     2410
$ LOG:  could not
resolve "localhost":
host nor service
provided,
or not known
LOG:  database
system was shut down
at 2004-03-26
00:54:37 PST
LOG:  checkpoint
record is at
0/9DE158
LOG:  redo record is
at 0/9DE158; undo
record is at 0/0;
shutdown TRUE
LOG:  next
transaction ID: 536;
next OID: 17142
LOG:  database
system is ready
$

$ ./createdb test
FATAL:  no
pg_hba.conf entry
for host "???", user
"postgres",
database
"template1", SSL off
createdb: could not
connect to database
template1: FATAL:
no pg_hba.conf
entry for host
"???", user
"postgres",
database
"template1", SSL off

$ ./createdb -h
127.0.0.1 test
createdb: could not
connect to database
template1: could not
connect to
server: Not owner
        Is the
server running on
host "127.0.0.1" and
accepting
        TCP/IP
connections on port
5432?

Note:
I used 64 bit gcc.
The version is

#
/usr/local/pa20_64/bin/gcc
-v
Reading specs from
/usr/local/pa20_64/lib/gcc-lib/hppa64-hp-hpux11.00/3.2/specs
Configured with:
 ./gcc/configure
--prefix=/usr/local/pa20_64
--enable-languages
=c,c++
--host=hppa64-hp-hpux11.00
--target=hppa64-hp-hpux11.00
--with-ld=/usr/cc
s/bin/ld
--with-gnu-as
--enable-libstdcxx-v3
--disable-checking
Thread model: single
gcc version 3.2
20020708
(experimental)

Regs,
Durai.


------- Original
message -------
From: Tom Lane
<tgl@sss.pgh.pa.us>
Date: Fri, 26 Mar
2004 00:38:27 -0500
Subject: Re:
[GENERAL] PostgreSQl
7.4.2 not working on
HP PA 11.11& HP IPF
11.22 in 64 bit
build

"visolve postgres "
 writes:
>
  PostgreSQL 7.4.2
32 bit build and
test works fine on
HP PA 11.11 & IPF
11.22 . But 64 bit
build
> on HP PA & IPF
failed during the
testing.

You built this
exactly how?

   regards, tom lane

Lycos Email has 10 MB of FREE storage space. http://mail.lycos.co.uk


�
Hi,
        I used the following steps to build on both HP PA & IPF for 32 & 64 bit.

 /configure --prefix=/opt/iexpress/postgresql --enable-integer-datetimes --with-openssl --with-krb5
gmake
gmake install

On 32 bit build no issue found.
During 64 bit build on HPUX PA 11.11, I got the following error :

/usr/local/pa20_64/bin/gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -c tas.s
tas.s: Assembler messages:
tas.s:2: Error: unsupported variable size or fill value
tas.s:2: Warning: rest of line ignored; first ignored character is `='
tas.s:3: Error: unknown pseudo-op: `.subspa'
tas.s:22: Error: unknown pseudo-op: `.subspa'
tas.s:23: Error: unsupported variable size or fill value
tas.s:23: Warning: rest of line ignored; first ignored character is `='
tas.s:24: Error: unknown pseudo-op: `.subspa'
tas.s:26: Error: unknown pseudo-op: `.subspa'

To resolve, I removed tas.s and created the tas.s file using 64 bit gcc.

/usr/local/pa20_64/bin/gcc -O2 -S -c tas.c and replaced ldw with ldcwx in tas.s.

After that build is ok. But test( 32 & 64  bit)  failed on both PA & IPF.

$ ./postmaster -D /var/opt/iexpress/postgresql &
[1]     2410
$ LOG:  could not resolve "localhost": host nor service provided,
or not known
LOG:  database system was shut down at 2004-03-26 00:54:37 PST
LOG:  checkpoint record is at 0/9DE158
LOG:  redo record is at 0/9DE158; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 536; next OID: 17142
LOG:  database system is ready
$

$ ./createdb test
FATAL:  no pg_hba.conf entry for host "???", user "postgres",
database "template1", SSL off
createdb: could not connect to database template1: FATAL:  no pg_hba.conf
entry for host "???", user "postgres",
database "template1", SSL off

$ ./createdb -h 127.0.0.1 test
createdb: could not connect to database template1: could not connect to
server: Not owner
        Is the server running on host "127.0.0.1" and accepting
        TCP/IP connections on port 5432?
Note:
I used 64 bit gcc.
The version is

$ /usr/local/pa20_64/bin/gcc -v
Reading specs from /usr/local/pa20_64/lib/gcc-lib/hppa64-hp-hpux11.00/3.2/specs
Configured with: ../gcc/configure --prefix=/usr/local/pa20_64 --enable-languages
=c,c++ --host=hppa64-hp-hpux11.00 --target=hppa64-hp-hpux11.00 --with-ld=/usr/cc
s/bin/ld --with-gnu-as --enable-libstdcxx-v3 --disable-checking
Thread model: single
gcc version 3.2 20020708 (experimental)

Regs,
Durai.


------- Original message -------�
From: Tom Lane <tgl@sss.pgh.pa.us>�
Date: Fri, 26 Mar 2004 00:38:27 -0500�
Subject: Re: [GENERAL] PostgreSQl 7.4.2 not working on HP PA 11.11& HP IPF 11.22 in 64 bit build �

"visolve postgres "  writes:
>                     PostgreSQL 7.4.2 32 bit build and test works fine on HP PA 11.11 & IPF 11.22 . But 64 bit build
> on HP PA & IPF  failed during the testing.

You built this exactly how?

   regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Lycos Email has 10 MB of FREE storage space. http://mail.lycos.co.uk