Обсуждение: 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
От
"visolve postgres "
Дата:
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