NetBSD/Alpha and PostgreSQL-current [was Re: NetBSD/Alpha and rkirkpat's patch] - Mailing list pgsql-bugs

On Sat, 30 Dec 2000, Thomas T. Thai wrote:

[...snip mail header...]
> i grabbed the CVS ball last night and tried to build it. i'm attaching a
> patch that made it possible to build -current on NetBSD/Alpha
> 1.5.1_ALPHA. i would appreciate it if you have cvs write access to
> integrate my patch back into the tree.
>
> after install, i did the regression test and it failed in the same way
> that 7.0.3+rkirkpat.patch did as described below (copy of my last post).

[...snip regression test outputs...]

i forgot to mention that i wasn't able to do the serial regression test
because it didn't find the right socket file in /tmp. however the parallel
test worked (with failed tests). i did run psql to verify that it can talk
to the running postmaster. serial regression worked in 7.0.3 though.

### Verify that postmaster is running ###################################
$ ps axj | grep postmaster
pgsql  18355     1 18355  3c280    0 I    p0   0:00.04 ./postmaster -D
/var/pgsql/data (postgres

$ whoami
pgsql

$ pwd
/usr/local/build/pgsql-current/src/test/regress

### start the serial regression test ####################################
$ gmake runtest
gmake -C ../../../contrib/spi REFINT_VERBOSE=1 refint.so autoinc.so
gmake[1]: Entering directory `/usr/local/build/pgsql-current/contrib/spi'
gmake[1]: `refint.so' is up to date.
gmake[1]: `autoinc.so' is up to date.
gmake[1]: Leaving directory `/usr/local/build/pgsql-current/contrib/spi'
/bin/sh ./pg_regress --schedule=./serial_schedule --multibyte=
(using postmaster on Unix socket, default port)
============== dropping database "regression"         ==============
psql: connectDBStart() -- connect() failed: No such file or directory
        Is the postmaster running locally
        and accepting connections on Unix socket '/tmp/.s.PGSQL.0'?
dropdb: database removal failed
============== creating database "regression"         ==============
psql: connectDBStart() -- connect() failed: No such file or directory
        Is the postmaster running locally
        and accepting connections on Unix socket '/tmp/.s.PGSQL.0'?
createdb: database creation failed
pg_regress: createdb failed

### Show that postmaster is still running ###############################
$ ps axj | grep postmaster
pgsql  18355     1 18355  3c280    0 I    p0   0:00.04 ./postmaster -D
/var/pgsql/data (postgres

### Verify that there is a socket file ##################################
$ ls -la /tmp | grep PGSQL
srwxrwxrwx   1 pgsql  wheel     0 Dec 30 18:01 .s.PGSQL.5432
-rw-------   1 pgsql  wheel    22 Dec 30 18:01 .s.PGSQL.5432.lock

### Verify that postmaster will respond to local clients ################
$ /usr/local/install/pgsql-current/bin/psql mydb
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

mydb=# select version();
                                     version
----------------------------------------------------------------------------------
 PostgreSQL 7.1beta1 on alpha-unknown-netbsdelf1.5.1., compiled by GCC
egcs-1.1.2
(1 row)

mydb=#