>I'm running a pretty stock 3.0 here, and have not had any problems. You
>need to show us what sort of errors you are seeing, though, since right
>now, all we have to work with is "it doesn't work" :(
>
>What does initdb show when you run it, start to finish?
>
First let me apologize for the length of the post.
The initdb stuff
----------
We are initializing the database system with username postgres (uid=1002).
This user will own all the files and must also own the server process.
Creating Postgres database system directory /u0/pgsql/data
Creating Postgres database system directory /u0/pgsql/data/base
Creating template database in /u0/pgsql/data/base/template1
Creating global classes in /u0/pgsql/data/base
Adding template1 database to pg_database...
Vacuuming template1
Creating public pg_user view
Creating view pg_rules
Creating view pg_views
Creating view pg_tables
Creating view pg_indexes
Loading pg_description
-------------------------------------------------------------------------
The regression stuff. Note that most of the tests passed.
These are exerpts from regression.diffs. I have deleted as much as I
could and still provide some (I hope) relevent info. Sorry about the
length.
=== int8 ===
expected
========
QUERY: SELECT '' AS five, q1 AS plus, -q1 AS minus FROM INT8_TBL;
five| plus| minus
! ----+----------------+-----------------
| 123| -123
| 123| -123
! |4567890123456789|-4567890123456789
! |4567890123456789|-4567890123456789
! |4567890123456789|-4567890123456789
(5 rows)
results
=======
QUERY: SELECT '' AS five, q1 AS plus, -q1 AS minus FROM INT8_TBL;
five| plus| minus
! ----+----------+---------
| 123| -123
| 123| -123
! |-869367531|869367531
! |-869367531|869367531
! |-869367531|869367531
(5 rows)
===============================================================
=== misc ===
expected
========
*** 6,518 ****
SET stringu1 = reverse_name(onek.stringu1)
WHERE onek.stringu1 = 'JBAAAA' and
onek.stringu1 = temp.stringu1;
! NOTICE: Non-functional update, only first update is performed
! NOTICE: Non-functional update, only first update is performed
! QUERY: UPDATE temp
! SET stringu1 = reverse_name(onek2.stringu1)
! WHERE onek2.stringu1 = 'JCAAAA' and
! onek2.stringu1 = temp.stringu1;
! NOTICE: Non-functional update, only first update is performed
! NOTICE: Non-functional update, only first update is performed
! QUERY: DROP TABLE temp;
! QUERY: COPY onek TO
'/usr/local/pgsql/postgresql-6.4.2/src/test/regress/input/../results/onek.da
ta';
! QUERY: DELETE FROM onek;
! QUERY: COPY onek FROM
'/usr/local/pgsql/postgresql-6.4.2/src/test/regress/input/../results/onek.da
ta';
! QUERY: SELECT unique1 FROM onek WHERE unique1 < 2;
! unique1
! -------
! 0
! 1
! (2 rows)
results
=======
--- 6,11 ----
SET stringu1 = reverse_name(onek.stringu1)
WHERE onek.stringu1 = 'JBAAAA' and
onek.stringu1 = temp.stringu1;
! pqReadData() -- backend closed the channel unexpectedly.
! This probably means the backend terminated abnormally before or
while processing the request.
! We have lost the connection to the backend, so further processing is
impossible. Terminating.
=====================================================================
=== plpgsql ===
expected
========
*** 872,1336 ****
QUERY: insert into Room values ('105', 'Office');
QUERY: insert into Room values ('106', 'Office');
QUERY: insert into WSlot values ('WS.001.1a', '001', '', '');
QUERY: insert into WSlot values ('WS.001.1b', '001', '', '');
QUERY: insert into WSlot values ('WS.001.2a', '001', '', '');
QUERY: insert into WSlot values ('WS.001.2b', '001', '', '');
QUERY: insert into WSlot values ('WS.001.3a', '001', '', '');
QUERY: insert into WSlot values ('WS.001.3b', '001', '', '');
QUERY: insert into WSlot values ('WS.002.1a', '002', '', '');
QUERY: insert into WSlot values ('WS.002.1b', '002', '', '');
QUERY: insert into WSlot values ('WS.002.2a', '002', '', '');
results
=======
--- 872,1256 ----
QUERY: insert into Room values ('105', 'Office');
QUERY: insert into Room values ('106', 'Office');
QUERY: insert into WSlot values ('WS.001.1a', '001', '', '');
+ ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: dlopen
(/usr/local/pgsql/lib/plpgsql.so) failed
QUERY: insert into WSlot values ('WS.001.1b', '001', '', '');
+ ERROR: Can't find function plpgsql_call_handler in file
/usr/local/pgsql/lib/plpgsql.so
QUERY: insert into WSlot values ('WS.001.2a', '001', '', '');
+ ERROR: Can't find function plpgsql_call_handler in file
/usr/local/pgsql/lib/plpgsql.so
I hope this helps
